db.java

一个用JSP写的简单的同学录.采用的是Access数据库.提供管理员管理.

package db;
import java.sql.*;

public class  db{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:class";
Connection conn = null;
ResultSet rs = null;

public db() {
try {
Class.forName(sDBDriver); 
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("bbsreg(): " + e.getMessage());
}
}

public ResultSet execute(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr); 
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
} 
catch(SQLException ex) { 
System.err.println("aq.executeQuery: " + ex.getMessage());
System.err.println("aq.executeQuerystrSQL: " + sql);
}
return rs;
}

public String makepage(ResultSet testrs,String url,int page,int pagesize) {
int allpage=0;
String str="";  
try {
testrs.last();
allpage=testrs.getRow();
if (allpage>0) 
{ testrs.absolute((page-1) * pagesize +1);
allpage=(allpage+pagesize-1) / pagesize; 
str += "第 "+page+" 页  共 "+allpage + " 页";  
if(page>1)   
str+=" <A href="+url+"page="+ 1+">第一页</A> ";   
else  
str+=" 第一页 ";  
if(page>1)   
str+=" <A href="+url+"page="+(page-1)+">上一页</A> ";   
else  
str+=" 上一页 ";  
if(page <allpage)   
str+=" <A href="+url+"page="+(page+1)+">下一页</A> ";   
else   
str+=" 下一页 ";  
if(page <allpage)   
str+=" <A href="+url+"page="+allpage+">最后页</A> ";   
else  
str+=" 最后页 ";   
}
else 
str="zero";
} 
catch(Exception ex) { 
System.err.println("aq.executeQuery: " + ex.getMessage());
System.err.println("aq.executeQuerystrSQL: " + allpage);
} 
return str;
}
public void Update(String sql) {
try {
conn = DriverManager.getConnection(sConnStr); 
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
} 
catch(SQLException ex) { 
System.err.println("aq.executeUpdate: " + ex.getMessage());
System.err.println("aq.executeUpadatestrSQL: " + sql);
}
}

public void close() {
try {
conn.close(); 
} 
catch(SQLException ex) { 
System.err.println("aq.executeUpdate: " + ex.getMessage());
}
}
}