registerdao.java

这个网上商城系统项目是我之前发过类似的一个大的整合

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import javabean.Admin;
import javabean.Book;
import javabean.Comment;
import javabean.LeaveWord;
import javabean.Member;
import javabean.OrderBean;
import javabean.OrderByCate;
import javabean.OrderByXL;
import javabean.OrderDetail;
import javabean.OrderInfo;
import javabean.Orders;
import javabean.TypeInfo;


public class RegisterDAO {
	
	String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=bookstore";
	Connection conn = null;
	PreparedStatement pst = null;
	ResultSet rs = null;
	Statement st = null;
	
	public RegisterDAO(){
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	} 
	
	/*
	 * 用户注册
	 */
	public int AddRegister(String sql,String userName,String Name,String sex,String passWord,String card,String Email,String address,String regtime){
		int n = 0;
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst = conn.prepareStatement(sql);
			//RegisterBean register = new RegisterBean();
			pst.setString(1,userName);
			pst.setString(2,Name);
			pst.setString(3,sex);
			pst.setString(4,passWord);
			pst.setString(5,card);
			pst.setString(6,Email);
			pst.setString(7,address);
			pst.setString(8,regtime);
			n = pst.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally{
				try {
					if(pst != null){
						pst.close();
					}
					if(conn != null){
						conn.close();
					}
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		return n;
	}
	/*
	 * 新增商品分类
	 */
	public int AddInfo(String sql,String typeName,String typeInfo){
		int n = 0;
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst = conn.prepareStatement(sql);
			pst.setString(1, typeName);
			pst.setString(2, typeInfo);
			n = pst.executeUpdate();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally{
			try {
				if(rs != null){
					rs.close();
				}
				if(pst != null){
					pst.close();
				}
				if(conn != null){
					conn.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
		return n;
	}
	
	/*
	 * 登陆后的用户名和密码的验证
	 */
	public int CheckPesson(String sql,String userName,String passWord){
		int n = 0;
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst = conn.prepareStatement(sql);
			pst.setString(1, userName);
			pst.setString(2, passWord);
			rs = pst.executeQuery();
			
			if(rs.next()){
				n = rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally{
			try {
				if(rs != null){
					rs.close();
				}
				if(pst != null){
					pst.close();
				}
				if(conn != null){
					conn.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
		return n;
	}
	
	/*
	 * 检查用户名的唯一性
	 */
	public int CheckName(String sql,String userName){
		int n = 0;
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst =  conn.prepareStatement(sql);
			pst.setString(1, userName);
			rs = pst.executeQuery();
			if(rs.next()){
				n = rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally{
			try {
				if(rs != null){
					rs.close();
				}
				if(pst != null){
					pst.close();
				}
				if(conn != null){
					conn.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		
		
		}
		return n;
	}
	/*
	 * 处理管理员登陆
	 */
	public int CheckAdmin(String sql,String adminuserName,String adminpassWord){
		int n = 0;
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst =  conn.prepareStatement(sql);
			pst.setString(1, adminuserName);
			pst.setString(2, adminpassWord);
			rs = pst.executeQuery();
			if(rs.next()){
				n = rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally{
			try {
				if(rs != null){
					rs.close();
				}
				if(pst != null){
					pst.close();
				}
				if(conn != null){
					conn.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		
		
		}
		return n;
	}
	
	/*
	 * 显示所有的商品分类
	 */
	public ArrayList<TypeInfo> ListAllInformation(String sql) {
		ArrayList<TypeInfo> arrayList = new ArrayList<TypeInfo>();
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			st = conn.createStatement();
			rs = st.executeQuery(sql);
			while (rs.next()) {
				TypeInfo info = new TypeInfo();
				info.setId(rs.getInt("id"));
				info.setTypeName(rs.getString("typeName"));
				info.setTypeInfo(rs.getString("typeInfo"));
				arrayList.add(info);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if (rs != null) {
					rs.close();
				}
				if (st != null) {
					st.close();
				}
				if (conn != null) {
					conn.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

		return arrayList;
	}
	
	//删除表中的全部数据,更新表中的数据全部用这
	public int del(String sql){
		int n = 0;
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			st = conn.createStatement();
			n = st.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if (rs != null) {
					rs.close();
				}
				if (st != null) {
					st.close();
				}
				if (conn != null) {
					conn.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return n;
	}
	
	/*
	 * 通过ID查找出书的类别
	 */
	public TypeInfo Modinfo(int userID) {
		TypeInfo type = new TypeInfo();
		String sql = "select * from booktype where id=?";
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst = conn.prepareStatement(sql);
			pst.setInt(1, userID);
			rs = pst.executeQuery();
			while(rs.next()){
				type.setId(rs.getInt("id"));
				type.setTypeName(rs.getString("typeName"));
				type.setTypeInfo(rs.getString("typeInfo"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if (rs != null) {
					rs.close();
				}
				if (st != null) {
					st.close();
				}
				if (conn != null) {
					conn.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return type;
	}
	/*
	 * 增加商品
	 */
	public int AddBook(String sql,int typeid,String name,float price,float saleprice,String descript,String contents,String fileName,String leavetime,int storage,String provider,String marque,String unit){
		int n = 0;
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst = conn.prepareStatement(sql);
			pst.setInt(1, typeid);
			pst.setString(2, name);
			pst.setFloat(3, price);
			pst.setFloat(4, saleprice);
			pst.setString(5, descript);
			pst.setString(6, contents);
			pst.setString(7, "up/" + fileName);
			pst.setString(8, leavetime);
			pst.setInt(9, storage);
			pst.setString(10, provider);
			pst.setString(11, marque);
			pst.setString(12, unit);
			n = pst.executeUpdate();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally{
			try {
				if(rs != null){
					rs.close();
				}
				if(pst != null){
					pst.close();
				}
				if(conn != null){
					conn.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
		return n;
	}
	
	/*
	 * 显示所有的书
	 */
	public ArrayList<Book> ListAllBookInformation(String sql) {
		ArrayList<Book> arrayList = new ArrayList<Book>();
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			st = conn.createStatement();
			rs = st.executeQuery(sql);
			while (rs.next()) {
				Book book = new Book();
				book.setId(rs.getInt("id"));
				book.setTypeid(rs.getInt("typeid"));
				book.setName(rs.getString("name"));
				book.setPrice(rs.getFloat("price"));
				book.setSaleprice(rs.getFloat("saleprice"));
				book.setDescript(rs.getString("descript"));
				book.setContents(rs.getString("contents"));
				book.setFileName(rs.getString("fileName"));
				book.setLeavetime(rs.getString("leavetime"));
				book.setStorage(rs.getInt("storage"));
				book.setProvider(rs.getString("provider"));
				book.setMarque(rs.getString("marque"));
				book.setUnit(rs.getString("unit"));
				arrayList.add(book);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if (rs != null) {
					rs.close();
				}
				if (st != null) {
					st.close();
				}
				if (conn != null) {
					conn.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

		return arrayList;
	}
	
	/*
	 * 通过id查出这本书的详细信息
	 */
	public Book ModInfoBook(int userID) {