addbookdb.java

JSP制作的一个在线书店 拥有简单的功能 请看看吧 初学者

package ConnBean;

import java.sql.*;
import common.BookInfoBean;
import java.util.*;

public class AddBookDB {
    ConnBean objCon = new ConnBean() ;
    Statement stmt = null;
    ResultSet rs = null;
    public AddBookDB() {
        this.stmt = objCon.getStmt() ;
    }

    public boolean InsertDB(BookInfoBean objB) {
        try {
            String strSqlI = "insert into bookinformation values ('" +
                             objB.getBookNo() + "'," + objB.getBookType() +
                             ",'" + objB.getBookName() + "'," + objB.getPrice() +
                             "," + objB.getBookCount() + ",'" +
                             objB.getBook_concern() + "','" + objB.getAuthor() +
                             "','" + objB.getImage() + "','" + objB.getIntroduc() +
                             "')";
            System.out.println(strSqlI);
            int value = this.stmt.executeUpdate(strSqlI);

            if (value == 1) {
                return true;
            } else {
                return false;
            }

        } catch (SQLException ex) {
            ex.printStackTrace();
            return false;
        }
    }

    public void Updata(String strSqlU) {
        try {
            objCon.stmt.executeUpdate(strSqlU);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }

    public ResultSet getResultSet(String strSqlS) {
        try {
            rs = objCon.stmt.executeQuery(strSqlS);
            return (rs);
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
    }

    public Vector SelectBook(String strsql)
{
  try{
       common.BookInfoBean objB=null;
      Vector v=new Vector();
      this.rs = stmt.executeQuery(strsql);
      while(rs.next())
      {
        objB=new BookInfoBean();
        objB.setBookNo(rs.getString(1));
        objB.setBookName(rs.getString(2));
        //objB.setBookType(rs.getInt(3));
        objB.setAuthor(rs.getString(4));
        objB.setBook_concern(rs.getString(5));
        //objB.setPrice(rs.getFloat(7));
        //objB.setBookCount(rs.getInt(8));
        objB.setIntroduc(rs.getString(9));
        v.add(objB);
      }
      return v;
  }catch(Exception e)
  {
      e.printStackTrace();
      return null;
  }

}

}