java连接SQLserver

三个驱动包：

                   msbase.jar

                   mssqlserver.jar

                   msutil.jar

装载驱动：

                Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

URL：

               url = "jdbc:microsoft:sqlserver://" + ip + ";" + "DatabaseName="+db ; 

 

获得连接：

                conn = DriverManager.getConnection(url,loginUser,loginPwd);

 

 

 

代码式例：

 

 

public class SQLServerDAOFactory extends DAOFactory{
 private static  String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
 
 private static String ip = "localhost:1433";

 private static String db = "tewman";

 private static String loginUser = "sa";

 private static String loginPwd = "sa";

 private static String url = "jdbc:microsoft:sqlserver://" + ip + ";" + "DatabaseName="+db ;
//采用JDBC方式连接
 public static Connection getConnection() {
  Connection conn = null;
  try {
   Class.forName(driverName);
   conn = DriverManager.getConnection(url,loginUser,loginPwd);
  } catch (SQLException e) {
   // TODO 自动生成 catch 块
   e.printStackTrace();
  } catch (ClassNotFoundException e) {
   // TODO 自动生成 catch 块
   e.printStackTrace();
  }

  return conn;

 }
 public static void closeResultSet(ResultSet rs) {
  if (rs != null) {
   try {
    rs.close();
   } catch (SQLException e) {
    // TODO 自动生成 catch 块
    e.printStackTrace();
   }
  }
 }

 public static void closeStatment(Statement st) {
  if (st != null) {
   try {
    st.close();
   } catch (SQLException e) {
    // TODO 自动生成 catch 块
    e.printStackTrace();
   }
  }
 }

 public static void closeConnection(Connection conn) {
  if (conn != null) {
   try {
    conn.close();
   } catch (SQLException e) {
    // TODO 自动生成 catch 块
    e.printStackTrace();
   }
  }
 }
 public static void main(String[] args) {
  SQLServerDAOFactory s = new SQLServerDAOFactory();
  Connection conn = s.getConnection();
  System.out.println(conn);
  try {
   PreparedStatement ps = conn.prepareStatement("select * from tblType_Style");
   ResultSet rs = ps.executeQuery();
   while(rs.next()){
    System.out.println(rs.getString(1));
    
   }
  } catch (SQLException e) {
   // TODO 自动生成 catch 块
   e.printStackTrace();
  }
 }

}