请教大佬们

weixin_48436316 2020-06-30 09:27:53

各位大佬我想问一下这个问题怎么解决啊
<%@ 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>

...全文

2978 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

ggggg.hh 2020-07-02

打赏
举报

先调用驱动，再连接数据库，再创建sql语句，再执行获得返回值，关闭连接。再将返回值进行判断调转

qq_39936465 2020-07-02

打赏
举报

引用楼主 weixin_48436316 的回复:

各位大佬我想问一下这个问题怎么解决啊 <%@ 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>

没有导入驱动包