java连接oracle快速入门

1.创建maven工程(略)

2.导入maven坐标

	<dependencies>
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc6</artifactId>
            <version>11.1.0.7.0</version>
        </dependency>
    </dependencies>

3.编写测试代码

public class OracleDemo {
    public static void main(String[] args) throws Exception {
        //加载数据库驱动
        Class.forName("oracle.jdbc.driver.OracleDriver");
        //得到Connection连接
        Connection connection= DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","tiger");
        System.out.println(connection);
        //得到预编译的Statement对象
        PreparedStatement pstm=connection.prepareStatement("select*from emp where empno=?");
        //给参数赋值
        pstm.setObject(1,7369);
        //执行数据库查询操作
        ResultSet rs =pstm.executeQuery();
        //输出结果
        while(rs.next()){
            System.out.println(rs.getString("ename"));
        }
        //释放资源
        rs.close();
        pstm.close();
        connection.close();
    }
}

4.测试结果

oracle.jdbc.driver.T4CConnection@63c12fb0
SMITH