constant.java~3~

插入文本文件到数据库中

package insertsqltextdemo.Constants;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.*;
public class Constant {
  private static String URL="jdbc:microsoft:sqlserver://localhost:1433:pubs";
  private static String USER="sa";
  private static String PASS="";
  private static String DriverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
  public static Connection getConnection()
  {
    Connection con = null;
    try {
      Class.forName(DriverName).newInstance();
      con = DriverManager.getConnection(URL, USER, PASS);
    }
    catch (SQLException ex) {
    }
    catch (ClassNotFoundException ex) {
    }
    catch (IllegalAccessException ex) {
    }
    catch (InstantiationException ex) {
    }
    return con;
  }
}