cardao.java

来自「模拟网上购物系统」· Java 代码 · 共 57 行

package dao;

import java.sql.*;
import java.util.ArrayList;

import po.productPO;

public class CarDAO {
	
	private Connection conn = null;
	private Statement state = null;
	private ResultSet rs = null;
	
	//
	public productPO list(productPO poo)
	{
		productPO po = null;
		conn = Tools.getConnection();
		try {
			state = conn.createStatement();
			rs = state.executeQuery("select * from product where proid = " + poo.getProid());
			
			if(rs.next())
			{
				po = new productPO();
				po.setProid(rs.getInt("proid"));
				po.setProname(rs.getString("proname"));
				po.setProprice(rs.getInt("proprice"));
				po.setMemberprice(rs.getInt("memberprice"));
				po.setPicture(rs.getString("picture"));
				po.setPurpose(rs.getString("purpose"));
				po.setBewrite(rs.getString("bewrite"));
				
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally
		{
				try {
					if(rs != null)
					rs.close();
					if(state != null)
					state.close();
					if(conn != null)
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
		}
		return po;
	}

}