基于Java web的书店系统

package com.tutorialspoint.admin; import java.sql.*; import java.util.Collection; import java.util.Map; import java.util.Vector; import bean.*; import com.opensymphony.xwork2.ActionContext; import com.opensymphony.xwork2.ActionSupport; import java.io.*; public class BooklistAction extends ActionSupport{ private String op = ""; private String currentpage = ""; private String bookid=""; private String bookname=""; private String author=""; private String publisherid=""; private String pubdate=""; private String price=""; private String quantity=""; private String place=""; private String type=""; private String content=""; private String error=""; private String pubdate2=""; private String price2=""; private String quantity2=""; private String where=""; private String picture=""; private String employeeid=""; private String password=""; private int i_totalnum=0; //总记录数 private int i_pagenum=10; //一页显示的记录数码 private int i_totalpage=0; //总页数 private int i_currentpage=1; //当前页 private String totalnum=null; //总记录数 private String totalpage=null; //总页数 private File s_picture = null;//上传的文件 private String imageFileName; //文件名称 private String imageContentType; //文件类型 private bookBean book = null; private publisherBean publisher=null; public String execute() throws Exception{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection("jdbc:odbc:bookshoplk","sa",""); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); ResultSet rs=null; if(op.equals("index")){ return index(stmt,rs); } if(op.equals("add")){ publisher(stmt,rs); return "add"; } if(op.equals("addgo")){ return addgo(stmt,rs); } if(op.equals("search")) { publisher(stmt,rs); return "search"; } if(op.equals("searchgo")){ searchgo(); show(stmt,rs); return "searchgo"; } if(op.equals("delete")){ stmt.executeUpdate("delete from book where bookid='"+bookid+"'"); show(stmt,rs); return "success"; } if(op.equals("editshow")){ editshow(stmt,rs); return "editshow"; } if(op.equals("edit")){ return edit(stmt,rs); } if(op.equals("upload")) { String realpath = "D:\\myeclipse1\\MyBookStore\\WebRoot\\images"; try { FileOutputStream fos = new FileOutputStream(realpath+"\\"+imageFileName); FileInputStream fis = new FileInputStream(s_picture); byte[] buffer = new byte[1024]; int len = 0; try { while((len = fis.read(buffer)) > 0){ fos.write(buffer, 0, len); } } catch (IOException e) { e.printStackTrace(); } } catch (FileNotFoundException e) { e.printStackTrace(); } stmt.executeUpdate("update book set picture='"+imageFileName+"' where bookid='"+bookid+"'"); editshow(stmt,rs); show(stmt,rs); return "success"; } else{ show(stmt,rs); return "success"; } } public String index(Statement stmt,ResultSet rs)throws Exception{ rs=stmt.executeQuery("select * from employee where employeeid='"+employeeid+"' and password='"+password+"'"); if(rs.next()){ ActionContext actionContext = ActionContext.getContext(); Map session = actionContext.getSession(); session.put("admin",employeeid); show(stmt,rs); return "success"; } else{ error+="用户名或密码不正确"; return "error"; } } public void publisher(Statement stmt,ResultSet rs)throws Exception{ Collection b_publisher=new Vector(); rs=stmt.executeQuery("select * from publisher "); while(rs.next()){ publisher = new publisherBean(); publisher.publisherid = rs.getString("publisherid"); publisher.name = rs.getString("name"); b_publisher.add(publisher); } ActionContext.getContext().getSession().put("b_publisher",b_publisher); } public void show(Statement stmt,ResultSet rs) throws Exception{ if(op==null) { where=""; ActionContext actionContext = ActionContext.getContext(); Map session = actionContext.getSession(); session.put("where",where); } rs=stmt.executeQuery("select count(*) from book where bookid is not null "+where); rs.next(); i_totalnum=rs.getInt(1); i_totalpage=i_totalnum/i_pagenum; if(i_totalnum%i_pagenum!=0) i_totalpage++; if(op!=null&&op.equals("show")) { i_currentpage=Integer.parseInt(currentpage); } if(op!=null&&op.equals("previous")) { i_currentpage=Integer.parseInt(currentpage)-1; } if(op!=null&&op.equals("next")) { i_currentpage=Integer.parseInt(currentpage)+1; } if(op!=null&&op.equals("firstpage")) { i_currentpage=1; } if(op!=null&&op.equals("lastpage")) { i_currentpage=i_totalpage; } rs=stmt.executeQuery("select * from book left join publisher on book.publisherid=publisher.publisherid where bookid is not null "+where+" order by bookid "); if(i_currentpage>i_totalpage) i_currentpage=i_totalpage; int i_position=(i_currentpage-1)*i_pagenum; if(i_position==0) rs.beforeFirst(); else rs.absolute(i_position); ActionContext actionContext = ActionContext.getContext(); Map session = actionContext.getSession(); Collection b_book=new Vector(); for(int i=0;i<i_pagenum;i++) { bookBean bookbean=new bookBean(); if(!rs.isLast()){ rs.next(); bookbean.bookid=(rs.getString("bookid")!=null?rs.getString("bookid"):""); bookbean.bookname=(rs.getString("bookname")!=null?rs.getString("bookname"):""); bookbean.author=(rs.getString("author")!=null?rs.getString("author"):""); bookbean.price=(rs.getString("price")!=null?rs.getString("price"):""); bookbean.type=(rs.getString("type")!=null?rs.getString("type"):""); bookbean.quantity=(rs.getString("quantity")!=null?rs.getString("quantity"):""); bookbean.place=(rs.getString("place")!=null?rs.getString("place"):""); bookbean.publisherid=(rs.getString("name")!=null?rs.getString("name"):""); if(bookbean.type.equals("0")) bookbean.type="普通"; if(bookbean.type.equals("1")) bookbean.type="新书"; if(bookbean.type.equals("2")) bookbean.type="精品"; b_book.add(bookbean); } else break; } session.put("book",b_book); totalnum= i_totalnum+""; //总记录数 totalpage=i_totalpage+""; //总页数 currentpage=i_currentpage+""; //当前页 } public String addgo(Statement stmt,ResultSet rs)throws Exception{ content=content.replaceAll("\n","<br>"); content=content.replaceAll(" ","&nbsp;"); String s_sql="insert into book(bookid,bookname,author,publisherid,pubdate,price,quantity,place,type,content) "+ "values('"+bookid+"','"+bookname+"','"+author+"','"+publisherid+"','"+pubdate+"','"+price+"','"+quantity+"','"+place+"','"+type+"','"+content+"')"; try{ stmt.executeUpdate(s_sql); }catch(Exception e){ error+="新建图书出错："+e.getMessage(); return error; } show(stmt,rs); return "addgo"; } public void searchgo(){ if(!bookid.equals("")) where+=" and bookid like'%"+bookid+"%' "; if(!bookname.equals("")) where+=" and bookname like'%"+bookname+"%' "; if(!author.equals("")) where+=" and author like'%"+author+"%' "; if(!publisherid.equals("")) where+=" and book.publisherid ='"+publisherid+"' "; if(!pubdate.equals("")) where+=" and pubdate >='"+pubdate+"' "; if(!pubdate2.equals("")) where+=" and pubdate <='"+pubdate2+"' "; if(!price