SQLHelper

package cn.edu.sicnu.cs.testdb2;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class SQLHelper {

    private String ServerName="127.0.0.1";
    private String DataBaseName="TestDB";
    private String DSN="fxk";
    private String UserName="test";
    private String UserPassword="123";
    private Connection conn;
    private Statement stm;
    public SQLHelper()
    {
        try
        {
            //������������
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            //����������
            conn=DriverManager.getConnection("jdbc:sqlserver://"+ServerName+"; DatabaseName="+DataBaseName,UserName,UserPassword);
            //����Statement����
            stm=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        }
        catch(Exception ex)
        {

        }
    }
    public SQLHelper(String tmp)
    {
        try
        {
            //������������
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            //����������
            conn=DriverManager.getConnection("jdbc:odbc:"+DSN,UserName,UserPassword);
            //����Statement����
            stm=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        }
        catch(Exception ex)
        {

        }
    }
    public long Update(String SQL)
    {
        try
        {
            return stm.executeUpdate(SQL);
        }
        catch(Exception ex)
        {
            return -1;
        }
    }
    public ResultSet Query(String SQL)
    {
        try
        {
            return stm.executeQuery(SQL);
        }
        catch(Exception ex)
        {
            return null;
        }
    }
    public void Close()
    {
        try
        {
            stm.close();
            conn.close();
        }
        catch(Exception ex)
        {

        }
        finally
        {
            stm=null;
            conn=null;
        }
    }
}