book.java

这是用JSP和SQL来开发的,基本完成了一个网上书店所要的功能,有待于加油的是细点

package j0202_05_book;
import java.sql.*;
public class Book
{ String spno,
         spname,
         sellprice,
         pagenum,
         spsize,
         writerintro,
         sppublisher,
         publishtime,
         banci,
         spintro,
         spimage;
  String message;
  Connection con;
  Statement sql;
  ResultSet rs;
  public Book()
  {try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  
      }
   catch(ClassNotFoundException e){}
  }
  public void setSpno(String bookspid)
   {spno=bookspid;
   }
  public String getSpno()
   {return spno;
   }
   
  public void setSpname(String bookname)
   {spname=bookname;
   }
  public String getSpname()
   {return spname;
   }
   
  public void setSellprice(String bookprice)
   {sellprice=bookprice;
   }
  public String getSellprice()
   {return sellprice;
   }
  public void setPagenum(String bookpage)
   {pagenum=bookpage;
   }
  public String getPagenum()
   {return pagenum;
   } 
  public void setSpsize(String booksize)
   {spsize=booksize;
   }
  public String getSpsize()
   {return spsize;
   }  
  public void setWriterintro(String bookwriter)
   {writerintro=bookwriter;
   }
  public String getWriterintro()
   {return writerintro;
   }   
  public void setSppublisher(String bookblisher)
   {sppublisher=bookblisher;
   }
  public String getSppublisher()
   {return sppublisher;
   }  
  public void setPublishtime(String booktime)
   {publishtime=booktime;
   }
  public String getPublishtime()
   {return publishtime;
   }  
  public void setBanci(String bookban)
   {banci=bookban;
   }
  public String getBanci()
   {return banci;
   } 
   
  public void setSpintro(String bookinf)
   {spintro=bookinf;
   }
  public String getSpintro()
   {return spintro;
   } 
   
   
    
  public String getMessage()
   {return message;
   } 
  public void addItem()
   {try{
     con=DriverManager.getConnection("jdbc:odbc:LocalServer","sa","");
     sql=con.createStatement();
     String s="'"+spno+"','"+spname+"','"+sellprice+"','"+pagenum+"','"+spsize+"','"+writerintro+"','"+sppublisher+"','"+publishtime+"','"+banci+"','"+spintro+"'"; 
     String condition="insert into spinf values"+"("+s+")"; 
     sql.executeUpdate(condition);
     message="录入成功";
     con.close();
       }
     catch(SQLException e)
       {message="请重新录入";
       }
    } 
 }