dbms.java

这个是我自己写的网上书店的管理系统

package run;

import java.util.Vector;
import util.*;
import book.*;

import java.util.*;
import java.sql.*;
import java.lang.String;
import javax.servlet.http.HttpServletRequest;

public class dbms extends Database
{
	private user user = new user();	    //用户对象
	private Vector userlist;                //显示用户列表向量数组
	
	private books abooks = new books();    //图书对象
    private Vector abookslist;              //显示图书列表向量数组
    
	private bookclass bookclass = new bookclass(); //图书分类对象
	private Vector bookclasslist;                 //显示图书分类列表向量数组
	
	private allorder allorder = new allorder();  //总订单对象
	private Vector allorderlist;                 //显示订单列表向量数组
	
	private order order = new order();      //单个订单对象
	private Vector orderlist;               //显示订单列表向量数组
	
    private javax.servlet.http.HttpServletRequest request;  //建立页面请求
    private int page =1;					               //显示的页码
    private int pageSize=10;					          //每页显示的图书数
    private int pageCount =0;				             //页面总数
    private long recordCount =0;			            //查询的记录总数
    private String message = "";			           //出错信息提示
    public String sqlStr="";
    
    
    public boolean book_search(HttpServletRequest res) throws Exception    //负责所有图书的查询
    {
       sqlStr="select count(*) from book";
       Database db = new Database();
	   db.connect();
	   sm = db.conn.createStatement ();
	   
	   request = res;
	   String PAGE = request.getParameter("page");   //页码
	   try 
	   {
	           page = Integer.parseInt(PAGE);     //将页码转换成整数
	   }
	   catch (NumberFormatException e)
	   {
	           page = 1;                  //若出错则将页码赋值为1
	   }
	   
	   
 	   try 
 	   { 
 	       ResultSet rs1 = sm.executeQuery(sqlStr);
 	       if (rs1.next())
 	          recordCount = rs1.getInt(1);   //取出总记录数
 	       rs1.close();
 	   }
 	    catch (SQLException e) 
 	    {
 	        return false;
 	    }
 	    
          //设定有多少pageCount
 	      if (recordCount < 1)
 	        pageCount = 0;
 	      else
 	        pageCount = (int) (recordCount - 1) / pageSize + 1;
 	      
 	      
 	      //检查查看的页面数是否在范围内
 	      if (page < 1)
 	        page = 1;
 	      else if (page > pageCount)
 	        page = pageCount;
 	      int rscount = (int) recordCount % pageSize; // 最后一页记录数
 	      
 	      
         // 	   sql为倒序取值
 		   sqlStr = "select a.id,a.bookname,a.bookclass,b.classname,"+
 		           "a.author,a.publish,a.bookno,a.content,a.prince,a.amount,"+
 		           "a.Leav_number,a.regtime,a.picture from book a,bookclass b"+
 		          " where a.Bookclass = b.Id ";  
 		  if (page == 1)
          {
              sqlStr = sqlStr +"order by a.Id desc limit 0,"+pageSize;      //如果查询的第一页，直接按降序排列查询即可
          } 
          else 
          {
       	   if((recordCount-pageSize * (page-1))>=pageSize)     //若不是最后一页，每页显示10条记录
       	   {
       		   sqlStr = sqlStr + "limit "+pageSize*(page-1)+","+pageSize;
       	   }
       	   else
       	   {
       		   sqlStr = sqlStr + "limit "+pageSize*(page-1)+","+
		              (recordCount-pageSize * (page-1));
       	   }
       	  
          }
 	     
 	     
 	    try  
 	    {
 	              rs = sm.executeQuery(sqlStr);
 	              abookslist = new Vector(rscount);    //设定booklist的初始容量为rscount;
 	              while (rs.next()){
 	                                books book = new books();
 	                                book.setId(rs.getLong("id"));
 	                                book.setBookName(rs.getString("bookname"));
 	                                book.setBookClass(rs.getInt("bookclass"));
 	                                book.setClassName(rs.getString("classname"));
 	                                book.setAuthor(rs.getString("author"));
 	                                book.setPublish(rs.getString("publish"));
 	                                book.setBookNo(rs.getString("Bookno"));
 	                                book.setContent(rs.getString("content"));
 	                                book.setPrince(rs.getFloat("prince"));
 	                                book.setAmount(rs.getInt("amount"));
 	                                book.setLeav_number(rs.getInt("leav_number"));
 	                                book.setRegTime(rs.getString("regtime"));
 	                                book.setPicture(rs.getString("picture"));
 	                                abookslist.addElement(book);
 	                        }
 	                        rs.close();
 	                        return true;
 	    }
 	    catch (Exception e)
 	    {
 	           System.out.println(e.getMessage());
 	           return false;
 	    }
    }
    
    public boolean deletebook( int aid ) throws Exception   //图书表单个记录删除
    {
            sqlStr = "delete from book where id = "  + aid ;
            try
            {         Database db = new Database();
                      db.connect();
                      sm =db.conn.createStatement ();
                      sm.execute(sqlStr);
                     return true;
            }
            catch (SQLException e)
            {
                    System.out.println(e);
                    return false;
            }
    }
    
    public boolean user_search(HttpServletRequest res) throws Exception  //用户查询
    {
    	sqlStr="select count(*) from shop_user";
        Database db = new Database();
 	   db.connect();
 	   sm = db.conn.createStatement ();
 	   
 	   request = res;
 	   String PAGE = request.getParameter("page");   //页码
 	   try 
 	   {
 	           page = Integer.parseInt(PAGE);     //将页码转换成整数
 	   }
 	   catch (NumberFormatException e)
 	   {
 	           page = 1;                  //若出错则将页码赋值为1
 	   }
 	   
 	   
  	   try 
  	   { 
  	       ResultSet rs1 = sm.executeQuery(sqlStr);
  	       if (rs1.next())
  	          recordCount = rs1.getInt(1);   //取出总记录数
  	       rs1.close();
  	   }
  	    catch (SQLException e) 
  	    {
  	        return false;
  	    }
  	    
           //设定有多少pageCount
  	      if (recordCount < 1)
  	        pageCount = 0;
  	      else
  	        pageCount = (int) (recordCount - 1) / pageSize + 1;
  	      
  	      
  	      //检查查看的页面数是否在范围内
  	      if (page < 1)
  	        page = 1;
  	      else if (page > pageCount)
  	        page = pageCount;
  	      int rscount = (int) recordCount % pageSize; // 最后一页记录数
  	      
  	      
          // 	   sql为倒序取值
  		   sqlStr = "select id,username,password,names,sex,address,phone,post,email,regtime,regipaddress from shop_user ";  
  		  if (page == 1)
           {
               sqlStr = sqlStr +"order by Id desc limit 0,"+pageSize;      //如果查询的第一页，直接按降序排列查询即可
           } 
           else 
           {
        	   if((recordCount-pageSize * (page-1))>=pageSize)     //若不是最后一页，每页显示10条记录
        	   {
        		   sqlStr = sqlStr + "limit "+pageSize*(page-1)+","+pageSize;
        	   }
        	   else
        	   {
        		   sqlStr = sqlStr + "limit "+pageSize*(page-1)+","+
 		              (recordCount-pageSize * (page-1));
        	   }
        	  
           }
  	     
  	     
  	    try  
  	    {
  	              rs = sm.executeQuery(sqlStr);
  	              userlist = new Vector(rscount);    //设定booklist的初始容量为rscount;
  	              while (rs.next()){
  	            	                user user=new user();
  	            	                user.setId(rs.getLong("id"));
  	            	                user.setUserName(rs.getString("username"));
  	            	                user.setPassWord(rs.getString("password"));
  	            	                user.setRealName(rs.getString("names"));
  	            	                user.setSex(rs.getString("sex"));
  	            	                user.setAddress(rs.getString("address"));
  	            	                user.setPhone(rs.getString("phone"));
  	            	                user.setPost(rs.getString("post"));
  	            	                user.setEmail(rs.getString("email"));
  	            	                user.setRegTime(rs.getString("regtime"));
  	            	                user.setRegIpAddress(rs.getString("regipaddress"));
  	                                userlist.addElement(user);
  	                        }
  	                        rs.close();
  	                        return true;
  	    }
  	    catch (Exception e)
  	    {
  	           System.out.println(e.getMessage());
  	           return false;
  	    }
    }
    
    public boolean deleteuser( int aid ) throws Exception //图书表单个记录删除
    {
    	sqlStr = "delete from shop_user where id = "  + aid ;
        try
        {         Database db = new Database();
                  db.connect();
                  sm =db.conn.createStatement ();
                  sm.execute(sqlStr);
                 return true;
        }
        catch (SQLException e)
        {
                System.out.println(e);
                return false;
        }
    }
    
    public boolean order_search(HttpServletRequest res) throws Exception  //用户订单查询
    {
    	sqlStr="select count(*) from orders";
        Database db = new Database();
 	   db.connect();
 	   sm = db.conn.createStatement ();
 	   
 	   request = res;
 	   String PAGE = request.getParameter("page");   //页码
 	   try 
 	   {
 	           page = Integer.parseInt(PAGE);     //将页码转换成整数
 	   }
 	   catch (NumberFormatException e)
 	   {
 	           page = 1;                  //若出错则将页码赋值为1
 	   }
 	   
 	   
  	   try 
  	   { 
  	       ResultSet rs1 = sm.executeQuery(sqlStr);
  	       if (rs1.next())
  	          recordCount = rs1.getInt(1);   //取出总记录数
  	       rs1.close();
  	   }
  	    catch (SQLException e) 
  	    {
  	        return false;
  	    }
  	    
           //设定有多少pageCount
  	      if (recordCount < 1)
  	        pageCount = 0;
  	      else
  	        pageCount = (int) (recordCount - 1) / pageSize + 1;
  	      
  	      
  	      //检查查看的页面数是否在范围内
  	      if (page < 1)
  	        page = 1;
  	      else if (page > pageCount)
  	        page = pageCount;
  	      int rscount = (int) recordCount % pageSize; // 最后一页记录数
  	      
  	      
          // 	   sql为倒序取值
  		   sqlStr = "select id,orderid,userid,submittime,consignmenttime,totalprice,content,ipaddress,ispayoff,issales from orders ";  
  		  if (page == 1)
           {
               sqlStr = sqlStr +"order by Id desc limit 0,"+pageSize;      //如果查询的第一页，直接按降序排列查询即可
           } 
           else 
           {
        	   if((recordCount-pageSize * (page-1))>=pageSize)     //若不是最后一页，每页显示10条记录
        	   {
        		   sqlStr = sqlStr + "limit "+pageSize*(page-1)+","+pageSize;
        	   }
        	   else
        	   {
        		   sqlStr = sqlStr + "limit "+pageSize*(page-1)+","+
 		              (recordCount-pageSize * (page-1));
        	   }
        	  
           }
  	     
  	     
  	    try  
  	    {
  	              rs = sm.executeQuery(sqlStr);
  	              orderlist = new Vector(rscount);    //设定booklist的初始容量为rscount;
  	              while (rs.next()){
  	                                order ind = new order();
  	                                ind.setId(rs.getLong("id"));
  	                                ind.setOrderId(rs.getString("orderid"));
  	                                ind.setUserId(rs.getLong("userid"));
  	                                ind.setSubmitTime(rs.getString("submittime"));
  	                                ind.setConsignmentTime(rs.getString("consignmenttime"));
  	                                ind.setTotalPrice(rs.getFloat("totalprice"));
  	                                ind.setContent(rs.getString("content"));
  	                                ind.setIpAddress(rs.getString("ipaddress"));
  	                                if (rs.getInt("IsPayoff") == 1)
  	                                  ind.setPayoff(false);
  	                                else
  	                                  ind.setPayoff(true);
  	                                if (rs.getInt("IsSales") == 1)
  	                                  ind.setSales(false);
  	                                else
  	                                  ind.setSales(true);
  	                                orderlist.addElement(ind);
  	                        }
  	                        rs.close();
  	                        return true;
  	    }
  	    catch (Exception e)
  	    {
  	           System.out.println(e.getMessage());
  	           return false;
  	    }
    }
    
    
    public boolean deleteorder( int aid ) throws Exception //图书表单个记录删除
    {
    	sqlStr = "delete from orders where id = "  + aid ;
        try
        {         Database db = new Database();
                  db.connect();
                  sm =db.conn.createStatement ();
                  sm.execute(sqlStr);
                 return true;
        }
        catch (SQLException e)
        {
                System.out.println(e);
                return false;
        }
    }
    
    public Vector getAbookslist()
	{
		return abookslist;
	}
	public Vector getAllorderlist()
	{
		return allorderlist;
	}
	public Vector getBookclasslist()
	{
		return bookclasslist;
	}
	public Vector getOrderlist()
	{
		return orderlist;
	}
	public Vector getUserlist()
	{
		return userlist;
	}
	
	
	
	public dbms()
    {
    	
    }
	public int getPage()
	{
		return page;
	}
	public void setPage(int page)
	{
		this.page = page;
	}
	public int getPageCount()
	{
		return pageCount;
	}
	public void setPageCount(int pageCount)
	{
		this.pageCount = pageCount;
	}
	public int getPageSize()
	{
		return pageSize;
	}
	public void setPageSize(int pageSize)
	{
		this.pageSize = pageSize;
	}
	public long getRecordCount()
	{
		return recordCount;
	}
	public void setRecordCount(long recordCount)
	{
		this.recordCount = recordCount;
	}
    
    
    
    
    
	
}