java中sql之count,Java / SQL - Count(*) 的用法

試下:

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class CountRecordsUsingPreparedStatement {

public static Connection getConnection() throws Exception {

String driver = "oracle.jdbc.driver.OracleDriver";

String url = "jdbc:oracle:thin:@localhost:1521:databaseName";

String username = "name";

String password = "password";

Class.forName(driver);

Connection conn = DriverManager.getConnection(url, username, password);

return conn;

}

public static void main(String[] args) {

ResultSet rs = null;

Connection conn = null;

PreparedStatement pstmt = null;

try {

conn = getConnection();

String query = "select count(*) from tableName";

pstmt = conn.prepareStatement(query);

rs = pstmt.executeQuery();

if (rs.next()) {

int numberOfRows = rs.getInt(1);

System.out.println("numberOfRows= " + numberOfRows);

} else {

System.out.println("error: could not get the record counts");

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

rs.close();

pstmt.close();

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

2006-12-21 01:29:04 補充：

基本上係1. select count(*) from tableName2. pstmt = conn.prepareStatement(query);3. rs = pstmt.executeQuery();4. int numberOfRows = rs.getInt(1);因為count(*)既result 已store 係 result set 既第一個位~