JAVA连接oracle数据库，并执行查询

1、 创建数据库test1，包含t_id、t_name
create table test1( t_id number,t_name varchar(20));

2、下载oracle的jdbc，官网下载
3、代码：

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class DBUtil {

    private static String user="xdd";
    private static String password="xdd";
    private static String url="jdbc:oracle:thin:@localhost:1521:orcl";

    public static Connection getConnnection(){
        Connection conn=null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            conn=DriverManager.getConnection(url, user, password);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return conn;
    }
    public static void main(String args[]){
        Connection conn=DBUtil.getConnnection();
        PreparedStatement psta=null;
        ResultSet rs=null;
        try {
            psta=conn.prepareStatement("select * from test1");
            rs=psta.executeQuery();
            while(rs.next()){
                int id=rs.getInt("t_id");
                String name=rs.getString("t_name");
                System.out.println("ID:"+id+","+"Name:"+name);
            }
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}

4、 结果：