建立连接和创建Statement都是成功的,但查询表时返会的记录是0,而表中是有一条记录的。代码如下:
//初始化sqlsever 优化数据库
Connection yh_conn, pbos_conn;
Statement yh_stmt, pbos_stmt;
String yh_url="jdbc:microsoft:sqlserver://192.168.1.101:1433;DatabaseName=WJ30YH";                 
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");  
yh_conn = DriverManager.getConnection 
  (yh_url,"nari","nari"); 
yh_stmt = yh_conn.createStatement();
ResultSet rs = yh_stmt.executeQuery("SELECT * FROM AIN_REAL1" );
System.out.println("row num = " + rs.getRow());
//System.out.println("datetime = " + rs.getDate("TIME"));

java.sql.DatabaseMetaData dm = null;
dm = yh_conn.getMetaData();
            System.out.println("Driver Information");
            System.out.println("\tDriver Name: "+ dm.getDriverName());
            System.out.println("\tDriver Version: "+ dm.getDriverVersion ());
            System.out.println("\nDatabase Information ");
            System.out.println("\tDatabase Name: "+ dm.getDatabaseProductName());
            System.out.println("\tDatabase Version: "+ dm.getDatabaseProductVersion());
            System.out.println("Avalilable Catalogs ");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
LogFunc.print("加载sqlserver驱动程序类com.microsoft.jdbc.sqlserver.SQLServerDriver不成功");
return;
}
catch(SQLException e)
{
e.printStackTrace();
LogFunc.print("建立到"+ConfigFile.getDbName("YH")+"数据库的连接不成功");
return;
}