rejectshoppingtreat.java

是一个企业的进销存系统。账号问1001密码为123456

package com.jxc.dao;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import com.jxc.dao.Dao;
import com.jxc.vo.RejectShopping;
import com.jxc.vo.SellbackShopping;
import com.jxc.vo.Vo;

public class RejectShoppingTreat implements Dao{

	public boolean deleteById(Connection conn, int id) {
		boolean flat=false;
		PreparedStatement pstm=null;
		int rs=0;
		String sql="delete from rejectshopping where id=?";
		try {
			pstm=conn.prepareStatement(sql);
			pstm.setInt(1, id);
			rs=pstm.executeUpdate();
			if(rs!=0)
				flat=true;
			else 
				flat=false;
			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(pstm!=null)
					pstm.close();
				if(conn!=null)
					conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
		
		return flat;
	}

	public boolean insert(Connection conn, Vo vo) {
		boolean flat=false;
		RejectShopping reject=(RejectShopping)vo;
		PreparedStatement pstm=null;
		int rs=0;
		String sql="insert into rejectshopping(sid,bprince,bnum,btime,binfo,yid)values(?,?,?,?,?,?)";
		try {
			pstm=conn.prepareStatement(sql);
			pstm.setString(1,reject.getSid());
			pstm.setInt(2, reject.getBprince());
			pstm.setInt(3, reject.getBnum());
			pstm.setDate(4, (Date) reject.getBtime());
			pstm.setString(5,reject.getBinfo());
			pstm.setString(6,reject.getYid());
			rs=pstm.executeUpdate();
			if(rs!=0)
				flat=true;
			else 
				flat=false;
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(pstm!=null)
					pstm.close();
				if(conn!=null)
					conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
		return flat;
	}

	public ArrayList<RejectShopping> selectAll(Connection conn) {
		ArrayList<RejectShopping> arr=new ArrayList<RejectShopping>();
		PreparedStatement pstm=null;
		ResultSet rs=null;
		String sql="select id,sid,,bprince,bnum,btime,binfo,yid from rejectshopping";
		try {
			pstm=conn.prepareStatement(sql);
			rs=pstm.executeQuery();
			while(rs.next()){
				RejectShopping reject=new RejectShopping();
				reject.setId(rs.getInt(1));
				reject.setSid(rs.getString(2));
				reject.setBprince(rs.getInt(3));
				reject.setBnum(rs.getInt(4));
				reject.setBtime(rs.getDate(5));
				reject.setBinfo(rs.getString(6));
				reject.setYid(rs.getString(7));
				arr.add(reject);
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null)
					rs.close();
				if(pstm!=null)
					pstm.close();
				if(conn!=null)
					conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
		return arr;
	}

	public ArrayList<RejectShopping> selectByTime(Connection conn, Date d1, Date d2) {
		ArrayList<RejectShopping> arr=new ArrayList<RejectShopping>();
		PreparedStatement pstm=null;
		ResultSet rs=null;
		String sql="select id,sid,bprince,bnum,btime,binfo,yid from rejectshopping where btime>=? and btime<=?";
		try {
			pstm=conn.prepareStatement(sql);
			pstm.setDate(1,d1);
			pstm.setDate(2,d2);
			rs=pstm.executeQuery();
			while(rs.next()){
				RejectShopping reject=new RejectShopping();
				reject.setId(rs.getInt(1));
				reject.setSid(rs.getString(2));
				reject.setBprince(rs.getInt(3));
				reject.setBnum(rs.getInt(4));
				reject.setBtime(rs.getDate(5));
				reject.setBinfo(rs.getString(6));
				reject.setYid(rs.getString(7));
				arr.add(reject);
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null)
					rs.close();
				if(pstm!=null)
					pstm.close();
				if(conn!=null)
					conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
		return arr;
	}

	public Vo selectById(Connection conn,int id){
		RejectShopping vo=new RejectShopping();
		PreparedStatement pstm=null;
	    ResultSet rs=null;
	    String sql="select id,sid,bprince,bnum,binfo,btime,yid from rejectshopping where id=?";
	    try {
			pstm=conn.prepareStatement(sql);
			pstm.setInt(1, id);
			rs=pstm.executeQuery();
			if(rs.next()){
				vo.setId(rs.getInt(1));
				vo.setSid(rs.getString(2));
				vo.setBprince(rs.getInt(3));
				vo.setBnum(rs.getInt(4));
				vo.setBinfo(rs.getString(5));
				vo.setBtime(rs.getDate(6));
				vo.setYid(rs.getString(7));
			}
	    } catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null)
					rs.close();
				if(pstm!=null)
					pstm.close();
				if(conn!=null)
					conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	    
		
		return vo;
	}

	public boolean updateByid(Connection conn,int id, Vo vo) {
		// TODO Auto-generated method stub
		boolean flat = false;
		RejectShopping seb = (RejectShopping) vo;
		PreparedStatement pstm = null;
		int rs = 0;
		String sql = "update rejectshopping set sid=?,bprince=?,bnum=?,binfo=?,btime=?,yid=? where id=?";
		try {
			pstm = conn.prepareStatement(sql);
			pstm.setString(1, seb.getSid());
			pstm.setInt(2, seb.getBprince());
			pstm.setInt(3, seb.getBnum());
			pstm.setString(4, seb.getBinfo());
			pstm.setDate(5, (Date) seb.getBtime());
			pstm.setString(6, seb.getYid());
			pstm.setInt(7, id);
			rs = pstm.executeUpdate();
			if (rs != 0)
				flat = true;
			else
				flat = false;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if (pstm != null)
					pstm.close();
				if (conn != null)
					conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

		}

		return flat;
	}

	public ArrayList<RejectShopping> selectBySid(Connection conn,String sid, Date d1, Date d2) {
		ArrayList<RejectShopping> arr=new ArrayList<RejectShopping>();
		PreparedStatement pstm=null;
		ResultSet rs=null;
		String sql="select id,sid,bprince,bnum,btime,binfo,yid from rejectshopping where btime>=? and btime<=? and sid=?";
		try {
			pstm=conn.prepareStatement(sql);
			pstm.setDate(1,d1);
			pstm.setDate(2,d2);
			pstm.setString(3, sid);
			rs=pstm.executeQuery();
			while(rs.next()){
				RejectShopping reject=new RejectShopping();
				reject.setId(rs.getInt(1));
				reject.setSid(rs.getString(2));
				reject.setBprince(rs.getInt(3));
				reject.setBnum(rs.getInt(4));
				reject.setBtime(rs.getDate(5));
				reject.setBinfo(rs.getString(6));
				reject.setYid(rs.getString(7));
				arr.add(reject);
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null)
					rs.close();
				if(pstm!=null)
					pstm.close();
				if(conn!=null)
					conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
		return arr;
	}

}