Question

java数据库中获得一列的值

Answer 1

Connection conn = DBConnection.getConnection();
PreparedStatement psmt = conn.prepareStatement("select id,title,addDate from test");
ResultSet rs = psmt.executeQuery();
while(rs.next()){
int id = rs.getInt(1);
String title = rs.getString(2);
Date addDate = rs.getDate(3);
}