cstcustomerorderdao.java

做的是一个客户关系管理系统

package com.accp.dao;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Types;
import java.util.ArrayList;
import java.util.List;
import java.sql.*;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class CstCustomerOrderDAO extends HibernateDaoSupport{
	
	private org.hibernate.Session session = null;
	private List list = null;
	private org.hibernate.Query query = null;
	/**
	 * 创建一个查询订单的方法
	 * @param sql
	 * @return
	 */
	public List Query(String sql)
	{	
		Connection conn = this.getSession().connection();
		try {
			PreparedStatement ps = conn.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			list = new ArrayList();
			while(rs.next())
			{				
				VOrders vo = new VOrders();
				vo.setOdrId(rs.getLong(1));
				vo.setOdrCustomer(rs.getString(2));
				vo.setOdrDate(rs.getDate(3));
				vo.setOdrAddr(rs.getString(4));
				vo.setOdrStatus(rs.getString(5));	
				list.add(vo);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}		
		return list;
	}
	public List QueryProductById(String sql)
	{
		Connection conn = this.getSession().connection();
		try {
			PreparedStatement ps = conn.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			list = new ArrayList();
			while(rs.next())
			{				
				VProductById vo = new VProductById();
				vo.setPname(rs.getString(1));
				vo.setPunit(rs.getString(2));
				vo.setPprice(rs.getDouble(3));
				vo.setPsumprice(rs.getDouble(4));
				vo.setPoid(rs.getLong(5));
				vo.setPcount(rs.getString(6));
				list.add(vo);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	
		return list;
	}
	
	public Double QuerySumPriceById(String sql)
	{
		Connection conn = this.getSession().connection();
		Double sumPrice = 0.0;
		try {
			PreparedStatement ps = conn.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			if(rs.next())
			{
				sumPrice = rs.getDouble(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

		return sumPrice;
	}
	

}