mysql 查询问题-在线等待
import java.sql.*;
public class test {
static String sDBDriver = "org.gjt.mm.mysql.Driver";
static String sConnStr = "jdbc:mysql://localhost/test?user=root&password=";
static Connection conn = null;
static Statement stmt = null;
static ResultSet rs = null;
public static void main(String argv[]){
try{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM testtable");
// ResultSet set = t.executeQuery("SELECT * FROM shop_catalog");
System.out.print("");
}catch(Exception e){
}
}
}
程序能编译,
能连上数据库
但调试的时候返回rs结果集中currentRow=-1
表中有两行