第七周作业

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>$Title$</title>
  </head>

  <script type="text/javascript">
    function changeActionToRegister(){
      var s = document.getElementById("idForm")
      s.setAttribute("action", "doRegister.jsp");
    }
    function changeActionToLogin(){
      var s = document.getElementById("idForm")
      s.setAttribute("action", "doLogin.jsp");
    }
  </script>

  <body>

  <form id="idForm" method="post">
    用户名:<input type="text" name="username"/>
    <br>
    密码:<input type="password"  name="password"/>
    <br>
  <input type="submit" onclick="changeActionToLogin()" value="登录">
  <input type="submit" onclick="changeActionToRegister()" value="注册">
  </form>

  </body>
</html>

  

public static int insertuser(String username, String password,String realname) {
        Connection conn = null;
        PreparedStatement ps = null;
        int count = 0;
        try {
            //获取连接
            conn = DBUtils.getConnection();
            //获取预编译的数据库操作对象
            String sql = "insert into t_users (login_name,login_pwd,real_name) values (?,?,?)";

            ps = conn.prepareStatement(sql);
            //传值
            ps.setString(1, username);
            ps.setString(2, password);
            ps.setString(3,realname);
            count = ps.executeUpdate();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } finally {
            DBUtils.close(conn, ps, null);
        }
        return count;
    }

  

package com.kjschool.javaweb.servlet;

import java.sql.*;
import java.util.ResourceBundle;

public class DBUtils {
    private DBUtils(){

    }
    //类加载时绑定资源属性文件
    private static ResourceBundle bundle=ResourceBundle.getBundle("resources.db");
    //注册驱动
    static{
        try {
            Class.forName(bundle.getString("driver"));
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    //获取数据库连接对象
    public static Connection getConnection() throws SQLException {
        String url=bundle.getString("url");
        String user=bundle.getString("user");
        String password=bundle.getString("password");
        Connection conn= DriverManager.getConnection(url,user,password);
        return conn;
    }
    //释放资源
    public  static void close(Connection conn, Statement stmt, ResultSet rs){
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if (stmt != null) {
            try {
                stmt.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }

}

  

<%@ 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="com.Stu"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
    Stu s = new Stu();
    int id = Integer.parseInt(request.getParameter("sid"));
    s.setSid(id);
    String uname = request.getParameter("uname");
    s.setUname(uname);
    String upwd = request.getParameter("upwd");
    s.setUpwd(upwd);
     
    StuDao sd=new StuDao();
    if(sd.addStu(s)>0){
        //跳转注册成功页面
    }else{
        //错误页面
    }
     
     
     
%>

  

posted @ 2021-04-19 18:53  王志将  阅读(3)  评论(0编辑  收藏