不方便的话,可以用odbc-jdbc啊.
public class text
{
public static void main (String [] args)
{
String url
= "jdbc:odbc:SRS"; String username = "sa";
String password = "";
try
{
Class.forName
( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection con = DriverManager.getConnection
(url,username,password); Statement stmt = con.createStatement();
String command = "insert into teacher "+
"values ('00000001','xgx','male','CS')";
stmt.executeUpdate(command);
}
catch (Exception ex)
{
System.out.println("error!!");
System.out.println(ex.getMessage());
}
}}
public class text
{
public static void main (String [] args)
{
String url
= "jdbc:odbc:SRS"; String username = "sa";
String password = "";
try
{
Class.forName
( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection con = DriverManager.getConnection
(url,username,password); Statement stmt = con.createStatement();
String command = "insert into teacher "+
"values ('00000001','xgx','male','CS')";
stmt.executeUpdate(command);
}
catch (Exception ex)
{
System.out.println("error!!");
System.out.println(ex.getMessage());
}
}}
我按上诉方法试了一下,还是不行,不过这次的异常信息和之前的不一样了,
是“[Microsoft][ODBC]”
(刚刚还没打完就不小心发出去了)
换成
String url = "jdbc:microsoft:sqlserver://172.16.6.194:1433;databasename=SRS";
试试,SRS是你创建的数据库名
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd );
已经搞定了
问题就在ODBC里DSN和databasename=SRS
但是我还有一个问题:为什么用用户DNS可以,而用系统的DNS反而不行呢?
我用ODBC中的用户DNS已经连上了
只是我不知道为什么改用ODBC中的系统DNS反而连不上