conndb.java

jsp实现的分页连接数据库的新闻发布系统tomcat＋jsp+jdk1.4

package mypack;
import java.sql.*;
public class ConnDB {
    Connection con;
    ResultSet rs=null;
    public ConnDB()
    {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (Exception ex) {
            System.out.println(ex.toString());
        }
    }
    public ResultSet executeQuery(String sql)
    {
        try {
            con=DriverManager.getConnection("jdbc:odbc:MyDataSource","sa","");
            //通过该方式创建的ResultSet对象可以实现游标回滚
            Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
            rs=st.executeQuery(sql);
        } catch (Exception ex) {
            System.out.println(ex.toString());
        }
        return rs;
    }
    public int executeUpdate(String sql)
    {
        int result=0;
        try {
            con=DriverManager.getConnection("jdbc:odbc:MyDataSource","sa","");
            //通过该方式创建的ResultSet对象可以实现游标回滚
            Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
            result=st.executeUpdate(sql);

        } catch (Exception ex) {
            System.out.println(ex.toString());
        }
        return result;
    }
}