public void con() //初始化
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:rosen1","administrator","");
stmt=conn.createStatement();
}
catch(Exception e)
{
System.out.println(e);
}
}
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:rosen1","administrator","");
stmt=conn.createStatement();
}
catch(Exception e)
{
System.out.println(e);
}
}
安装,然后把默认目录下的三个jar文件:msutil.jar,mssqlserver.jar,msbase.jar
拷贝到tomcat\common\lib目录下
再在classpath里加上这三个jar(指tomcat目录里的这三个jar)就ok了
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
稍改下: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
可获得JDBC驱动程序的完全列表,http://industry.java.sun.com/products/jdbc/drivers