58,439
社区成员
发帖
与我相关
我的任务
分享请教大佬们
各位大佬我想问一下这个问题怎么解决啊
<%@ 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>
<%@ 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>
...全文
请发表友善的回复…
发表回复
ggggg.hh 2020-07-02
- 打赏
- 举报
先调用驱动，再连接数据库，再创建sql语句，再执行获得返回值，关闭连接。再将返回值进行判断调转
qq_39936465 2020-07-02
- 打赏
- 举报
没有导入驱动包
源者鬼道 2020-06-30
- 打赏
- 举报
Class.forName(driverName);放在驱动连接的上边。
weixin_48436316 2020-06-30
- 打赏
- 举报
Connection stmt = DriverManager.getConnection(dbURL,userName,userPwd);说是这个问题错了，我也不知道怎么改
