user.java

一个可以作为毕业设计的网上商城项目

package com.fang.shopping;

import java.sql.*;

import java.util.*;

import com.fang.shppping.util.DB;




public class User {
	private int id;
	private String username;
	private String password;
	private String addr;
	private String phone;
	private Timestamp rdate;
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUserName() {
		return username;
	}
	public void setUserName(String userName) {
		this.username = userName;
	}
	public String getPassWord() {
		return password;
	}
	public void setPassWord(String passWord) {
		this.password = passWord;
	}
	public String getAddr() {
		return addr;
	}
	public void setAddr(String addr) {
		this.addr = addr;
	}
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
	public Timestamp getRDate() {
		return rdate;
	}
	public void setRDate(Timestamp date) {
		rdate = date;
	}
	
	public void save(){
		Connection conn = null;
		PreparedStatement pstmt = null;
		try{
			conn = DB.getConn();
			String sql = "insert into ruser values(null,?,?,?,?,?)";
			pstmt =  DB.getPStmt(conn, sql);
			try {
				pstmt.setString(1, username);
				pstmt.setString(2, password);
				pstmt.setString(4, addr);
				pstmt.setString(3, phone);
				pstmt.setTimestamp(5, rdate);

				
				pstmt.executeUpdate();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}finally{
			DB.close(pstmt);
			DB.close(conn);
		}
	}
	
//	//第一种方式：在这个类里面给出
//	public static List<User> getUsers()
//	{
//		List<User> list = new ArrayList<User>();
//		Connection conn = null;
//		ResultSet rs = null;
//		
//		try {
//			conn = DB.getConn();
//			String sql = "select * from ruser";
//			rs = DB.executeQuery(conn, sql);
//			while(rs.next()){
//				User u = new User();
//				u.setId(rs.getInt("id"));
//				u.setUserName(rs.getString("username"));
//				u.setAddr(rs.getString("addr"));
//				u.setPassWord(rs.getString("password"));
//				u.setPhone(rs.getString("phone"));
//				u.setRDate(rs.getTimestamp("rdate"));
//				
//				list.add(u);
//			}
//			
//		} catch (SQLException e) {
//			e.printStackTrace();
//		}finally{
//			DB.close(rs);
//			DB.close(conn);
//		}
//		return list;
//	}

}