library.java~8~

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

package login;
import java.sql.*;
public class Library {
    String url = "jdbc:odbc:accessdemo";
    public String id;
    public String title;
    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;
    }

}