Java Web 网上书店管理系统

Java Web网上书店 J2EE，内含源代码，数据库。

package comm;

import java.sql.*;

public class ConnectionManager {
	private static final String DRIVER=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	private static final String URL=“jdbc:sqlserver://localhost:1433;DatabaseName=books“;
	private static final String UNAME=“sa“;
	private static final String UPASS=“123456“;
	public static Connection getCon（） throws SQLException{
		Connection con=null;
		try {
			Class.forName（DRIVER）;
			con=DriverManager.getConnection（URLUNAMEUPASS）;
		} catch （ClassNotFoundException e） {
			e.printStackTrace（）;
		}
		return con;
	}
	public static void allClose（Connection conPreparedStatement pstmtResultSet rs）{
		
			try {
				if（rs!=null）{
					rs.close（）;
				}
			} catch （SQLException e） {
				e.printStackTrace（）;
			}
			try {
				if（pstmt!=null）{
					pstmt.close（）;
				}
			} catch （SQLException e） {
				e.printStackTrace（）;
			}
			try {
				if（con!=null）{
					con.close（）;
				}
			} catch （SQLException e） {
				e.printStackTrace（）;
			}
	}
}

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

     文件          0  2010-08-02 08:55  网上书店\.metadata\.lock

     文件     264259  2010-08-05 09:12  网上书店\.metadata\.log

     文件         80  2010-08-04 21:35  网上书店\.metadata\.plugins\com.genuitec.eclipse.desktop\dialog_settings.xml

     文件       1663  2010-08-02 12:03  网上书店\.metadata\.plugins\com.genuitec.eclipse.sqlexplorer\ConnectionProfiles.xml

     文件      17026  2010-08-02 12:03  网上书店\.metadata\.plugins\com.genuitec.eclipse.sqlexplorer\SQLDrivers.xml

     文件       3403  2010-08-03 12:26  网上书店\.metadata\.plugins\com.genuitec.eclipse.templates\velocity.log

     文件      19775  2010-08-05 09:11  网上书店\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\staticbindings_5.5.0.css

     文件          0  2010-08-02 08:55  网上书店\.metadata\.plugins\com.genuitec.org.hibernate.eclipse\hibernate-tools.log

     文件        652  2010-08-02 11:48  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\1\80c5d6d5e89d001f1705b661b00c51c7

     文件       1012  2010-08-02 14:25  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\1\d0ee14c2fe9d001f1dd2b403827e70e8

     文件       3158  2010-08-03 11:09  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\10\102c3e29af9e001f138ed7e75befeff2

     文件       5036  2010-08-03 09:06  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\10\2083a37a9b9e001f138ed7e75befeff2

     文件       5048  2010-08-03 09:07  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\10\906656ab9b9e001f138ed7e75befeff2

     文件          0  2010-08-03 21:07  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\10\b076da0a009f001f11f4bcbc86a67957

     文件       1778  2010-08-02 11:43  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\12\a0694314e89d001f1705b661b00c51c7

     文件       1317  2010-08-02 10:19  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\13\508181d3dc9d001f12b6e9ba0fca6ffc

     文件       7222  2010-08-03 09:24  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\14\60029c90a59e001f138ed7e75befeff2

     文件       4903  2010-08-04 17:04  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\14\707a09d4a79f001f1ebdbd1f94234226

     文件       4849  2010-08-03 09:29  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\14\d0b3b9bed89e001f1187881d42200785

     文件       2934  2010-08-03 11:17  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\15\c058c2bfad9e001f138ed7e75befeff2

     文件       4424  2010-08-03 10:07  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\16\506849d4a49e001f138ed7e75befeff2

     文件        585  2010-08-03 10:19  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\16\70427448a79e001f138ed7e75befeff2

     文件       2290  2010-08-03 09:24  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\16\80ea10da9d9e001f138ed7e75befeff2

     文件       4852  2010-08-02 15:14  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\16\d0d782eb059e001f1dd2b403827e70e8

     文件        860  2010-08-02 11:51  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\18\3071f4f5ea9d001f1705b661b00c51c7

     文件       1280  2010-08-03 21:10  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\19\50bc6085009f001f11f4bcbc86a67957

     文件       1307  2010-08-03 11:42  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\19\50f5861db49e001f138ed7e75befeff2

     文件       1539  2010-08-02 14:09  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\19\f0205893fc9d001f1dd2b403827e70e8

     文件        754  2010-08-02 11:50  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\1a\408c9526e99d001f1705b661b00c51c7

     文件       1413  2010-08-02 15:26  网上书店\.metadata\.plugins\org.eclipse.core.resources\.history\1c\b022ed95079e001f1dd2b403827e70e8

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