shop.java

电子商务系统： 项目描述：该系统主要完成用户网上购物、订单管理、产品管理、管理员管理等功能。后台管理员对产品类别和产品进行管理后

package com.tarena.shop.entity.dao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
import java.util.Vector;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.tarena.shop.entity.Order;
import com.tarena.shop.entity.Product;
import com.tarena.shop.util.ConnectionFactory;
import com.tarena.shop.util.HbnUtil;

public class Shop {
	public Product getProduct(int id){
		Connection con = ConnectionFactory.getConnection();
		String sql = null;
		Product product = new Product();
		ResultSet rs = null;
		try {
			sql = "select * from Productxp where productid="+id;
			Statement st = con.createStatement
						(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
				rs=st.executeQuery(sql);
				while(rs.next()){
				product.setId(rs.getInt("productid"));
				product.setName(rs.getString("name"));			
				product.setPrice(rs.getDouble("price"));
				product.setDescription(rs.getString("description"));
				}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return product;
		
	}
	public Product SelectById(int id) {
		Product newUser =new Product();
		Session sess = null;
		Transaction tran = null;
		try{
			sess = HbnUtil.getSession();
			tran = sess.beginTransaction();
			String hql = "from Product u where u.id like ? ";
			Query query = sess.createQuery(hql).setInteger(0, id);
			List<Product> products = query.list();
			for(Product u:products){
				newUser = u;
			}
			tran.commit();
		}catch(HibernateException e){
			e.printStackTrace();
			if(tran!=null) tran.rollback();
		}finally{
			if(sess!=null && sess.isOpen())	sess.close();
		}
		return newUser;
	
		
	}
	public void insert(Product user) {
		Session sess = null;
		Transaction tran = null;
		try{
			sess = HbnUtil.getSession();
			tran = sess.beginTransaction();
			sess.save(user);
			tran.commit();
		}catch(Exception e){
			System.out.println("null point1");
			e.printStackTrace();
			System.out.println("null point");
			if(tran!=null) tran.rollback();
		}finally{
			System.out.println("null point2");
			if(sess!=null && sess.isOpen())	sess.close();
		}
	}
	
		
	
	public Vector<Product> selectProduct() {
		String sql = "select * from Productxp";
		Vector product = new Vector();
		Connection con = ConnectionFactory.getConnection();
		try {
			Statement st = con.createStatement
						(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			ResultSet rs=st.executeQuery(sql);
			while(rs.next()){
				Product u1 = new Product();
				u1.setName(rs.getString("name"));
				u1.setId(rs.getInt("productid"));
				u1.setPrice(rs.getDouble("price"));
				u1.setDescription(rs.getString("description"));				
				product.add(u1);
			}
		
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		return product;
	}
	public void insertOrder(Order order){
		Session sess = null;
		Transaction tran = null;
		try{
			sess = HbnUtil.getSession();
			tran = sess.beginTransaction();
			sess.save(order);
			tran.commit();
		}catch(Exception e){
			System.out.println("null point1");
			e.printStackTrace();
			System.out.println("null point");
			if(tran!=null) tran.rollback();
		}finally{
			System.out.println("null point2");
			if(sess!=null && sess.isOpen())	sess.close();
		}
	}
}