database.java

包括源代码

package DBOperation;

import java.sql.*;
/*
 * Database.java
 *
 * Created on 2008锟斤拷7锟斤拷12锟斤拷, 锟斤拷锟斤拷10:58
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

/**
 *
 * @author RJ-408
 */
public class Database {
    String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
    private Statement stmt=null;
    ResultSet rs=null;
    private Connection conn=null;
    String strurl="jdbc:odbc:TestSystem";
    /** Creates a new instance of Database */
    public Database() {
    }
    public void OpenConn()throws Exception{//锟斤拷锟斤拷菘锟絣锟斤拷
        try{
            Class.forName(DBDriver);
            conn=DriverManager.getConnection(strurl);
        }
        catch(Exception e){
            System.err.println("OpenConn:"+e.getMessage());
        }
    }
    public ResultSet executeQuery(String sql){//执锟斤拷sql锟斤拷洌