数据库连接方法

1.MS SQL

public class DBConnection {
 
 public  Connection conn = null;
 public ResultSet   rs = null;
 public Statement   st = null;
 public String  url ="jdbc:sqlserver://192.168.1.6:1433;DatabaseName=***";
 public String  Driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
 public String  user = "sa";
 public String  pwd = "sa";
 
 public Connection  getConnection()
 {
  try{
  Class.forName(Driver).newInstance();
  System.out.print("OK");
  return conn = DriverManager.getConnection(url,user,pwd);
  }catch(Exception e)
  {
   e.printStackTrace();
  }
  
  return conn;
  
 }

}