JSP 校园二手市场

校园二手市场 哥们买的 贡献出来！

package bean;
import java.sql.*;
public class dbConn {
        Connection conn = null;
        ResultSet rs = null;
    
        //构造函数
        public dbConn（） 
        {
                
        }
        
       //查询
        public ResultSet executeQuery（String sql） {
                try {
                	try
					{
						Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）;
					} catch （ClassNotFoundException e）
					{
						// TODO Auto-generated catch block
						e.printStackTrace（）;
					}
                	String url=“jdbc:microsoft:sqlserver://localhost:1433;databaseName=ygEBuy“;
                	String user=“sa“;
                	String password=“sa“;
                	conn = DriverManager.getConnection（urluserpassword）;
                        Statement stmt = conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
                        
			rs = stmt.executeQuery（sql）;
                }
                catch（SQLException ex） {
                        System.err.println（ex.getMessage（））;
                }
                return rs;
                
        }
        
        //插入或更新
        public int executeUpdate（String sql） {
                int result = 0;
                try {
                	try
					{
						Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）;
					} catch （ClassNotFoundException e）
					{
						// TODO Auto-generated catch block
						e.printStackTrace（）;
					}
                	String url=“jdbc:microsoft:sqlserver://localhost:1433;databaseName=ygEBuy“;
                	String user=“sa“;
                	String password=“sa“;
                	conn = DriverManager.getConnection（urluserpassword）;
                        Statement stmt = conn.createStatement（）;
                        result = stmt.executeUpdate（sql）;
                }
                catch（SQLException ex） {
                        System.err.println（ex.getMessage（））;
                }
                return result;
               
        }
        
        		////关闭数据库连接
		public void dbClose（） {
                try {
                        conn.close（）;
                }
                catch（SQLException ex） {
                        System.err.println（ex.getMessage（））;
                }
        }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2012-02-21 23:35  SH\
     文件         622  2012-02-21 23:26  SH\.classpath
     目录           0  2012-02-21 23:35  SH\.myeclipse\
     文件         279  2012-02-21 23:21  SH\.mymetadata
     文件        1342  2007-05-13 21:20  SH\.project
     目录           0  2012-02-21 23:35  SH\src\
     目录           0  2012-02-21 23:35  SH\src\bean\
     文件        2388  2012-02-21 23:29  SH\src\bean\dbConn.java
     文件        1337  2007-05-13 22:35  SH\src\bean\Goods.java
     文件        1173  2007-05-13 23:14  SH\src\bean\Shop.java
     文件         232  2007-05-13 23:01  SH\src\bean\Test.java
     文件        5628  2007-05-21 10:43  SH\src\bean\UploadBean.java
     目录           0  2012-02-21 23:35  SH\WebRoot\
     文件        4834  2007-05-24 21:43  SH\WebRoot\anyQuery.jsp
     文件        3455  2007-05-24 16:06  SH\WebRoot\buyDisplay.jsp
     文件        3473  2007-05-24 20:51  SH\WebRoot\buyQuery.htm
     文件        3697  2007-05-25 11:53  SH\WebRoot\buyQuery.jsp
     文件         467  2007-05-14 01:40  SH\WebRoot\cartDel.jsp
     文件        3856  2007-05-24 21:13  SH\WebRoot\cartDisplay.jsp
     文件         616  2007-05-14 01:16  SH\WebRoot\changeNum.jsp
     目录           0  2012-02-21 23:35  SH\WebRoot\img\
     文件       50318  2007-05-24 19:27  SH\WebRoot\img\11111.jpg
     文件        2350  2007-05-24 19:27  SH\WebRoot\img\2%.JPG
     文件        4863  2007-05-24 19:27  SH\WebRoot\img\logo.jpg
     文件       68830  2007-05-24 19:27  SH\WebRoot\img\logo.png
     目录           0  2012-02-21 23:35  SH\WebRoot\img\upload\
     文件        6030  2007-05-24 19:27  SH\WebRoot\img\upload\1166937136390.jpg
     文件        7272  2007-05-24 19:27  SH\WebRoot\img\upload\1166937165796.jpg
     文件       12794  2007-05-24 19:27  SH\WebRoot\img\upload\1166937200515.jpg
     文件       14415  2007-05-24 19:27  SH\WebRoot\img\upload\1166937225218.jpg
     文件       10474  2007-05-24 19:27  SH\WebRoot\img\upload\1166937258390.jpg
............此处省略71个文件信息