sqlserverdatabase.java

我用JAVA写的QQ程序

/*
 * SQLServerDatabase.java
 *
 * Created on 2007年5月3日, 上午12:06
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package 服务器端程序包;
import java.sql.*;
/**
 *
 * @author 王绿春
 */
public class SQLServerDatabase {
    String DataBaseDriver="sun.jdbc.odbc.JdbcOdbcDriver";
    String ConnectString="jdbc:odbc:WLCClientInformation";
    Connection WLCConnection=null;
    Statement WLCStament=null;
    ResultSet WLCResultSet=null;
    
    /**
     * Creates a new instance of SQLServerDatabase
     */
    public SQLServerDatabase() throws SQLException,ClassNotFoundException{
        Class.forName(DataBaseDriver);
        WLCConnection=DriverManager.getConnection(ConnectString);
        WLCStament=WLCConnection.createStatement();
        }
    public ResultSet ExecuteSelect(String sql) throws SQLException{
        WLCResultSet=null;
        WLCResultSet= WLCStament.executeQuery(sql);
        return WLCResultSet;
    }
    public void executeDML(String sql) throws SQLException{
        WLCStament.execute(sql);
    }
    
}