jsp+sqlserver网络书店

jsp+sqlserver网络书店jsp+sqlserver网络书店jsp+sqlserver网络书店

package com.lovo.cq.shoppingbook.common;

import java.sql.*;

public class DbUtil {

	private PreparedStatement pstmt = null;

	private Connection con = null;

	public DbUtil（） {
		try {
			Class.forName（“com.mysql.jdbc.Driver“）;
			con = DriverManager.getConnection（“jdbc:mysql://localhost/shopping10_1“
					“root“ “root“）;;
		} catch （ClassNotFoundException e） {
			e.printStackTrace（）;
		} catch （SQLException e） {
			e.printStackTrace（）;
		}
	}

	public Connection getCon（） {
		return con;
	}

	public void close（） {
		if （pstmt != null） {
			try {
				pstmt.close（）;
			} catch （SQLException e） {
				e.printStackTrace（）;
			}
		}
		if （con != null） {
			try {
				con.close（）;
			} catch （SQLException e） {
				e.printStackTrace（）;
			}
		}
	}
}

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

     文件        340  2009-07-28 21:30  ShoppingBook\ShoppingBook\.classpath

     文件        309  2009-07-28 21:30  ShoppingBook\ShoppingBook\.mymetadata

     文件       1230  2009-07-28 21:30  ShoppingBook\ShoppingBook\.project

     文件        798  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\common\DbUtil.java

     文件       1832  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\dao\BookDao.java

     文件        224  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\dao\OrderDao.java

     文件        182  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\dao\SubTypeDao.java

     文件        154  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\dao\SuperTypeDao.java

     文件        983  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\dao\UserDao.java

     文件      14560  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\daoimpl\BookDaoImpl.java

     文件        170  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\daoimpl\ErrPwdException.java

     文件        181  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\daoimpl\NameNotFoundException.java

     文件        175  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\daoimpl\NoMessageException.java

     文件        187  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\daoimpl\NoRelativeBooksException.java

     文件       2421  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\daoimpl\OrderDaoImpl.java

     文件       1207  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\daoimpl\SubTypeDaoImpl.java

     文件       1049  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\daoimpl\SuperTypeDaoImpl.java

     文件        173  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\daoimpl\UnLoginException.java

     文件       8320  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\daoimpl\UserDaoImpl.java

     文件        803  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\filter\ShoppingFilter.java

     文件       2733  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\filter\WordsFilter.java

     文件       4322  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\model\Model.java

     文件       2974  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\po\Book.java

     文件        940  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\po\Note.java

     文件        948  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\po\Order.java

     文件       1010  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\po\OrderItem.java

     文件        592  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\po\Page.java

     文件        580  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\po\SubType.java

     文件        418  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\po\SuperType.java

     文件       2077  2009-07-28 21:30  ShoppingBook\ShoppingBook\src\com\lovo\cq\shoppingbook\po\User.java

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