基础知识介绍:http://blog.csdn.net/xiehuan_uestc/article/details/7969321
返回值 | 方法 | 说明 |
ResultSet | executeQuery(String sql) | 主要用于执行有结果集返回的SQL语句,典型的就是select查询语句。 |
int | executeUpdate(String sql) | 主要用于执行没有结果集返回的SQL语句,如果要在数据库中添加、修改或删除信息,它们都没有返回值,应该使用本方法。该方法的返回值是一个整数,表示影响数据库中记录的个数。 |
//将ResultSet转化为List
public static List<Map<String, String>> resultSetToList(ResultSet rs) throws java.sql.SQLException {
if (rs == null)
System.out.println("rs is null -----");
ResultSetMetaData md = rs.getMetaData(); //得到结果集(rs)的结构信息,比如字段数、字段名等
int columnCount = md.getColumnCount(); //返回此 ResultSet 对象中的列数
List<Map<String, String>> list = new ArrayList<Map<String, String>>();
Map<String,String> rowData = new HashMap<String,String>();
while (rs.next()) {
rowData = new HashMap<String,String>(columnCount);
for (int i = 1; i <= columnCount; i++) {
rowData.put(md.getColumnName(i), rs.getString(i));
}
list.add(rowData);
//System.out.println("list:" + list.toString());
}
return list;
}
//将list打印出来
public static void selectMethod() throws SQLException{
String sql = "select * from front_log";
ResultSet rs = stmt.executeQuery(sql);
List<Map<String, String>> list = resultSetToList(rs);
Iterator it = list.iterator();
while(it.hasNext()){
Map<String, String> map = (Map<String, String>)it.next();
System.out.print(map.get("app")+" ");
System.out.print(map.get("ip")+" ");
System.out.print(map.get("level")+" ");
System.out.print(map.get("s_date")+" ");
System.out.print(map.get("s_time")+" ");
System.out.print(map.get("state")+" ");
System.out.print(map.get("info")+" ");
System.out.print(map.get("adds")+" ");
System.out.print(map.get("action")+" ");
System.out.println();
}
}