productserviceimpl.java

网上购物系统的简易代码

package com.tarena.develop.service.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.List;

import com.tarena.develop.common.JDBCUtil;
import com.tarena.develop.entity.Order;
import com.tarena.develop.entity.Product;

public class ProductServiceImpl implements ProductService{

	public Product find(Integer pid) {
		// TODO Auto-generated method stub
		return null;
	}

	public List<Product> getProducts() {
		  Connection con=null;
			PreparedStatement ps=null;
			ResultSet rs=null;
			List<Product> products=null;
			Product pro=null;
			String sql="select pid,name,description ,price,author,images from t_product  ";
			try{
			    con=JDBCUtil.getConnection();
//			    con.setAutoCommit(false);
			    ps=con.prepareStatement(sql);
			    
			    rs=ps.executeQuery();
				while(rs.next()){
					pro=new Product();
					pro.setPid(rs.getInt(1));
					pro.setName(rs.getString(2));
					pro.setDiscription(rs.getString(3));
					products.add(pro);
				}
			}catch(Exception e){
				e.printStackTrace();
//				try {
//					con.rollback();
//				} catch (SQLException e1) {
//					// TODO Auto-generated catch block
//					e1.printStackTrace();
//				}
			}finally{
				JDBCUtil.relese(rs, ps, con);
			}
			return products;
		}

}