快速学习搭建shopping网上商城笔记day02

day02

User.java

package com.bjsxt.shopping.user;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.Date;

import com.bjsxt.shopping.util.DB;


public class User {
    private int id;

    private String username;

    private String password;

    private String phone;

    private String addr;

    private Date rdate;

    public String getAddr() {
        return addr;
    }

    public void setAddr(String addr) {
        this.addr = addr;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public Date getRdate() {
        return rdate;
    }

    public void setRdate(Date rdate) {
        this.rdate = rdate;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public void save() {
        Connection conn = DB.getConn();//获取连接
        String sql = "insert into user values (null, ?, ?, ?, ?, ?)";//sql语句
        PreparedStatement pstmt = DB.PreparedStemt(conn, sql);//接口和语句传进数据库
        try {
            pstmt.setString(1, username);//第一个问号设置自己的username
            pstmt.setString(2, password);
            pstmt.setString(3, phone);
            pstmt.setString(4, addr);
            pstmt.setTimestamp(5, new Timestamp(rdate.getTime()));//类型转换
            pstmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } /*finally {
            DB.close(pstmt);
            DB.close(conn);
        }
*/
    }

}

判断用户注册的信息regcheckdata.js------省略

前端register.jsp

<%@page import="com.bjsxt.shopping.user.User"%>
<%@ page language="java" contentType="text/html; charset=GB18030"
    pageEncoding="GB18030"%>
<% 
request.setCharacterEncoding("GB18030");
String action = request.getParameter("action");
//获取前端信息
if(action != null && action.trim().equals("register")) {
    String username = request.getParameter("username");
    String password = request.getParameter("password");
    //String password2 = request.getParameter("password2");//后台验证，省略
    String phone = request.getParameter("phone");
    String addr = request.getParameter("addr");
    //连接数据库，将信息传入
    User u = new User();
    u.setUsername(username);
    u.setPassword(password);
    u.setPhone(phone);
    u.setAddr(addr);
    u.setRdate(new java.util.Date(System.currentTimeMillis()));
    u.save();//save方法，保存到javabean中
%>

<center>RegisterOK! ThankYou!</center>
<% 
return;
    
}
%>   

<!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=GB18030">
<title>用户注册</title>
<script language=JavaScript src="script/regcheckdata.js"></script>
</head>
<body>
<form action="register.jsp" name="form" method="post"
onSubmit="return checkdata()">
<input type="hidden" name="action" value="register"/>
<table width="750" align="center" border="2">
    <tr>
    <td colspan="2" align="center">用户注册</td>
    </tr>
    <tr>
        <td>用户名:</td>
        <td><input type=text name="username" size="30" maxlength="10"> 

    </tr>
    <tr>
        <td>密码:</td>
        <td><input type=password name="password" size="15" maxlength="12"> 

    </tr>
    <tr>
        <td>确认密码:</td>
        <td><input type=password name="password2" size="15" maxlength="12"> 

    </tr>
    <tr>
        <td>电话:</td>
        <td><input name="phone" type="text" id="phone" size="25"></td>
    </tr>
    <tr>
        <td>送货地址:</td>
        <td><textarea name="addr" cols="60" rows="5" ></textarea></td>
    </tr>
    <br>
    <tr>
        <td></td>
        <td><input value="提交" type="submit"><input type="reset"
        value="重置"></td>
    
    </tr>
</table>

</form>
</body>
</html>

 

posted @ 2019-03-21 17:53  小白咚  阅读(123)  评论(0)    收藏  举报