java连接数据库(查询语句)

package com.company;

import java.sql.*;

public class Main {

    public static void main(String[] args) throws ClassNotFoundException, SQLException
    {
        // write your code here
        //1.加载oracle驱动
        Class.forName("oracle.jdbc.driver.OracleDriver");
        //2.创建数据库连接字符串
        String strUrl = "jdbc:oracle:thin:@localhost:1521:orcl";
        //3.建立于oracle服务器的连接
        Connection con = DriverManager.getConnection(strUrl, "scott", "z138168");
        //4.写一个sql查询语句
        String strSql = "select * from my_userinfo where userid = ? and username = ?";
        //5.准备PreparedStatement--查询窗口，把sql语句放到查询窗口中执行
        PreparedStatement ps = con.prepareStatement(strSql);
        ps.setInt(1,1);
        ps.setString(2,"admin");
        //6.处理结果集ResultSet
        ResultSet rs = ps.executeQuery();
        while(rs.next())
        {
            String strName = rs.getString("username");
            Date d = rs.getDate("birthday");
            System.out.println(strName+":"+d);
        }
        //7.清理资源
        rs.close();
        ps.close();
        con.close();
    }
}