网站添加微信分享代码,超级优化液,旅游网站的设计方案怎么做,wordpress下载失败JDBC练习五
/*执行DQL语句
*/import java.sql.*;
import java.util.*;public class JDBCTest05 {public static void main(String[] args) {// 1、注册驱动// 2、建立连接// 3、获取数据库操作对象// 4、执行sql语句// 5、获取查询结果集// 6、释放资源Connection conn null;…JDBC练习五
/*执行DQL语句
*/import java.sql.*;
import java.util.*;public class JDBCTest05 {public static void main(String[] args) {// 1、注册驱动// 2、建立连接// 3、获取数据库操作对象// 4、执行sql语句// 5、获取查询结果集// 6、释放资源Connection conn null;Statement stmt null;ResultSet rs null;try{ResourceBundle rb ResourceBundle.getBundle(jdbc);String driver rb.getString(driver);String url rb.getString(url);String user rb.getString(user);String password rb.getString(password);Class.forName(driver);conn DriverManager.getConnection(url,user,password);stmt conn.createStatement();rs stmt.executeQuery(select * from student);while(rs.next()){/*String studentid rs.getString(1);String studentname rs.getString(2);System.out.println(studentid , studentname);*//*// 按下标取出程序不健壮String studentid rs.getString(studentid);String studentname rs.getString(studentname);System.out.println(studentid , studentname);*//*// 以指定的格式取出int studentid rs.getInt(1);String studentname rs.getString(2);System.out.println(studentid , studentname);*/int studentid rs.getInt(studentid);String studentname rs.getString(studentname);System.out.println(studentid , studentname);}} catch(Exception e){e.printStackTrace();}finally{if(rs ! null){try{rs.close();} catch (Exception e){e.printStackTrace();}}if(stmt ! null){try{stmt.close();} catch (Exception e){e.printStackTrace();}}if(conn ! null){try{conn.close();} catch (Exception e){e.printStackTrace();}}}}
}运行结果:
