bg_bookmanage.java

用J2EE开发的网站,可以应用到图书馆,图书超市

package ksnb;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.GregorianCalendar;
import java.util.*;
import java.sql.*;

public class BG_bookmanage {
    String Id;         //书Id
    String Catalog_Id; //分类id
    String Name;      //书名
    String Author;    //作者
    String Price;      //价格
    String Book_Concern;  //出版社
    String discount;    //会员打折率
    String ISBN;         //书的ISBN号
    String Keywords;     //关键字
    String Importance_Show;  //推荐级别
    String Date_time;      //上架时间
    String Page_Count;     //页数
    String Counts;        //库存量
    String Img_path;
    String Description;  //图书描述
    transform tf=new transform();
    SQL_execute book= new  SQL_execute();
    int x;
    public BG_bookmanage() {
    }
    public int update(HttpServletRequest request, HttpServletResponse response)
    {
        Id=request.getParameter("Id");
        Catalog_Id=tf.GBK(request.getParameter("Catalog_Id"));
        Name=tf.GBK(request.getParameter("Name"));
        Author=tf.GBK(request.getParameter("Author"));
        Price=request.getParameter("Price");
        Book_Concern=tf.GBK(request.getParameter("Book_Corcern"));
        discount=tf.GBK(request.getParameter("discount"));
        ISBN=request.getParameter("ISBN");
        Keywords=tf.GBK(request.getParameter("Keywords"));
        Importance_Show=tf.GBK(request.getParameter("Importance_Show"));
        Page_Count=request.getParameter("Page_Count");
        Counts=request.getParameter("Counts");
        Description=tf.GBK(request.getParameter("Description"));
        System.out.println(Description);


        String string= "Name='"+Name+"',Keywords='"+Keywords+"',Importance_Show='"+Importance_Show+"',Page_Count='"+Page_Count+"',Counts='"+Counts+"',Catalog_Id='"+Catalog_Id+"',Author='"+Author+"',Price='"+Price+"',Book_Concern='"+Book_Concern+"',discount='"+discount+"',Description='"+Description+"',ISBN='"+ISBN+"'";
        String updatebooksql="update Shop_Product_Info set "+string+"  where Id='"+Id+"'";
        System.out.println(updatebooksql);
        try {
            x=book.update(updatebooksql);
        }
        catch (Exception e)
        {
            System.out.println("进行图书修改时出现错误，所在的javaBean为:BG_bookmanage");
            System.out.println(e.toString());
            book.close();
        }
        return x;
    }
    public int delete(HttpServletRequest request, HttpServletResponse response)
    {
        String Id=request.getParameter("Id");
        System.out.println("已提交到后台图书修改！！所提交的图书ID是："+Id);
        String sqldelbook="delete Shop_Product_Info where id='"+Id+"'";
        try{
            x=book.update(sqldelbook);
        }
        catch(Exception e)
        {
            System.out.println("进行图书删除出现错误，所在的javaBean为:BG_bookmanage");
            book.close();
        }
        return x;
    }

    public int add(HttpServletRequest request, HttpServletResponse response)
    {

        Catalog_Id=tf.GBK(request.getParameter("Catalog_Id"));
        Book_Concern=tf.GBK(request.getParameter("Book_Corcern"));
        ISBN=request.getParameter("ISBN");
        Name=tf.GBK(request.getParameter("Name"));
        Author=tf.GBK(request.getParameter("Author"));
        Description=tf.GBK(request.getParameter("Description"));// 商品描述
        Keywords=tf.GBK(request.getParameter("Keywords"));
        Img_path=request.getParameter("Img_path");
        Price=request.getParameter("Price");
        discount=tf.GBK(request.getParameter("discount"));
        Importance_Show=request.getParameter("Importance_Show");
        Page_Count=request.getParameter("Page_Count");
        Counts=request.getParameter("Counts");

        //获取当前系统时间
        //GregorianCalendar cc = new GregorianCalendar();
        //Date_time= cc.getTime().toString();
        java.util.Date date=new java.util.Date();
        java.sql.Date Date_time=new java.sql.Date(date.getTime());
        String string=Catalog_Id+ "','"+Book_Concern+ "','"+ISBN+ "','"+Name+ "','"+Author+ "','"+Description+ "','"+Keywords+ "','"+ Img_path+ "','"+Price+ "','"+discount+ "','"+Importance_Show+ "','"+Page_Count+ "','"+Counts+ "','"+Date_time+"','"+1;
        String sql = "insert Shop_Product_Info(Catalog_Id,Book_Concern,ISBN,Name,Author,Description,Keywords,Img_path,Price,discount,Importance_Show,Page_Count,Counts,Date_time,New_book)values('" + string +"')"; //(Name,Pwd,Name,age,Sex,Address,Tel,Email)
        System.out.println(sql);
        try
        {
            x=book.update(sql);
            book.close();
        }
        catch(Exception e)
        {
            System.out.println("进行图书增加时出现错误，所在的javaBean为:BG_bookmanage");
            book.close();
        }
        return x;
    }


}