JavaEE网上书店源码（附数据库脚本）

包括前台 后台 能够实现用户购买图书，查看购物车，清空购物车，结算，查看订单等功能。

后台管理员可以查看订单，并修改订单状态，可以上架新图书，可以修改图书信息，增加或修改图书分类等。。

运行环境：myeclipse

MySQL

Tomcat

package cn.itcast.goods.admin.admin.dao;

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import cn.itcast.goods.admin.admin.domain.Admin;
import cn.itcast.jdbc.TxQueryRunner;

public class AdminDao {
	private QueryRunner qr = new TxQueryRunner（）;
	
	/**
	 * 通过管理员登录名和登录密码查询
	 * @param adminname
	 * @param adminpwd
	 * @return
	 * @throws SQLException
	 */
	public Admin find（String adminname String adminpwd） throws SQLException {
		String sql = “select * from t_admin where adminname=? and adminpwd=?“;
		return qr.query（sql new BeanHandler（Admin.class） adminname adminpwd）;
	}
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2018-06-13 21:31  bookstores\
     目录           0  2018-06-13 21:31  bookstores\goods\
     文件       48261  2018-06-13 18:54  bookstores\goods.sql
     文件        1083  2017-01-04 11:57  bookstores\goods\.classpath
     文件        1330  2017-01-04 12:06  bookstores\goods\.project
     目录           0  2018-06-13 21:31  bookstores\goods\.settings\
     文件         522  2017-01-04 11:57  bookstores\goods\.settings\.jsdtscope
     文件         206  2017-01-04 12:30  bookstores\goods\.settings\com.genuitec.eclipse.core.prefs
     文件        2525  2017-12-26 16:54  bookstores\goods\.settings\org.eclipse.core.resources.prefs
     文件         364  2017-01-04 11:57  bookstores\goods\.settings\org.eclipse.jdt.core.prefs
     文件         466  2017-01-04 11:57  bookstores\goods\.settings\org.eclipse.wst.common.component
     文件         414  2017-01-04 11:57  bookstores\goods\.settings\org.eclipse.wst.common.project.facet.core.xml
     文件          49  2017-01-04 11:57  bookstores\goods\.settings\org.eclipse.wst.jsdt.ui.superType.container
     文件           6  2017-01-04 11:57  bookstores\goods\.settings\org.eclipse.wst.jsdt.ui.superType.name
     目录           0  2018-06-13 21:31  bookstores\goods\build\
     目录           0  2018-06-13 21:31  bookstores\goods\build\classes\
     文件         636  2017-12-25 22:55  bookstores\goods\build\classes\c3p0-config.xml
     目录           0  2018-06-13 21:31  bookstores\goods\build\classes\cn\
     目录           0  2018-06-13 21:31  bookstores\goods\build\classes\cn\itcast\
     目录           0  2018-06-13 21:31  bookstores\goods\build\classes\cn\itcast\goods\
     目录           0  2018-06-13 21:31  bookstores\goods\build\classes\cn\itcast\goods\admin\
     目录           0  2018-06-13 21:31  bookstores\goods\build\classes\cn\itcast\goods\admin\admin\
     目录           0  2018-06-13 21:31  bookstores\goods\build\classes\cn\itcast\goods\admin\admin\dao\
     文件        1112  2018-05-21 10:21  bookstores\goods\build\classes\cn\itcast\goods\admin\admin\dao\AdminDao.class
     目录           0  2018-06-13 21:31  bookstores\goods\build\classes\cn\itcast\goods\admin\admin\domain\
     文件        1263  2018-05-21 10:21  bookstores\goods\build\classes\cn\itcast\goods\admin\admin\domain\Admin.class
     目录           0  2018-06-13 21:31  bookstores\goods\build\classes\cn\itcast\goods\admin\admin\service\
     文件        1117  2018-05-21 10:21  bookstores\goods\build\classes\cn\itcast\goods\admin\admin\service\AdminService.class
     目录           0  2018-06-13 21:31  bookstores\goods\build\classes\cn\itcast\goods\admin\admin\web\
     目录           0  2018-06-13 21:31  bookstores\goods\build\classes\cn\itcast\goods\admin\admin\web\servlet\
     文件        1704  2018-05-21 10:21  bookstores\goods\build\classes\cn\itcast\goods\admin\admin\web\servlet\AdminServlet.class
............此处省略868个文件信息