dbconn.java

来自「新闻发布系统」· Java 代码 · 共 30 行

package shen;
import java.sql.*;



public class DbConn {
    private Connection conn=null;
    private Statement st=null;
    private ResultSet re=null;
    public Connection getConn()
    {
        try {
           //   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
          //  ("jdbc:odbc:s1");  ("jdbc:microsoft:sqlserver://localhost:1433;databaseName=xinwen;","sa","sa");
            conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=xinwen;","sa","sa");
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
            /** @todo Handle this exception */
        }

        return conn;
    }

    public void close(){

    }

}