library.java~9~

这是一个图书馆管理系统的jsp代码

package login;
import java.sql.*;
public class Library {
    String url = "jdbc:odbc:accessdemo";
    public String id,title;
    public String uid,ucourse,ustudentnumber,ucode,uphone,uemail,uoicq,umaxbook;
    public int trailnumber=0;
    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;
    }









}