首先连接数据库
public Connection connectDatabase(String className, String connectUrl, String username, String password)
{
try
{
/**
* 加载mysql数据库驱动
*/
Class.forName(className);
System.out.println("Success load Driver");
Connection connect = DriverManager.getConnection(connectUrl, username, password);
System.out.println("Success connect Mysql server!");
return connect;
}
catch (Exception e)
{
System.out.println("Error loading jdbc driver");
e.printStackTrace();
return null;
}
}
然后是重要的建立结果集,查询将结果摄入list中。
public List<Map<String, String>> getSelect(Connection conn, String query)
{
try
{
/**
* 连接数据,创建结果集
*/
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(query);
List<Map<String, String>> list = new ArrayList<Map<String, String>>();
Map<String, String> map = null;
/**
* 将查询结果集放进HashMap<Integer, StudentBean>, list添加封装好的map,
* 返回List
*/
while (rs.next())
{
map = new HashMap<String, String>();
map.put("studentId", rs.getString("sid"));
map.put("studentName",rs.getString("sname"));
map.put("classId",rs.getString("classId"));
map.put("className",rs.getString("sname"));
list.add(map);
}
return list;
}
catch (Exception e)
{
System.out.print("get data error!");
e.printStackTrace();
return null;
}
}
如何取出List的内容: