JSP第八次作业
数据库test 中建个表 stu(stuid 主键 自动增长 ，用户名，密码，年龄)
1.设计一个注册页面，实现用户注册功能
2.设计一个登陆页面，实现用户名密码登陆
3.两个页面可以互相超链接
<body> <form method="post" action="zc.jsp"> 输入用户名：<input type="text" name="username"><br> 输入年龄：<input type="text" name="userage"><br> 输入密码：<input type="text" name="userpwd"><br> 确认密码：<input type="text" name="cuserpwd"><br> <input type="submit" value="注册"> </form> </body>
<body> <form action="logoin_yz.jsp" method="post"> 用户名：<input type="text" name="username"><br> 密码：<input type="password" name="userpwd" ><br> <input type="submit" value="登录"> </form> </body>
<body>
<%
//获取用户输入信息
request.setCharacterEncoding("utf-8");
String username=request.getParameter("username");
String userpwd=request.getParameter("userpwd");
Connection conn = null;
Statement stmt = null;
try {
//连接驱动
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//建立数据库连接
String url = "jdbc:mysql://localhost:3306/bookstore_demo";
//数据库账号
String uname="root";
//数据库密码
String upwd="016205";
try {
conn = DriverManager.getConnection(url, uname, upwd);
//创建发射器
stmt = conn.createStatement();
//创建sql语句
String sql = "select*from bookstore_demo.yonghu where username='"+username+"' and userpwd='"+userpwd+"'";
//发送sql语句并接收结果
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()) {
out.print("登陆成功");
} else {
out.print("登陆失败");
}
rs.close();
}
catch (SQLException e) {
e.printStackTrace();
}
%>
</body>
<body>
<%
//获取用户输入信息
request.setCharacterEncoding("utf-8");
String username=request.getParameter("username");
String userpwd=request.getParameter("userpwd");
String userage=request.getParameter("userage");
String cuserpwd=request.getParameter("cuserpwd");
//判断两次密码是否相同
if (cuserpwd.equals(userpwd)) {
Connection conn = null;
Statement stmt = null;
try {
//连接驱动
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//建立数据库连接
String url="jdbc:mysql://localhost:3306/bookstore_demo";
//数据库账号
String user="root";
//数据库密码
String upwd="016205";
try {
conn= DriverManager.getConnection(url,user,upwd);
//创建发射器
stmt=conn.createStatement();
//创建sql语句
String sql="insert into yonghu(username,userpwd) value ('"+username+"','"+userpwd+"')";
//发送sql语句并接收结果
int count = stmt.executeUpdate(sql);
if (count>0){
out.print("注册成功");
out.print("<a href='logoin.jsp'>登录</a>");
}
else{
out.print("注册失败");
}
//关闭资源
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
else {
out.print("注册失败");
}
%>
</body>
