{ try { conn.close(); //关闭连接对象 } catch(SQLException e) { e.printStackTrace(); } finally { conn=null; //设置连接对象为null值 } } }
//为数据库添加对应的类 public class BookInfo {
private String Book_id; //图书编号 private String typeid; //类别编号 private String writer; //作者 private String translator; //译者 private String publisher; //出版社 private Date date; //出版日期 private Double price; //图书单价 private String getBookname; //图书名称 public String getBookname() { return bookname; }
public void setBookname(String bookname) { this.bookname=bookname; }
public Date getDate() { return date; }
public void setDate(Date date) { this.date=date; }
public string getBook_id()
{ return Book_id; }
public void setBook_id(String Book_id) { this.Book_id=Book_id; }
public Double getPrice() { return price; }
public void setprice(Double price) { this.price=price; }
public String getPublisher() { return Publisher; }
public void setPublisher(String publisher) { this.Publisher=Publisher; }
public String getTranslator() { return translator; }
public void setTranslator(String translator) { this.translator=translator; }
public String getTypeid() { return typeid; }
public void setTypeid(String typeid) { this.typeid=typeid; }
public String getWriter() { return writer; }
public void setWriter(String writer)
{ this.writer=writer; } }
public class BookType //图书列表信息类 {
private String id; //图书类别编号
private String typeName; //图书类别名称 private String days; //可解天数 private String fk; //每罚款金额 public String getFk() { return fk; }
public void setFk(String fk) { this.fk=fk; }
public String getDays() { return days; }
public void setDays(String days) { this.days=days; }
public string getId() { return id; }
public void setId(String id) { this.Bid=id; }
public String getTypeName() { return typeName; }
public void setTypeName(String typeName) { this.typeName=typeName; } }
public class Order //图书订单信息类
{
private String Book_id; //图书编号 private Date date; //下单时间 private String number; //图书数量 private String operator; //操作员
private String checkAndAccept; //是否收到货 private String zk; //图书折扣 public String getcheckAndAccept() { return checkAndAccept; }
public void setcheckAndAccept(String checkAndAccept) { this.checkAndAccept=checkAndAccept; }
public Date getDate() { return date; }
public void setDate(Date date) { this.date=date; }
public string getBook_id() { return book_id; }
public void setBook_id(String book_id) { this.book_id=book_id; }
public String getNumber() { return number; }
public void setNumber(String number) { this.number=number; }
public String getOperator() { return operator; }
public void setOperator(String operator)
{ this.operatorr=operator; }
public String getZk() { return zk; }
public void setZk(String Zk) { this.zk=zk; } }
public class Operater {
private String id; //操作员编号
private String name; //操作员用户名 private String grade; //操作员等级 private String password; //操作员密码 private String type; //出版社 public String getType() { return type; }
public void setType(String type) { this.type=type; }
public string getGrade() { return grade; }
public void setGrade(String grade) { this.grade=grade; }
public String getId() { return id; }
public void setId(String id) { this.id=id; }
public String getName()
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读,免费范文网,提供经典小说教育文库图书管理系统数据库源代码(2)在线全文阅读。
相关推荐: