//使用资源绑定器绑定属性配置 ResourceBundle bundle = ResourceBundle.getBundle("jdbc"); String driver = bundle.getString("driver"); String url = bundle.getString("url"); String user = bundle.getString("user"); String password = bundle.getString("password");
//执行sql String sql = "select empno,ename,sal from emp"; rs = stmt.executeQuery(sql);//专门执行DQL的方法 //处理查询结果集 while(rs.next()) {//光标指向的行有数据 //取数据 //JDBC中所有下标从1开始,不是从0开始 //健壮的写法,以字段名(重命名则用改名后的)获取 int empno = rs.getInt("empno"); String ename = rs.getString("ename"); Double sal = rs.getDouble("sal"); System.out.println(empno+","+ename+","+sal); }
原文:https://www.cnblogs.com/promise-ljy/p/11530894.html