电子商务网上书店系统

package myPk;
import java.sql.*;

public class Conn {
	private String driverName=“sun.jdbc.odbc.JdbcOdbcDriver“;
	private String dbUrl=“jdbc:odbc:bookShop“;
	private String userName=““;
	private String userPwd=““;
	private Connection conn;
	private Statement st;
	private Pageable rs;
	
	//连接数据库，执行语句，返回得到的记录项－－用于查询
	public void init（String sql） throws Exception
	{
		Class.forName（driverName）;
		conn=DriverManager.getConnection（dbUrl userNameuserPwd）;
		st=conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_UPDATABLE）;
		rs=new PageableResultSet2（st.executeQuery（sql））;
	}
	
	//判断记录欺罔是否为空，若为空则调用函数　init（sql）
	public Pageable getRs（String sql） throws Exception
	{
		if（rs==null） 
		{
			init（sql）;
		}
		return rs;
	}
	
	//执行 添加、更新、删除，无返回
	public void exeUpd（String sql） throws Exception
	{
		Class.forName（driverName）;
		conn=DriverManager.getConnection（dbUrluserNameuserPwd）;
		st=conn.createStatement（）;
		st.executeUpdate（sql）;
	}
	
	//关闭　查询　连接
	public void closeRs（） throws Exception
	{
		rs.close（）;
		st.close（）;
		conn.close（）;
	}
	
	//关闭　添加、更新、删除　连接
	public void closeNoRs（） throws Exception
	{
		st.close（）;
		conn.close（）;
	}
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        473  2007-01-14 11:01  fd网上书店ookShop.classpath

     文件        853  2007-01-07 22:16  fd网上书店ookShop.project

     文件        330  2007-01-07 22:16  fd网上书店ookShop.settingsorg.eclipse.jdt.core.prefs

     文件        217  2007-01-07 22:17  fd网上书店ookShop.settingsorg.eclipse.jst.common.project.facet.core.prefs

     文件        404  2007-01-07 22:17  fd网上书店ookShop.settingsorg.eclipse.wst.common.component

     文件        229  2007-01-07 22:17  fd网上书店ookShop.settingsorg.eclipse.wst.common.project.facet.core.xml

     文件       1976  2007-01-21 23:41  fd网上书店ookShopuildclassesmyPkConn.class

     文件       4350  2007-01-21 23:41  fd网上书店ookShopuildclassesmyPkFileUploadBean.class

     文件       7705  2007-01-21 23:41  fd网上书店ookShopuildclassesmyPkMd5.class

     文件        403  2007-01-21 23:41  fd网上书店ookShopuildclassesmyPkPageable.class

     文件      18053  2007-01-21 23:41  fd网上书店ookShopuildclassesmyPkPageableResultSet2.class

     文件       1302  2007-01-18 14:10  fd网上书店ookShopsrcmyPkConn.java

     文件       4703  2007-01-16 09:37  fd网上书店ookShopsrcmyPkFileUploadBean.java

     文件      14851  2007-01-13 11:12  fd网上书店ookShopsrcmyPkMd5.java

     文件        695  2007-01-07 22:19  fd网上书店ookShopsrcmyPkPageable.java

     文件      18382  2007-01-07 22:20  fd网上书店ookShopsrcmyPkPageableResultSet2.java

     文件       7616  2007-01-20 01:33  fd网上书店ookShopWebContentadmin-book-add.jsp

     文件       8043  2007-01-22 00:18  fd网上书店ookShopWebContentadmin-book.jsp

     文件       1856  2007-01-21 22:21  fd网上书店ookShopWebContentadmin-pwd.jsp

     文件       8968  2007-01-21 16:23  fd网上书店ookShopWebContentadmin-user.jsp

     文件       4984  2007-01-21 23:55  fd网上书店ookShopWebContentlue.css

     文件      10920  2007-01-22 02:00  fd网上书店ookShopWebContentook-information.jsp

     文件       4739  2007-01-21 02:30  fd网上书店ookShopWebContentook-list.jsp

     文件       2087  2007-01-18 17:08  fd网上书店ookShopWebContentottom.jsp

     文件        345  2007-01-15 22:19  fd网上书店ookShopWebContentclearSession.jsp

     文件     104166  2007-01-15 23:08  fd网上书店ookShopWebContentdataook.jpg

     文件       4096  2007-01-22 02:32  fd网上书店ookShopWebContentdataookShop.ldb

     文件     626688  2007-01-22 02:27  fd网上书店ookShopWebContentdataookShop.mdb

     文件      82406  2007-01-15 23:09  fd网上书店ookShopWebContentdatacampaign.jpg

     文件      78682  2007-01-21 03:10  fd网上书店ookShopWebContentdatafollow.jpg

............此处省略103个文件信息