关于数据库中查找的方法实例

public List selectBook(String book_name){
try{
//将ResultSet 结果集存在List里面然后传递
List<String> list = new ArrayList<String>();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select * from book where book_name='"+book_name+"'";
rs = stmt.executeQuery(sql);
ResultSetMetaData rsm = rs.getMetaData();
int rowCount = rsm.getColumnCount();

if(rs.next()){
System.out.println(rs.getRow());
if(rs.getRow() != 0){
Map rowData = new HashMap();
for(int i=1; i<=rowCount; i++){
list.add(rs.getString(i));


}
System.out.println("Book select successful");


}
return list;
}

else{
System.out.println("Book select error");
return null;


}
}
catch(SQLException e){
e.printStackTrace();
return null;
}finally{
try{
if(rs != null){
rs.close();
rs = null;
}
if(stmt != null){
stmt.close();
stmt = null;
}
}
catch(SQLException e){
e.printStackTrace();
return null;
}
}
}