Question

java连接sqlserver太慢！DriverManager.getConnection

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
String time1 = dateFormat.format(new Date());

cnn=DriverManager.getConnection("jdbc:odbc:sqlserver","sa","123456");//这句代码运行时间很长！大概5秒左右
String time2 = dateFormat.format(new Date());
请问什么原因导致？怎么解决

Answer 1

cnn=DriverManager.getConnection("jdbc:odbc:sqlserver","sa","123456");把这句话放在静态块中
例如：
public class a{
static {
cnn=DriverManager.getConnection("jdbc:odbc:sqlserver","sa","123456");
}
public void b(){
..................
}

}