orders.java

音乐网站涉及到很多数据库查询

package serverBag;

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

import publicBag.ConnectDB;

public class Orders{
	private Connection con;
    //JavaBean属性
	private int orderID;
	private String userID;
	private int status;
	private Date orderTime;
	private Date dealTime;
	private String realName;
	private String addr;
	private String tel;
	private String postCode;
	private double totalPrice;
	
	public int getOrderID(){ return orderID;}
	public void setOrderID(int inOrderID){ orderID = inOrderID;}	
	public String getUserID(){ return userID;}
	public void setUserID(String inUserID){ userID = inUserID;}	
	public int getStatus(){ return status;}
	public void setStatus(int inStatus){ status = inStatus;}	
	public Date getOrderTime(){ return orderTime;}
	public void setOrderTime(Date inOrderTime){ orderTime = inOrderTime;}	
	public Date getDealTime(){ return dealTime;}
	public void setDealTime(Date inDealTime){ dealTime = inDealTime;}

	public String getRealName(){ return realName;}
	public void setRealName(String inRealName){ realName = inRealName;}
	
	public String getAddr(){ return addr;}
	public void setAddr(String inAddr){ addr = inAddr;}	
	public String getTel(){ return tel;}
	public void setTel(String inTel){ tel = inTel;}	
	public String getPostCode(){ return postCode;}
	public void setPostCode(String inPostCode){ postCode = inPostCode;}	
	public double getTotalPrice(){ return totalPrice;}
	public void setTotalPrice(double inTotalPrice){ totalPrice = inTotalPrice;}
	
    /** Creates a new instance of UserInfo */
    public Orders() {
        try
        {
            con = ConnectDB.connectMusicDB();            	
        }
        catch(Exception e)
        {
            e.printStackTrace();           
        }
    }	
	public int insertInfo() {
		// TODO 自动生成方法存根
    	try
        {        	
            PreparedStatement stat = 
            	con.prepareStatement("INSERT Orders(cUserID,dOrderTime,cRealName,vAddr,cTel,cPostCode,mTotalPrice) VALUES(?,getdate(),?,?,?,?,?)");
            stat.setString(1,this.getUserID());    
            stat.setString(2,this.getRealName());
            stat.setString(3,this.getAddr());
            stat.setString(4,this.getTel());
            stat.setString(5,this.getPostCode());
            stat.setDouble(6,this.getTotalPrice());
            int res = stat.executeUpdate();
            if(res == 0) return 0;
            else
            {
            	try
            	{
            		PreparedStatement stat1 = 
                    	con.prepareStatement("SELECT TOP 1 iOrderID FROM Orders ORDER BY iOrderID DESC");
            		ResultSet res1 = stat1.executeQuery();
            		if(res1.next()) return res1.getInt(1);
            		else return 0;
            	}
            	catch(Exception ex)
            	{
            		return 0;
            	}
            }
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return 0;
        } 
	}
	public ResultSet showUnDealOrder()
	{
    	try
        {        	
            PreparedStatement stat = 
            	con.prepareStatement("SELECT * FROM Orders WHERE iStatus=0");
            ResultSet res = stat.executeQuery();    
            return res;                       
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return null;
        } 		
	}
	public ResultSet showAllOrder()
	{
    	try
        {        	
            PreparedStatement stat = 
            	con.prepareStatement("SELECT * FROM Orders");
            ResultSet res = stat.executeQuery();    
            return res;                       
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return null;
        } 		
	}
	public boolean deleteInfo() {
		// TODO 自动生成方法存根
    	try
        {        	
            PreparedStatement stat = 
            	con.prepareStatement("DELETE Orders WHERE iOrderID=?");
            stat.setInt(1,this.getOrderID());            
            int res = stat.executeUpdate();
            if(res > 0) return true;
            else return false;
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return false;
        } 
	}

	public boolean updateInfo() {
		// TODO 自动生成方法存根
		try
        {        	
            PreparedStatement stat = 
            	con.prepareStatement("UPDATE Orders SET iStatus=1,dDealTime=getdate() WHERE iOrderID=?");            
            stat.setInt(1,this.getOrderID());            
            int res = stat.executeUpdate();
            if(res > 0) return true;
            else return false;
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return false;
        } 
	}
}