jdbc 连接

public class Test {

public static void main(String[] args) {

try { ​ //1.加载驱动类 ​ Class.forName("oracle.jdbc.driver.OracleDriver"); ​ //2.获取其数据库连接对象 ​ Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "jsd2107", "jsd2107"); ​ //3.获取数据库sql操作对象 ​ PreparedStatement pst = con.prepareStatement("select * from student where id <=20 order by id"); ​ //4.执行sql操作，获取执行结果集 ​ ResultSet rs = pst.executeQuery(); ​ //5.处理结果集，逐行读取记录数 ​ while(rs.next()){//判断结果集中是否有下一行数据，有的话返回true，否则返回false ​ //数据库类型和java类型对比 ​ /**数据库 java ​ * number java.long.Integer ​ * varchar2 java.long.string ​ * date java.sql.Date ​ * timestamp java.sql.Timestamp ​ */ ​ System.out.println("编号："+rs.getInt("id")+ ​ "姓名："+rs.getString("name")+ ​ "生日："+rs.getDate("birthday")+ ​ "创建时间："+rs.getTimestamp("create_time")); ​ } ​ //6.关闭结果集对象 ​ rs.close(); ​ //7.关闭sql操作对象 ​ pst.close(); ​ //8.关闭数据库连接 ​ con.close(); ​ } catch (ClassNotFoundException e) { ​ e.printStackTrace(); ​ } catch (SQLException throwables) { ​ throwables.printStackTrace(); ​ } }