求一个用myeclipse +MySql做的简单的登录页面
2个回答
展开全部
login.jsp登录页面
<%@ page language="java" pageEncoding="gb2312"%>
<html>
<body>
<form method="post" action="check.jsp">
用户名<input type="text" name="user" ><br>
密码<input type="password" name="pwd" ><br>
<input type="submit" value="登录">
</form>
</body>
</html>
登录验证页面check.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%>
<%
String user=request.getParameter("user");
String pwd=request.getParameter("pwd");
String driverName="com.mysql.jdbc.Driver";
String username="root"; //数据库用户名
String password="123"; //密码
String dbName="student"; //数据库名
String tableName="book"; //表明
String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+username+"&password="+password;
Class.forName(driverName).newInstance();
Connection conn=DriverManager.getConnection(url);
String sql="select * from "+tableName+" where user='"+user+"' and pwd='"+pwd+"';
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
if(rs.next())
{ response.sendRedicrect("success.jsp"); //验证通过跳转到..
}else
{ response.sendRedicrect("false.jsp"); //验证失败腿转到...
}
rs.close();
stmt.close();
conn.close();
%>
<%@ page language="java" pageEncoding="gb2312"%>
<html>
<body>
<form method="post" action="check.jsp">
用户名<input type="text" name="user" ><br>
密码<input type="password" name="pwd" ><br>
<input type="submit" value="登录">
</form>
</body>
</html>
登录验证页面check.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%>
<%
String user=request.getParameter("user");
String pwd=request.getParameter("pwd");
String driverName="com.mysql.jdbc.Driver";
String username="root"; //数据库用户名
String password="123"; //密码
String dbName="student"; //数据库名
String tableName="book"; //表明
String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+username+"&password="+password;
Class.forName(driverName).newInstance();
Connection conn=DriverManager.getConnection(url);
String sql="select * from "+tableName+" where user='"+user+"' and pwd='"+pwd+"';
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
if(rs.next())
{ response.sendRedicrect("success.jsp"); //验证通过跳转到..
}else
{ response.sendRedicrect("false.jsp"); //验证失败腿转到...
}
rs.close();
stmt.close();
conn.close();
%>
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询
广告 您可能关注的内容 |