第十周作业
package com.db.user;
public class User {
private String uname;
private String upass;
private int age;
public User(){}
public User (String uname,String upass,int age){
this.uname = uname;
this.upass = upass;
this.age = age;
}
public String getUname() {
return uname;
}
public void setUname(String uname) {
this.uname = uname;
}
public String getUpass() {
return upass;
}
public void setUpass(String upass) {
this.upass = upass;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
}
package com.db.mydriver;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class UserDemo extends DriverDemo{
//注册
public int AddData(com.db.user.User s){
int i=0;
Connection conn=null;
PreparedStatement ps = null;
conn = getConnection();
try {
String sql = "insert into user(uname,upass,age) values(?,?,?)";
ps = conn.prepareStatement(sql);
ps.setString(1, s.getUname());
ps.setString(2, s.getUpass());
ps.setInt(3, s.getAge());
i =ps.executeUpdate();
}catch (SQLException throwables) {
throwables.printStackTrace();
}finally{
closeAll(conn, ps, null);
}
return i;
}
//登录
public int dl(com.db.user.User s){
int i=0;
Connection conn =null;
PreparedStatement ps = null;
ResultSet rs =null;
try {
conn = getConnection();
String sql = "select * from user where uname=? and upass=? and age=?";
ps =conn.prepareStatement(sql);
ps.setString(1, s.getUname());
ps.setString(2, s.getUpass());
ps.setInt(3, s.getAge());
rs = ps.executeQuery();
if(rs.next()){
System.out.print("账户登录成功");
i=1;
}else{
System.out.print("账户登录失败");
i=0;
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
closeAll(conn, ps, rs);
}
return i;
}
}
package com.db.mydriver;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DriverDemo {
public Connection getConnection(){
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8","root",",root");
} catch (Exception e) {
// TODO: handle exception
}
return conn;
}
//关闭连接
public void closeAll(Connection con,PreparedStatement ps,ResultSet rs){
try {
if(rs != null)
rs.close();
if(ps != null)
ps.close();
if(con != null)
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
<head>
<base href="<%=basePath%>">
</head>
<body>
<form action="ZcDemo.jsp" method="post">
<p>
<span>账号：</span>
<input type="text" name="zname" />
</p>
<p>
<span>密码：</span>
<input type="password" name="zpass" />
</p>
<p>
<span>年龄：</span>
<input type="number" name="age" />
</p>
<p>
<input type="submit" class="btn01" value="注册"/>
</p>
</form>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<%@ page import="com.db.user.User" %>
<%@ page import="com.db.mydriver.UserDemo" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'ZcDemo.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<%
request.setCharacterEncoding("utf-8");
User s = new User();
UserDemo us = new UserDemo();
//获取输入的用户名
String namee = request.getParameter("zname");
namee.trim();
s.setUname(namee);
String passs = request.getParameter("zpass"); // 密码
passs.trim();
s.setUpass(passs);
if(us.AddData(s)!=0){
session.setAttribute("uname",s.getUname());
response.sendRedirect("Zcshow.jsp");
}else{
out.print("注册失败");
}
%>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
<head>
<base href="<%=basePath%>">
</head>
<body>
<form action="dlDemo.jsp" method="post">
<p>
<span>账号：</span>
<input type="text" name="dname" value="admin" class="num" />
</p>
<p>
<span>密码：</span>
<input type="password" name="dpass" class="pass"/>
</p>
<p>
<span>年龄：</span>
<input type="number" name="age" />
</p>
<p>
<input type="submit" class="btn01" value="登录"/>
<a href="zc.jsp">没有账户？点击注册</a>
</p>
</form>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="com.db.user.User" %>
<%@ page import="com.db.mydriver.UserDemo" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'dlDemo.jsp' starting page</title>
</head>
<body>
<%
request.setCharacterEncoding("utf-8");
User s = new User();
UserDemo us = new UserDemo();
//获取输入的用户名
String namees = request.getParameter("dname");
namees.trim();
s.setUname(namees);
String passss = request.getParameter("dpass"); // 密码
passss.trim();
s.setUpass(passss);
if(us.dl(s)!=0){
session.setAttribute("uname",s.getUname());
response.sendRedirect("dlshow.jsp");
}else{
response.sendRedirect("index.jsp");
}
%>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'dlshow.jsp' starting page</title>
</head>
<body>
欢迎用户：<%=session.getAttribute("uname")%>登录！！！！
</body>
</html>
浙公网安备 33010602011771号