package?com.cn.bike;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?com.cn.jdbc.JDBC_Connection;

public?class?AddBike?{

	public?void?addBike（BikesVo?bikesVo）{
		Connection?conn?=?null;
		PreparedStatement?pstm?=?null;
		ResultSet?rs?=?null;

		try?{
			//調用JDBC_Connection類的getConnection方法連接數據庫
			conn?=?JDBC_Connection.getConnection（）;
			//添加數據的sql語句
			String?sql?=?
				“insert?into?bikes（bikenumberbiketypecolorpricerentpricedepositisrentingdescription）?values（????????）“;
			pstm?=?conn.prepareStatement（sql）;
			pstm.setString（1?bikesVo.getBikenumber（））;
			pstm.setString（2?bikesVo.getBiketype（））;
			pstm.setString（3?bikesVo.getColor（））;
			pstm.setDouble（4?bikesVo.getPrice（））;
			pstm.setDouble（5?bikesVo.getRentprice（））;
			pstm.setDouble（6?bikesVo.getDeposit（））;
			pstm.setInt（7?bikesVo.getIsrenting（））;
			pstm.setString（8?bikesVo.getDescription（））;
			pstm.executeUpdate（）;//提交pstm對象
			System.out.println（“添加成功！添加的內容如下：“）;
			System.out.println（）;

		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}?finally?{
			JDBC_Connection.free（rs?conn?pstm）;
		}
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-03-25?03:26??rentbikes\
?????文件?????????300??2011-06-21?07:54??rentbikes\.mymetadata
?????目錄???????????0??2012-03-25?03:26??rentbikes\.settings\
?????文件???????????6??2011-06-21?07:54??rentbikes\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件?????????629??2011-06-21?07:59??rentbikes\.settings\org.eclipse.jdt.core.prefs
?????文件?????????500??2011-06-21?07:54??rentbikes\.settings\.jsdtscope
?????文件??????????49??2011-06-21?07:54??rentbikes\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????目錄???????????0??2012-03-25?03:26??rentbikes\src\
?????目錄???????????0??2012-03-25?03:26??rentbikes\src\com\
?????目錄???????????0??2012-03-25?03:26??rentbikes\src\com\cn\
?????目錄???????????0??2012-05-08?00:43??rentbikes\src\com\cn\login\
?????文件????????1747??2012-05-08?00:43??rentbikes\src\com\cn\login\LoginServlet.java
?????文件????????1396??2011-06-21?00:30??rentbikes\src\com\cn\login\Login.java
?????文件????????1747??2012-05-08?00:43??rentbikes\src\com\cn\login\LoginServlet.java~
?????目錄???????????0??2012-03-25?03:26??rentbikes\src\com\cn\renttable\
?????文件????????2221??2011-06-21?04:01??rentbikes\src\com\cn\renttable\RenttableVo.java
?????目錄???????????0??2012-03-25?03:26??rentbikes\src\com\cn\users\
?????文件????????1417??2011-06-21?00:30??rentbikes\src\com\cn\users\ShowUserByIDServlet.java
?????文件????????1154??2011-06-21?00:30??rentbikes\src\com\cn\users\AddUsers.java
?????文件????????1287??2011-06-21?00:30??rentbikes\src\com\cn\users\ShowUserById.java
?????文件????????2324??2011-06-21?00:30??rentbikes\src\com\cn\users\UpdateUserServlet.java
?????文件?????????680??2011-06-21?00:30??rentbikes\src\com\cn\users\DeleteUser.java
?????文件????????1634??2011-06-21?00:30??rentbikes\src\com\cn\users\UsersVo.java
?????文件????????1960??2011-06-21?00:30??rentbikes\src\com\cn\users\AddUserServlet.java
?????文件????????1065??2011-06-21?00:30??rentbikes\src\com\cn\users\DeleteUserServlet.java
?????文件????????1526??2011-06-21?00:30??rentbikes\src\com\cn\users\ShowUsersServlet.java
?????文件????????1274??2011-06-21?00:30??rentbikes\src\com\cn\users\UpdateUser.java
?????文件????????2325??2011-06-21?00:30??rentbikes\src\com\cn\users\ShowUsers.java
?????目錄???????????0??2011-06-21?10:27??rentbikes\src\com\cn\test\
?????目錄???????????0??2012-03-25?03:26??rentbikes\src\com\cn\jdbc\
?????文件????????2043??2011-06-21?00:40??rentbikes\src\com\cn\jdbc\JDBC_Connection.java
............此處省略292個文件信息