<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<html>
<body>
<% String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPwd="123456";
String dbName="login";
String url1="jdbc:mysql://localhost:3306/"+dbName;
String url2="?user="+userName+"&password="+userPwd;
String url3="&useUnicode=true&characterEncoding=UTF-8";
String url=url1+url2+url3;
Class.forName(driverName);
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String sql="select * from logininfo";
ResultSet rs=stmt.executeQuery(sql);
%>
<%
String name1=request.getParameter("name");
String passwd=request.getParameter("pwd");
while (rs.next()){
if(name1.equals(rs.getString(1)) && passwd.equals(rs.getString(2)))
{ request.getRequestDispatcher("success.jsp").forward(request, response);}
else {
response.sendRedirect("fail.jsp");
}
}
%>
</body>
</html>
<%@ page import="java.sql.*" %>
<html>
<body>
<% String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPwd="123456";
String dbName="login";
String url1="jdbc:mysql://localhost:3306/"+dbName;
String url2="?user="+userName+"&password="+userPwd;
String url3="&useUnicode=true&characterEncoding=UTF-8";
String url=url1+url2+url3;
Class.forName(driverName);
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String sql="select * from logininfo";
ResultSet rs=stmt.executeQuery(sql);
%>
<%
String name1=request.getParameter("name");
String passwd=request.getParameter("pwd");
while (rs.next()){
if(name1.equals(rs.getString(1)) && passwd.equals(rs.getString(2)))
{ request.getRequestDispatcher("success.jsp").forward(request, response);}
else {
response.sendRedirect("fail.jsp");
}
}
%>
</body>
</html>
1128
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
