用ODBC看看
public void conn()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:rosen","administrator","");
}
catch (Exception e)
{
System.out.println(e);
}
}
public ResultSet setId(String a)
{
id=a;
ResultSet rs=null;
Statement stm;
try
{
String sql = "select count(*) from mytable";
stm = con.createStatement();
rs = stm.executeQuery(sql);
}
catch (Exception e)
{
System.out.println(e);
}
return rs;
}
public void conn()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:rosen","administrator","");
}
catch (Exception e)
{
System.out.println(e);
}
}
public ResultSet setId(String a)
{
id=a;
ResultSet rs=null;
Statement stm;
try
{
String sql = "select count(*) from mytable";
stm = con.createStatement();
rs = stm.executeQuery(sql);
}
catch (Exception e)
{
System.out.println(e);
}
return rs;
}
包括:msbase.jar mssqlserver.jar msutil.jar
String conn_str="jdbc:microsoft:sqlserver://localhost/news";
改成
String conn_str="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=news";