package login;
import java.sql.*;
public class Library {
    String url = "jdbc:odbc:accessdemo";
    public String id,title,bsid;
    public String uid,ucourse,ustudentnumber,ucode,uphone,uemail,uoicq,umaxbook;
    public String bserialnumber,bsortnumber,btitle,bauthor1,bauthor2,bauthor3,bcover,bbookconcern,bpublicday,bisbn,btimes,bprize,binnumber,boutnumber;
    public String bsserialnumber,bssortnumber,bstitle,bsborrowdata,bsreturndata,bsoverdata,bsfee,bsreturnmoney,bsshouldreturndata;
    public int trailnumber=0,number=0,maxnumber=0;
    public int statbooknumber=0,statinbooknumber=0,statoutbooknumber=0,statprizenumber=0,aveprizenumber=0;
    public String userrights1,userrights2="";
    Connection conn;

    public Library() {
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn=DriverManager.getConnection(url,"","");
        }catch (Exception ex){
            ex.printStackTrace();
        }
    }
    public Connection getConn(){
        return conn;
    }
    public void setid(String s){
        this.id=s;
    }
    public void settitle(String s){
        this.title=s;
    }
    public String getid(){
        return id;
    }
    public String gettitle(){
        return title;
    }
    public void settrailnumber(int s){
        this.trailnumber=s;
    }
    public int gettrailnumber(){
        return trailnumber+1;
    }
    public void setuid(String s){
        this.uid=s;
    }
    public String getuid(){
        return uid;
    }
    public void setucourse(String s){
        this.ucourse=s;
    }
    public String getucoursed(){
        return ucourse;
    }
    public void setustudentnumber(String s){
        this.ustudentnumber=s;
    }
    public String getustudentnumber(){
        return ustudentnumber;
    }
    public void setucode(String s){
        this.ucode=s;
    }
    public String getucode(){
        return ucode;
    }
    public void setuphone(String s){
        this.uphone=s;
    }
    public String getuphone(){
        return uphone;
    }
    public void setuemail(String s){
        this.uemail=s;
    }
    public String getuemail(){
        return uemail;
    }
    public void setuoicq(String s){
        this.uoicq=s;
    }
    public String getuoicq(){
        return uoicq;
    }
    public void setumaxbook(String s){
        this.umaxbook=s;
    }
    public String getumaxbook(){
        return umaxbook;
    }
    public void setbserialnumber(String s){
        this.bserialnumber=s;
    }
    public String getbserialnumber(){
        return bserialnumber;
    }
    public void setbsortnumber(String s){
        this.bsortnumber=s;
    }
    public String getbsortnumber(){
        return bsortnumber;
    }
    public void setbtitle(String s){
        this.btitle=s;
    }
    public String getbtitle(){
        return btitle;
    }
    public void setbauthor1(String s){
        this.bauthor1=s;
    }
    public String getbauthor1(){
        return bauthor1;
    }
    public void setbauthor2(String s){
        this.bauthor2=s;
    }
    public String getbauthor2(){
        return bauthor2;
    }
    public void setbauthor3(String s){
        this.bauthor3=s;
    }
    public String getbauthor3(){
        return bauthor3;
    }
    public void setbcover(String s){
        this.bcover=s;
    }
    public String getbcover(){
        return bcover;
    }
    public void setbbookconcern(String s){
        this.bbookconcern=s;
    }
    public String getbbookconcern(){
        return bbookconcern;
    }
    public void setbpublicday(String s){
        this.bpublicday=s;
    }
    public String getbpublicday(){
        return bpublicday;
    }
    public void setbisbn(String s){
        this.bisbn=s;
    }
    public String getbisbn(){
        return bisbn;
    }
    public void setbtimes(String s){
        this.btimes=s;
    }
    public String getbtimes(){
        return btimes;
    }
    public void setbprize(String s){
        this.bprize=s;
    }
    public String getbprize(){
        return bprize;
    }
    public void setbinnumber(String s){
        this.binnumber=s;
    }
    public String getbinnumber(){
        return binnumber;
    }
    public void setboutnumber(String s){
        this.boutnumber=s;
    }
    public String getboutnumber(){
        return boutnumber;
    }
    public void setbsserialnumber(String s){
        this.bsserialnumber=s;
    }
    public String getbsserialnumber(){
        return bsserialnumber;
    }
    public void setbssortnumber(String s){
        this.bssortnumber=s;
    }
    public String getbssortnumber(){
        return bssortnumber;
    }
    public void setbstitle(String s){
        this.bstitle=s;
    }
    public String getbstitle(){
        return bstitle;
    }
    public void setbsborrowdata(String s){
        this.bsborrowdata=s;
    }
    public String getbsborrowdata(){
        return bsborrowdata;
    }
    public void setbsshouldreturndata(String s){
        this.bsshouldreturndata=s;
    }
    public String getbsshouldreturndata(){
        return bsshouldreturndata;
    }
    public void setbsreturndata(String s){
        this.bsreturndata=s;
    }
    public String getbsreturndata(){
        return bsreturndata;
    }
    public void setbsoverdata(String s){
        this.bsoverdata=s;
    }
    public String getbsoverdata(){
        return bsoverdata;
    }
    public void setbsfee(String s){
        this.bsfee=s;
    }
    public String getbsfee(){
        return bsfee;
    }
    public void setbsreturnmoney(String s){
        this.bsreturnmoney=s;
    }
    public String getbsreturnmoney(){
        return bsreturnmoney;
    }
    public void setnumber(int s){
        this.number=s;
    }
    public int getnumber(){
        return number;
    }
    public void setmaxnumber(int s){
        this.maxnumber=s;
    }
    public int getmaxnumber(){
        return maxnumber;
    }
    public void setbsid(String s){
        this.bsid=s;
    }
    public String getbsid(){
        return bsid;
    }
    public void setstatbooknumber(int s){
        this.statbooknumber=s;
    }
    public int getstatbooknumber(){
        return statbooknumber;
    }
    public void setstatinbooknumber(int s){
        this.statinbooknumber=s;
    }
    public int getstatinbooknumber(){
        return statinbooknumber;
    }
    public void setstatoutbooknumber(int s){
        this.statoutbooknumber=s;
    }
    public int getstatoutbooknumber(){
        return statoutbooknumber;
    }
    public void setstatprizenumber(int s){
        this.statprizenumber=s;
    }
    public int getstatprizenumber(){
        return statprizenumber;
    }
    public void setaveprizenumber(int s){
        this.aveprizenumber=s;
    }
    public int getaveprizenumber(){
        return aveprizenumber;
    }
    public void setuserrights1(String s){
        this.userrights1=s;
    }
    public String getuserrights1(){
        return userrights1;
    }
    public void setuserrights2(String s){
        this.userrights2=s;
    }
    public String getuserrights2(){
        return userrights2;
    }


}