各位大佬我想問一下這個問題怎么解決啊
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>
<html>
<body>
<%
String username="";
String password="";
username=request.getParameter("username");
password=request.getParameter("password");
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=Login";
String userName="root";
String userPwd="sa";
String sql="select Username from users where Username='"+username+"'";
String sql1="select Password from users where Password='"+password+"'";
Connection stmt = DriverManager.getConnection(dbURL,userName,userPwd);
Class.forName(driverName);
Statement stmt1=stmt.createStatement();
Statement stmt2=stmt.createStatement();
ResultSet rs=stmt1.executeQuery(sql);
ResultSet rs1=stmt2.executeQuery(sql1);
if(rs.next()&&rs1.next())
{
request.getRequestDispatcher("suc.jsp").forward(request, response);
}else{
request.getRequestDispatcher("fail.jsp").forward(request, response);
}
%>
</body>
</html>
uj5u.com熱心網友回復：
Connection stmt = DriverManager.getConnection(dbURL,userName,userPwd);說是這個問題錯了，我也不知道怎么改uj5u.com熱心網友回復：
Class.forName(driverName);放在驅動連接的上邊。uj5u.com熱心網友回復：
先呼叫驅動，再連接資料庫，再創建sql陳述句，再執行獲得回傳值，關閉連接。再將回傳值進行判斷調轉uj5u.com熱心網友回復：
沒有匯入驅動包
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/44430.html
標籤：Eclipse
上一篇：java做租金計算器，求代碼講解