package?test;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

public?class?AddCDBean?{

	private?String?cdID=null;
	private?String?cdName=null;
	private?String?singer=null;
	private?String?publisher=null;
	private?String?price=null;
	private?String?introduce=null;
	
	private?String?url?=“jdbc:mysql://localhost:3306/sql_test?user=root&password=root&useUnicode=true&characterEncoding=UTF-8“;
	private?Connection?conn?=null;???????????
	private?ResultSet?rs?=?null;
	private?Statement?stmt?=?null;
	
	public?AddCDBean（）{

	}
	
	public?void?insertCD（String?str1?String?str2?String?str3?String?str4?String?str5?String?str6）{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“?）;
			System.err.println（“加載驅動器類成功addcd！“）;
		}
		
		catch（ClassNotFoundException?e）{
			System.err.println（“加載驅動器類時失敗！“）;
		}
			try?{
				Class.forName（“com.mysql.jdbc.Driver“）.newInstance（）;
				System.out.print（“1“）;
				conn=DriverManager.getConnection（url）;
				System.out.print（“2“）;
				Statement?stmt=conn.createStatement（）;
				System.out.print（“3“）;
				String?sql?=?“insert?into?cdInfo?values（‘“+str1+“‘‘“+str2+“‘‘“+str3+“‘‘“+str4+“‘‘“+str5+“‘‘“+str6+“‘）“;
				System.out.print（“4“）;
				stmt.addBatch（sql）;
				System.out.print（“5“）;
				stmt.executeUpdate（sql）;
				System.out.print（“6“）;
				System.out.print（“插入成功“）;
			}?catch?（Exception?e）?{
				
				System.out.println（“連接數據庫出現異?！埃?
			}finally{
				try{
					if（conn!=null）
						conn.close（）;
				}catch（SQLException?e）{
					System.out.print（“關閉數據庫時出現異常！“）;
				}
			}
			
	}
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	public?String?getCdID（）?{
		return?cdID;
	}
	public?void?setCdID（String?cdID）?{
		this.cdID?=?cdID;
	}
	public?String?getCdName（）?{
		return?cdName;
	}
	public?void?setCdName（String?cdName）?{
		this.cdName?=?cdName;
	}
	public?String?getIntroduce（）?{
		return?introduce;
	}
	public?void?setIntroduce（String?introduce）?{
		this.introduce?=?introduce;
	}
	public?String?getPrice（）?{
		return?price;
	}
	public?void?setPrice（String?price）?{
		this.price?=?price;
	}
	public?String?getPublisher（）?{
		return?publisher;
	}
	public?void?setPublisher（String?publisher）?{
		this.publisher?=?publisher;
	}
	public?String?getSinger（）?{
		return?singer;
	}
	public?void?setSinger（String?singer）?{
		this.singer?=?singer;
	}
	
	
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????990??2009-12-24?22:40??db\checklogon.jsp

?????文件????????612??2009-12-23?19:02??db\emptycart.jsp

?????文件????????780??2009-12-23?19:02??db\index.html

?????文件???????2002??2009-12-23?19:03??db\shoppingcart.jsp

?????文件???????1046??2009-12-23?19:01??db\addcart.jsp

?????文件???????2176??2009-12-24?21:47??db\cdlist.jsp

?????文件????????544??2009-12-23?22:19??db\delcd.jsp

?????文件???????1324??2009-12-23?22:16??db\order.jsp

?????文件????????567??2009-12-23?19:03??db\leave.jsp

?????文件???????2329??2009-12-23?19:02??db\cdinfo.jsp

?????文件????????456??2009-12-23?18:59??db\sucessregister.jsp

?????文件???????1724??2009-12-23?18:52??db\register.jsp

?????文件???????1700??2009-12-24?21:45??db\searchcd.jsp

?????文件???????1617??2009-12-24?21:38??db\addcd.jsp

?????文件???????1274??2009-12-24?21:55??db\2012.sql

?????文件???????2752??2009-12-22?17:00??db\WEB-INF\classes\test\BuyerBean.class

?????文件???????3296??2009-12-23?20:28??db\WEB-INF\classes\test\CDBean.class

?????文件???????1276??2009-12-22?17:00??db\WEB-INF\classes\test\OrderBean.class

?????文件????????712??2009-12-22?17:00??db\WEB-INF\classes\test\RegisterBean.class

?????文件???????2449??2009-12-24?13:29??db\WEB-INF\classes\test\AddUserBean.class

?????文件???????1897??2009-12-24?21:45??db\WEB-INF\classes\test\SearchBean.class

?????文件???????3843??2009-12-24?21:39??db\WEB-INF\classes\test\AddCDBean.class

?????文件????????797??2009-12-18?23:02??db\src\OrderBean.java

?????文件???????1877??2009-12-19?11:38??db\src\BuyerBean.java

?????文件???????2663??2009-12-23?20:28??db\src\CDBean.java

?????文件????????355??2009-12-21?13:12??db\src\RegisterBean.java

?????文件???????1395??2009-12-24?13:29??db\src\AddUserBean.java

?????文件???????2544??2009-12-24?21:39??db\src\AddCDBean.java

?????文件????????972??2009-12-24?21:45??db\src\SearchBean.java

?????文件????????677??2009-12-23?18:54??db\images\1.GIF

............此處省略11個文件信息