SQLHelper

来源：互联网发布：泰牛程序员php视频编辑：程序博客网时间：2024/06/10 13:42
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;        }    }}
阅读全文
0 0