@TOC
JSP图书借阅系统
本系统是一套图书馆图书借阅管理系统，涉及后台管理员、图书管理员、用户，包括图书的管理、用户管理、信息维护等。
实现功能截图
登录：
读者主页面：
系统管理员主页面：
图书管理员主页面：
图书信息管理：
添加图书：
借阅记录查询：
用户管理：
图书管理：
技术点总结
jsp、Servlet jdk版本：1.7 tomcat: 7.0 数据库：mysql 开发工具：eclipse
项目包结构分类清晰：
（叉号有些是误报。。）
代码
实体类Entity: DingDan.java:
package com.itbaizhan.daowen.entity;
import java.util.Date;
import javax.persistence.*;
@Entity
public class Dingdan
{
@Id
@GeneratedValue(strategy =GenerationType.AUTO)
private int id ;
public int getId()
{
return id;
}
public void setId(int id)
{
this.id= id;
}
private String title ;
public String getTitle()
{
return title;
}
public void setTitle(String title)
{
this.title= title;
}
private String ddno ;
public String getDdno()
{
return ddno;
}
public void setDdno(String ddno)
{
this.ddno= ddno;
}
private Date xiadantime ;
public Date getXiadantime()
{
return xiadantime;
}
public void setXiadantime(Date xiadantime)
{
this.xiadantime= xiadantime;
}
private String xiadanren ;
public String getXiadanren()
{
return xiadanren;
}
public void setXiadanren(String xiadanren)
{
this.xiadanren= xiadanren;
}
private double totalprice ;
public double getTotalprice()
{
return totalprice;
}
public void setTotalprice(Double totalprice)
{
this.totalprice= totalprice;
}
private String status ;
public String getStatus()
{
return status;
}
public void setStatus(String status)
{
this.status= status;
}
private String fahuoren ;
public String getFahuoren()
{
return fahuoren;
}
public void setFahuoren(String fahuoren)
{
this.fahuoren= fahuoren;
}
private Date fahuotime ;
public Date getFahuotime()
{
return fahuotime;
}
public void setFahuotime(Date fahuotime)
{
this.fahuotime= fahuotime;
}
private String shouhuodizhi ;
public String getShouhuodizhi()
{
return shouhuodizhi;
}
public void setShouhuodizhi(String shouhuodizhi)
{
this.shouhuodizhi= shouhuodizhi;
}
private String shrtel ;
public String getShrtel()
{
return shrtel;
}
public void setShrtel(String shrtel)
{
this.shrtel= shrtel;
}
private String shraddress ;
public String getShraddress()
{
return shraddress;
}
public void setShraddress(String shraddress)
{
this.shraddress= shraddress;
}
private String shrname ;
public String getShrname()
{
return shrname;
}
public void setShrname(String shrname)
{
this.shrname= shrname;
}
private String des ;
public String getDes()
{
return des;
}
public void setDes(String des)
{
this.des= des;
}
}
Dingdanitems.java
package com.itbaizhan.daowen.entity;
import java.io.Serializable;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
@Entity
public class Dingdanitems implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private int id;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
private String spname;
public String getSpname() {
return spname;
}
public void setSpname(String spname) {
this.spname = spname;
}
private String spno;
private int shuliang;
public int getShuliang() {
return shuliang;
}
public void setShuliang(int shuliang) {
this.shuliang = shuliang;
}
private int spid;
private String jiage;
public String getJiage() {
return jiage;
}
public void setJiage(String jiage) {
this.jiage = jiage;
}
private String ddno;
public String getDdno() {
return ddno;
}
public void setDdno(String ddno) {
this.ddno = ddno;
}
private String spimage;
public String getSpimage() {
return spimage;
}
public void setSpimage(String spimage) {
this.spimage = spimage;
}
private String des;
public String getDes() {
return des;
}
public void setDes(String des) {
this.des = des;
}
public String getSpno() {
return spno;
}
public void setSpno(String spno) {
this.spno = spno;
}
public int getSpid() {
return spid;
}
public void setSpid(int spid) {
this.spid = spid;
}
}
数据库连接： HibernateSessionFactory.java:
package com.itbaizhan.daowen.util;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
import org.hibernate.cfg.AnnotationConfiguration;
/**
* Configures and provides access to Hibernate sessions, tied to the
* current thread of execution. Follows the Thread Local Session
* pattern, see {@link http://hibernate.org/42.html }.
*/
public class HibernateSessionFactory {
/**
* Location of hibernate.cfg.xml file.
* Location should be on the classpath as Hibernate uses
* #resourceAsStream style lookup for its configuration file.
* The default classpath location of the hibernate config file is
* in the default package. Use #setConfigFile() to update
* the location of the configuration file for the current session.
*/
private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";
private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
private static Configuration configuration = new AnnotationConfiguration();
private static org.hibernate.SessionFactory sessionFactory;
private static String configFile = CONFIG_FILE_LOCATION;
static {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err
.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
private HibernateSessionFactory() {
}
/**
* Returns the ThreadLocal Session instance. Lazy initialize
* the <code>SessionFactory</code> if needed.
*
* @return Session
* @throws HibernateException
*/
public static Session getSession() throws HibernateException {
Session session = (Session) threadLocal.get();
if (session == null || !session.isOpen()) {
if (sessionFactory == null) {
rebuildSessionFactory();
}
session = (sessionFactory != null) ? sessionFactory.openSession()
: null;
threadLocal.set(session);
}
return session;
}
/**
* Rebuild hibernate session factory
*
*/
public static void rebuildSessionFactory() {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err
.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
/**
* Close the single hibernate session instance.
*
* @throws HibernateException
*/
public static void closeSession() throws HibernateException {
Session session = (Session) threadLocal.get();
threadLocal.set(null);
if (session != null) {
session.close();
}
}
/**
* return session factory
*
*/
public static org.hibernate.SessionFactory getSessionFactory() {
return sessionFactory;
}
/**
* return session factory
*
* session factory will be rebuilded in the next call
*/
public static void setConfigFile(String configFile) {
HibernateSessionFactory.configFile = configFile;
sessionFactory = null;
}
/**
* return hibernate configuration
*
*/
public static Configuration getConfiguration() {
return configuration;
}
}
action层： DingdanAction.java:
package com.itbaizhan.daowen.action;
import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.text.MessageFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.itbaizhan.daowen.bll.SystemParam;
import com.itbaizhan.daowen.dal.DALBase;
import com.itbaizhan.daowen.entity.Attachement;
import com.itbaizhan.daowen.entity.Dingdan;
import com.itbaizhan.daowen.entity.Dingdanitems;
import com.itbaizhan.daowen.entity.Huiyuan;
import com.itbaizhan.daowen.entity.Shangpin;
import com.itbaizhan.daowen.util.PagerMetal;
public class DingdanAction extends PageActionBase {
public void onLoad() {
String actiontype = request.getParameter("actiontype");
System.out.println("actiontype=" + actiontype);
if (actiontype == null)
return ;
if(actiontype.equals("modifyAmount")){
modifyAmount();
}
if (actiontype.equals("shopcart")) {
shopcart();
}
if (actiontype.equals("clearshopcart")) {
clearshopcart();
}
if (actiontype.equals("removeShangpin")) {
removeShangpin();
}
if(actiontype.equals("payfor"))
fukuan();
if(actiontype.equals("fahuo"))
fahuo();
}
private void fahuo() {
String ddid=request.getParameter("ddid");
String fahuoren=request.getParameter("fahuoren");
if(ddid!=null)
{
Dingdan dingdan=(Dingdan)DALBase.load("dingdan", "where id="+ddid);
dingdan.setStatus("已发货");
dingdan.setFahuoren(fahuoren);
dingdan.setFahuotime(new Date());
DALBase.update(dingdan);
}
String forwardurl = request.getParameter("forwardurl");
if (forwardurl != null)
try {
response.sendRedirect(SystemParam.getSiteRoot() + forwardurl);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void fukuan() {
String ddid=request.getParameter("ddid");
String accountname=request.getParameter("accountname");
String errorurl=request.getParameter("errorurl");
if(ddid!=null)
{
Dingdan dingdan=(Dingdan)DALBase.load("dingdan", "where id="+ddid);
if(accountname!=null)
{
Huiyuan hy=(Huiyuan)DALBase.load("huiyuan", "where accountname='"+accountname+"'");
if(hy.getYue()<dingdan.getTotalprice()){
request.setAttribute("errormsg", "<label class='error'>账户余额不足于支付订单,请充值</label>");
try {
request.getRequestDispatcher("/e/huiyuan/fukuan.jsp?id="+ddid).forward(request, response);
return;
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else {
hy.setYue((float)(hy.getYue()-dingdan.getTotalprice()));
hy.setJifen(hy.getJifen()+(int)dingdan.getTotalprice());
DALBase.update(hy);
dingdan.setStatus("已付款");
DALBase.update(dingdan);
request.getSession().setAttribute("huiyuan", hy);
}
}
}
String forwardurl = request.getParameter("forwardurl");
if (forwardurl != null)
try {
response.sendRedirect(SystemParam.getSiteRoot() + forwardurl);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/*
* 修改购物车数量
* */
private void modifyAmount(){
String spid=request.getParameter("spid");
String shuliang=request.getParameter("shuliang");
List<Dingdanitems> temlist=(List<Dingdanitems>)request.getSession().getAttribute("cart");
if(temlist!=null)
{
for(Iterator<Dingdanitems> it= temlist.iterator();it.hasNext();)
{
Dingdanitems ddi=it.next();
if(ddi.getSpid()==new Integer(spid))
{
ddi.setShuliang(new Integer(shuliang));
}
}
}
calcuateTotalfee();
String forwardurl = request.getParameter("forwardurl");
if (forwardurl != null)
try {
response.sendRedirect(SystemParam.getSiteRoot() + forwardurl);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void removeShangpin() {
String spid=request.getParameter("spid");
List<Dingdanitems> temlist=(List<Dingdanitems>)request.getSession().getAttribute("cart");
if(temlist!=null)
{
for(Iterator<Dingdanitems> it= temlist.iterator();it.hasNext();)
{
Dingdanitems ddi=it.next();
if(ddi.getSpid()==new Integer(spid))
{
it.remove();
float totalfee=Float.parseFloat(request.getSession().getAttribute("totalfee").toString());
totalfee-=ddi.getShuliang()* Float.parseFloat(ddi.getJiage());
request.getSession().setAttribute("totalfee", totalfee);
}
}
}
String forwardurl = request.getParameter("forwardurl");
if (forwardurl != null)
try {
response.sendRedirect(SystemParam.getSiteRoot() + forwardurl);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void clearshopcart() {
request.getSession().removeAttribute("cart");
request.getSession().removeAttribute("totalfee");
String forwardurl = request.getParameter("forwardurl");
if (forwardurl != null)
try {
response.sendRedirect(SystemParam.getSiteRoot() + forwardurl);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void calcuateTotalfee()
{
List<Dingdanitems> cart = (List<Dingdanitems>) request.getSession()
.getAttribute("cart");
int totalfee=0;
for (Dingdanitems dditem : cart) {
totalfee += dditem.getShuliang()
* new Double(dditem.getJiage());
}
request.getSession().setAttribute("totalfee", totalfee);
}
private void shopcart() {
String forwardurl = request.getParameter("forwardurl");
// 商品ID
String spid = request.getParameter("spid");
// 商品名
String spname2 = request.getParameter("spname");
//
String command = request.getParameter("command");
// request.setCharacterEncoding("UTF-8");
float totalfee = 0;
List<Dingdanitems> cart = (List<Dingdanitems>) request.getSession()
.getAttribute("cart");
if (spid != null) {
if (cart == null) {
cart = new ArrayList<Dingdanitems>();
request.getSession().setAttribute("cart", cart);
}
Shangpin addshangpin = (Shangpin) DALBase.load("shangpin",
"where id=" + spid);
Boolean hasin = false;
for (Dingdanitems dditem : cart) {
System.out.println("addshangpin.getId()" + addshangpin.getId());
System.out.println("dditem.getId()" + dditem.getId());
if (addshangpin.getId() == dditem.getSpid()) {
hasin = true;
if (command!=null&&command.equals("modifyCount")) {
String shuliang = request.getParameter("shuliang");
dditem.setShuliang(new Integer(shuliang));
} else
dditem.setShuliang(dditem.getShuliang() + 1);
}
totalfee += dditem.getShuliang()
* new Double(dditem.getJiage());
}
if (!hasin) {
Dingdanitems temitem = new Dingdanitems();
temitem.setSpname(addshangpin.getName());
temitem.setSpimage(addshangpin.getTupian());
temitem.setSpno(addshangpin.getSpno());
temitem.setSpid(addshangpin.getId());
temitem.setShuliang(1);
temitem.setJiage(String.valueOf(addshangpin.getJiage()));
totalfee += addshangpin.getJiage();
cart.add(temitem);
}
}
request.getSession().setAttribute("totalfee", totalfee);
if (forwardurl != null)
try {
response.sendRedirect(SystemParam.getSiteRoot() + forwardurl);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/********************************************************
****************** 信息注销监听支持*****************************
*********************************************************/
public void delete() {
String id = request.getParameter("id");
DALBase.delete("dingdan", " where id=" + id);
binding();
}
/*************************************************************
**************** 保存动作监听支持******************************
**************************************************************/
public void save() {
String shouhuodizhi = request.getParameter("shouhuodizhi");
String shrtel = request.getParameter("shrtel");
String shraddress = request.getParameter("shraddress");
String shrname = request.getParameter("shrname");
String des = request.getParameter("des");
String xdren=request.getParameter("xdren");
String status=request.getParameter("status");
List<Dingdanitems> listitems=(List<Dingdanitems>)request.getSession().getAttribute("cart");
if(listitems==null){
try {
response.sendRedirect(SystemParam.getSiteRoot()+"/e/shangpinlist.jsp");
} catch (IOException e) {
e.printStackTrace();
}
return;
}
SimpleDateFormat sdfdingdan = new SimpleDateFormat("yyyy-MM-dd");
SimpleDateFormat sdf = new SimpleDateFormat("yyyymmddHHMMss");
String timestamp = sdf.format(new Date());
Dingdan dingdan = new Dingdan();
dingdan.setDdno("dd"+timestamp);
Double totalprice=0.0;
for(Dingdanitems dd : listitems){
dd.setDdno(dingdan.getDdno());
dd.setDes(xdren+"购买"+dd.getSpname());
totalprice+=Double.valueOf(dd.getJiage())*dd.getShuliang();
DALBase.save(dd);
}
dingdan.setTitle("");
dingdan.setXiadantime(new Date());
dingdan.setXiadanren(xdren);
dingdan.setTotalprice(totalprice);
//dingdan.setStatus("待付款");
dingdan.setStatus(status);
dingdan.setFahuotime(new Date());
//收货地址
dingdan.setShouhuodizhi(shouhuodizhi);
dingdan.setShrtel(shrtel);
dingdan.setShraddress(shraddress);
dingdan.setShrname(shrname);
dingdan.setDes(des);
DALBase.save(dingdan);
clearshopcart();
}
/******************************************************
*********************** 内部附件支持*********************
*******************************************************/
public void attachements(HttpServletRequest request,
HttpServletResponse response, String belongid) {
DALBase.delete("attachement", MessageFormat.format(
" where belongid=''{0}'' and belongtable=''dingdan'' ",
belongid));
String[] photos = request.getParameterValues("fileuploaded");
if (photos == null)
return;
for (int i = 0; i < photos.length; i++) {
Attachement a = new Attachement();
a.setType("images");
a.setPubtime(new Date());
a.setBelongfileldname("id");
a.setFilename(photos[i]);
a.setBelongid(belongid);
a.setBelongtable("dingdan");
a.setUrl(SystemParam.getSiteRoot() + "/upload/temp/"
+ a.getFilename());
a.setTitle(a.getFilename());
DALBase.save(a);
}
}
/******************************************************
*********************** 更新内部支持*********************
*******************************************************/
public void update() {
String forwardurl = request.getParameter("forwardurl");
String id = request.getParameter("id");
if (id == null)
return;
Dingdan dingdan = (Dingdan) DALBase
.load(Dingdan.class, new Integer(id));
if (dingdan == null)
return;
String title = request.getParameter("title");
String ddno = request.getParameter("ddno");
String xiadantime = request.getParameter("xiadantime");
String xiadanren = request.getParameter("xiadanren");
String totalprice = request.getParameter("totalprice");
String status = request.getParameter("status");
String fahuoren = request.getParameter("fahuoren");
String fahuotime = request.getParameter("fahuotime");
String shouhuodizhi = request.getParameter("shouhuodizhi");
String shrtel = request.getParameter("shrtel");
String shraddress = request.getParameter("shraddress");
String shrname = request.getParameter("shrname");
String des = request.getParameter("des");
SimpleDateFormat sdfdingdan = new SimpleDateFormat("yyyy-MM-dd");
dingdan.setTitle(title);
dingdan.setDdno(ddno);
try {
dingdan.setXiadantime(sdfdingdan.parse(xiadantime));
} catch (ParseException e) {
e.printStackTrace();
}
dingdan.setXiadanren(xiadanren);
dingdan.setTotalprice(totalprice == null ? (double) 0 : new Double(
totalprice));
dingdan.setStatus(status);
dingdan.setFahuoren(fahuoren);
try {
dingdan.setFahuotime(sdfdingdan.parse(fahuotime));
} catch (ParseException e) {
e.printStackTrace();
}
dingdan.setShouhuodizhi(shouhuodizhi);
dingdan.setShrtel(shrtel);
dingdan.setShraddress(shraddress);
dingdan.setShrname(shrname);
dingdan.setDes(des);
DALBase.update(dingdan);
binding();
}
/******************************************************
*********************** 加载内部支持*********************
*******************************************************/
public void load() {
//
String id = request.getParameter("id");
String actiontype = "save";
dispatchParams(request, response);
if (id != null) {
Dingdan dingdan = (Dingdan) DALBase.load("dingdan", "where id="
+ id);
if (dingdan != null) {
request.setAttribute("dingdan", dingdan);
}
actiontype = "update";
request.setAttribute("id", id);
}
request.setAttribute("actiontype", actiontype);
String forwardurl = request.getParameter("forwardurl");
System.out.println("forwardurl=" + forwardurl);
if (forwardurl == null) {
forwardurl = "/admin/dingdanadd.jsp";
}
try {
request.getRequestDispatcher(forwardurl).forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/******************************************************
*********************** 数据绑定内部支持*********************
*******************************************************/
public void binding() {
String filter = "where 1=1 ";
String xdren=request.getParameter("xiadanren");
String isurl=request.getParameter("isurl");
if(xdren!=null)
{
if(isurl!=null&&isurl.equals("1"))
try {
xdren=new String(xdren.getBytes("ISO-8859-1"),"UTF-8");
} catch (UnsupportedEncodingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
filter+=" and xiadanren='"+xdren+"'";
}
int pageindex = 1;
int pagesize = 10;
// 获取当前分页
String currentpageindex = request.getParameter("currentpageindex");
// 当前页面尺寸
String currentpagesize = request.getParameter("pagesize");
// 设置当前页
if (currentpageindex != null)
pageindex = new Integer(currentpageindex);
// 设置当前页尺寸
if (currentpagesize != null)
pagesize = new Integer(currentpagesize);
List<Dingdan> listdingdan = DALBase.getPageEnity("dingdan", filter,
pageindex, pagesize);
int recordscount = DALBase.getRecordCount("dingdan",
filter == null ? "" : filter);
request.setAttribute("listdingdan", listdingdan);
PagerMetal pm = new PagerMetal(recordscount);
// 设置尺寸
pm.setPagesize(pagesize);
// 设置当前显示页
pm.setCurpageindex(pageindex);
// 设置分页信息
request.setAttribute("pagermetal", pm);
// 分发请求参数
dispatchParams(request, response);
String forwardurl = request.getParameter("forwardurl");
System.out.println("forwardurl=" + forwardurl);
if (forwardurl == null) {
forwardurl = "/admin/dingdanmanager.jsp";
}
try {
request.getRequestDispatcher(forwardurl).forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
写在最后
码代码不容易，需要的同学可以参考学习，全部代码不能都贴出，如果需要可以+博主V交流获取（Code2Life2） 最后，别忘了一键三连哦
