www.pudn.com > TiKuMS.rar > DataConnection.java

/* 
 * 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; 
    } 
     
}