第七次作业 

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
<style type="text/css">
body {
    background-color: azure;
}

form {
    position: fixed;
    top: 250px;
    left: 650px;
    background-color: #ADD8E6;
    border-radius: 5px;
}

div {
    font-size: 22px;
    margin-top: 20px;
    padding-left: 40px;
}

input {
    width: 200px;
    height: 20px;
    border-radius: 5px;
}

#tj {
    width: 80px;
    height: 30px;
    margin-left: 140px;
    border-radius: 5px;
    font-size: 16px;
    margin-bottom: 20px;
}
</style>

</head>
<body>
    <form action="/school/panduanreg.jsp" method="post">
        <div>
            账 号:    <input type="text" name="username">
        </div>
        <div>
            密 码:    <input type="text" name="password">
        </div>

        <div>
            <input type="submit" id="tj" value="注册">
        </div>
    </form>

</body>
<script type="text/javascript">

</script>
</html>
<%@page import="dao.userDao"%>
<%@page import="bean.user"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<%
    request.setCharacterEncoding("UTF-8");
    response.setContentType("text/html;charset=utf-8");
    response.setCharacterEncoding("UTF-8");
    HttpSession s = request.getSession();

    String username = request.getParameter("username");
    String password1 = request.getParameter("password");
    user u = new user();
    u.setUname(username);
    u.setUpwd(password1);
    userDao ud = new userDao();
    int flag = ud.addUser(u);
    if (flag > 0) {
        out.write("注册成功");
    } else {
        response.sendRedirect("/school/reg.jsp");
    }
%>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>

</body>
</html>
public int addUser(user u) throws Exception {
        int i = 0;
          Class.forName("com.mysql.jdbc.Driver");
            // 2.提供另外三个连接的基本信息
            String url = "jdbc:mysql://localhost:3306/school";
            String user = "root";
            String password = "root";
            Connection conn = DriverManager.getConnection(url, user, password);
            PreparedStatement ps = conn.prepareStatement("insert into user (uname,upwd)values(?,?)");
            ps.setString(1, u.getUname());
            ps.setString(2, u.getUpwd());
            return i = ps.executeUpdate();
            
    }
package bean;

public class user {
    private int uid;
    private String uname;
    private String upwd;
    public user() {
        super();
    }
    public user(int uid, String uname, String upwd) {
        super();
        this.uid = uid;
        this.uname = uname;
        this.upwd = upwd;
    }
    public int getUid() {
        return uid;
    }
    public void setUid(int uid) {
        this.uid = uid;
    }
    public String getUname() {
        return uname;
    }
    public void setUname(String uname) {
        this.uname = uname;
    }
    public String getUpwd() {
        return upwd;
    }
    public void setUpwd(String upwd) {
        this.upwd = upwd;
    }
    
    
}

 

posted @ 2021-04-20 11:03  小范是个画家  阅读(36)  评论(0)    收藏  举报