musiccd.java

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

/*
 * MusicDB.java
 *
 * Created on 2008年7月10日, 下午3:50
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package serverBag;

import java.sql.*;

import publicBag.*;

/**
 *
 * @author Administrator
 */
public class MusicCD implements UpdateDB{
    private Connection con;
    //JavaBean属性    
    private int cdID;
    private String cdName;
    private double price;
    private String singerID;
    private Date sendTime;
    private String description;
    private String photo;    

    public int getCdID(){ return cdID;}
    public void setCdID(int inCdID){ cdID = inCdID;}   
    public String getCdName(){ return cdName;}
    public void setCdName(String inCdName){ cdName = inCdName;}
    public double getPrice(){return price;}
    public void setPrice(double inPrice){price = inPrice;}
    public String getSingerID(){ return singerID;}
    public void setSingerID(String inSingerID){ singerID = inSingerID;}  
    public Date getSendTime(){return sendTime;}
    public void setSendTime(Date inSendTime){ sendTime = inSendTime;}   
    public String getDescription(){ return description;}
    public void setDescription(String inDescription){ description = inDescription;}   
    public String getPhoto(){return photo;}
    public void setPhoto(String inPhoto){photo = inPhoto;}   
    
    public MusicCD() {
        try
        {
            con = ConnectDB.connectMusicDB();            	
        }
        catch(Exception e)
        {
            e.printStackTrace();           
        }
    }
    public ResultSet showAllInfo()
    {
    	try
        {        	
            PreparedStatement stat = 
            	con.prepareStatement("SELECT * FROM MusicCD");
            ResultSet res = stat.executeQuery();    
            return res;                       
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return null;
        } 		
    }
    public boolean insertInfo() {
        return false;
    }

    public boolean deleteInfo() {
        return false;
    }

    public boolean updateInfo() {
        return false;
    }
}