java jdbc链接oracle数据库(分6步详解),把结果放入到list中(代码演示)
//1.引入oracle驱动
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
//2.建立链接
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String user="user";
String password="123456";
Connection conn=DriverManager.getConnection(url,user,password);
//3.建立Statement对象
Statement stmt=conn.createStatement();
//4.执行sql语句:
String sql="select * from users";
ResultSet rs=stmt.executeQuery(sql);
//5.访问结果记录集ResultSet对象。
while(rs.next)
{
out.println("你的第一个字段内容为:"+rs.getString());
out.println("你的第二个字段内容为:"+rs.getString(2));
}
//6.依次将ResultSet、Statement、PreparedStatement、Connection对象关闭,释放所占用的资源:
rs.close();
stmt.clost();
conn.close();
public void oracleConnection(){ try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();//数据库驱动 String url ="jdbc:oracle:thin:@192.168.1.1:1521:dbname";//数据库链接地址 String user = "user";//用户名 String password = "123";//密码 Connection conn = DriverManager.getConnection(url, user, password);//建立connection Statement stmt = conn.createStatement(); String sql = "select name,age from users";//查询语句 ResultSet rs = stmt.executeQuery(sql);//得到结果集 Map<String, String> nsrsbhName = new HashMap<String, String>(); List<Map<String, String>> nsrsbhList=new ArrayList<Map<String, String>>();//创建取结果的列表,之所以使用列表,不用数组,因为现在还不知道结果有多少,不能确定数组长度,所有先用list接收,然后转为数组 while (rs.next()) {//如果有数据,取出后放到对应的map中 nsrsbhName.put(rs.getString(1), rs.getString(2)); //System.out.println(rs.getString(1)+" "+rs.getString(2)); } nsrsbhList.add(nsrsbhName); //将map内容放入到list中 for (Map<String, String> m : nsrsbhList) { for (String k : m.keySet()) { System.out.println(k + " " + m.get(k)); } } rs.close(); stmt.close(); conn.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } }
大家在说:
2016-06-26 11:56