Java-结果集ResultSet如何取值

Question

ResultSet rs;
String sql_cq_total = "select count(*) from Title where TType = 1 "
rs= conn.executeQuery(sql_cq_total); 
rs.next();
int a = rs.getInt(1);//是不是这个地方出问题?本意想取得count(*)的值

Answer 1

楼主你的代码不对啊。。。 Connection有executeQuery()方法么？这种代码网上一搜一堆啦。

下面的实现我在mysql上测过了，没问题。

@Test
public void test13() throws Exception {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/test");
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery("select count(*) from Title where TType=1");
rs.next();
int x=rs.getInt(1);
System.out.println(x);
}