registerdao.java

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

				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 ArrayList<OrderInfo> ListOneOrdersInformation(String sql) {
		ArrayList<OrderInfo> arrayList = new ArrayList<OrderInfo>();
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			st = conn.createStatement();
			rs = st.executeQuery(sql);
			while (rs.next()) {
				OrderInfo orders = new OrderInfo();
				orders.setId(rs.getInt("id"));
				orders.setName(rs.getString("name"));
				orders.setNumber(rs.getInt("number"));
				orders.setPrice(rs.getFloat("price"));
				orders.setSaleprice(rs.getFloat("saleprice"));
				orders.setTotalprice(rs.getFloat("totalprice"));
				arrayList.add(orders);
			}
		} 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 Orders QueryOrder(int userID) {
		Orders member = new Orders();
		String sql = "select * from orders where id=?";
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst = conn.prepareStatement(sql);
			pst.setInt(1, userID);
			rs = pst.executeQuery();
			while(rs.next()){
				member.setId(rs.getInt("id"));
				member.setDatatime(rs.getString("datatime"));
				member.setDeliverymode(rs.getInt("deliverymode"));
				member.setMoneymode(rs.getInt("moneymode"));
				member.setSaveAddress(rs.getString("saveAddress"));
				member.setSaveName(rs.getString("saveName"));
				member.setSavePhone(rs.getString("savePhone"));
				member.setState(rs.getInt("state"));
				member.setUserID(rs.getInt("userID"));
				member.setZip(rs.getString("zip"));
			}
		} 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 member;
	}
	
	//按销量排名来查询
	public ArrayList<OrderByXL> ListOrderByXL(String sql) {
		ArrayList<OrderByXL> arrayList = new ArrayList<OrderByXL>();
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			st = conn.createStatement();
			rs = st.executeQuery(sql);
			while (rs.next()) {
				OrderByXL member = new OrderByXL();
				member.setId(rs.getInt("id"));
				member.setName(rs.getString("Name"));
				member.setPrice(rs.getFloat("price"));
				member.setSaleprice(rs.getFloat("saleprice"));
				member.setNumber(rs.getInt("number"));
				arrayList.add(member);
			}
		} 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 ArrayList<javabean.OrderByCate> ListOrderByCate(String sql) {
		ArrayList<OrderByCate> arrayList = new ArrayList<OrderByCate>();
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			st = conn.createStatement();
			rs = st.executeQuery(sql);
			while (rs.next()) {
				javabean.OrderByCate member = new OrderByCate();
				member.setId(rs.getInt("id"));
				member.setNumber(rs.getInt("number"));
				member.setTypeName(rs.getString("typeName"));
				arrayList.add(member);
			}
		} 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 ArrayList<javabean.OrderByDate> ListOrderByDate(String sql) {
		ArrayList<javabean.OrderByDate> arrayList = new ArrayList<javabean.OrderByDate>();
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			st = conn.createStatement();
			rs = st.executeQuery(sql);
			while (rs.next()) {
				javabean.OrderByDate member = new javabean.OrderByDate();
				member.setTypeid(rs.getInt("typeid"));
				member.setNumber(rs.getInt("number"));
				arrayList.add(member);
			}
		} 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 ArrayList<LeaveWord> ListLeaveWord(String sql) {
		ArrayList<LeaveWord> arrayList = new ArrayList<LeaveWord>();
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			st = conn.createStatement();
			rs = st.executeQuery(sql);
			while (rs.next()) {
				LeaveWord leaveWord = new LeaveWord();
				leaveWord.setId(rs.getInt("id"));
				leaveWord.setAdminid(rs.getInt("adminid"));
				leaveWord.setAnswercontent(rs.getString("answercontent"));
				leaveWord.setAnswerdate(rs.getString("answerdate"));
				leaveWord.setContent(rs.getString("content"));
				leaveWord.setLeavrdate(rs.getString("leavrdate"));
				leaveWord.setMemberid(rs.getInt("memberid"));
				leaveWord.setTitle(rs.getString("title"));
				leaveWord.setState(rs.getInt("state"));
				arrayList.add(leaveWord);
			}
		} 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 LeaveWord LeaveWordInfo(int userID) {
		LeaveWord leaveWord = new LeaveWord();
		String sql = "select * from leaveword where id=?";
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst = conn.prepareStatement(sql);
			pst.setInt(1, userID);
			rs = pst.executeQuery();
			while(rs.next()){
				leaveWord.setAdminid(rs.getInt("adminid"));
				leaveWord.setAnswercontent(rs.getString("answercontent"));
				leaveWord.setAnswerdate(rs.getString("answerdate"));
				leaveWord.setContent(rs.getString("content"));
				leaveWord.setId(rs.getInt("id"));
				leaveWord.setLeavrdate(rs.getString("leavrdate"));
				leaveWord.setMemberid(rs.getInt("memberid"));
				leaveWord.setState(rs.getInt("state"));
				leaveWord.setTitle(rs.getString("title"));
			}
		} 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 leaveWord;
	}
	//系统用户管理
	public ArrayList<Admin> ListAllAdminInformation(String sql) {
		ArrayList<Admin> arrayList = new ArrayList<Admin>();
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			st = conn.createStatement();
			rs = st.executeQuery(sql);
			while (rs.next()) {
				Admin book = new Admin();
				book.setId(rs.getInt("id"));
				book.setAdminName(rs.getString("adminName"));
				book.setAdminpassWord(rs.getString("adminpassWord"));
				book.setAdminType(rs.getInt("adminType"));
				book.setAdminuserName(rs.getString("adminuserName"));
				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;
	}
	
	//我想匹配权限，通过用户名得到类型
	public Admin QueryAdmin(String userName) {
		Admin member = new Admin();
		String sql = "select * from admin where adminuserName=?";
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst = conn.prepareStatement(sql);
			pst.setString(1, userName);
			rs = pst.executeQuery();
			while(rs.next()){
				member.setId(rs.getInt("id"));
				member.setAdminName(rs.getString("adminName"));
				member.setAdminpassWord(rs.getString("adminpassWord"));
				member.setAdminType(rs.getInt("adminType"));
				member.setAdminuserName(rs.getString("adminuserName"));
			}
		} 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 member;
	}
	
	/*
	 * 通过ID查出是哪个管理员好查看详细信息
	 */
	public Admin QueryAdminByID(int id) {
		Admin member = new Admin();
		String sql = "select * from admin where id=?";
		try {
			conn = DriverManager.getConnection(url, "sa", "sa");
			pst = conn.prepareStatement(sql);
			pst.setInt(1, id);
			rs = pst.executeQuery();
			while(rs.next()){
				member.setId(rs.getInt("id"));
				member.setAdminName(rs.getString("adminName"));
				member.setAdminpassWord(rs.getString("adminpassWord"));
				member.setAdminType(rs.getInt("adminType"));
				member.setAdminuserName(rs.getString("adminuserName"));
			}
		} 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 member;
	}
}