dataconnection.java

题库管理系统,用最新的jsp技术开发的,里面有一些比较好的方法,希望与大家共享

/*
 * DataConnection.java
 *
 * Created on 2006年10月20日, 上午12:12
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package TiKuMS;
import java.sql.*;

/**
 *
 * @author hp
 */
public class DataConnection {
    private static final String DRIVER="sun.jdbc.odbc.JdbcOdbcDriver";
    private static final String CONN="jdbc:odbc:mysql;database=TiKuMS";
    private Connection conn;
    private Statement stmt;
    private ResultSet rs;
    private boolean loaded=false;
    /** Creates a new instance of DataConnection */
    public DataConnection() throws ClassNotFoundException, SQLException {
            Class.forName(DRIVER);
            conn=DriverManager.getConnection(CONN);
            stmt=getConn().createStatement();
            loaded=true;
    }
    public boolean excute(String sql) throws SQLException
    {
        return stmt.execute(sql);
    }
    public void excuteQuery(String sql) throws SQLException
    {
         rs=stmt.executeQuery(sql);
    }
    public Connection getConn() {
        return conn;
    }

    public Statement getStmt() {
        return stmt;
    }

    public boolean isLoaded() {
        return loaded;
    }

    public ResultSet getRs() {
        return rs;
    }
    
}