一个JDBC的小例子

最新推荐文章于 2025-08-16 09:37:50 发布

imnol

最新推荐文章于 2025-08-16 09:37:50 发布

阅读量787

点赞数

CC 4.0 BY-SA版权

分类专栏： JDBC 文章标签： jdbc null import oracle string class

本文链接：https://blog.youkuaiyun.com/imnol/article/details/1732061

JDBC 专栏收录该内容

1 篇文章

订阅专栏

import java.sql.*;

public class TestJDBC {

    public static void main(String[] args) {
        ResultSet rs = null;
        Statement stmt = null;
        Connection conn = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            //new oracle.jdbc.driver.OracleDriver();
            conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:WWW", "scott", "tiger");
            stmt = conn.createStatement();
            rs = stmt.executeQuery("select * from dept");
            while(rs.next()) {
                System.out.println(rs.getString("deptno"));
                System.out.println(rs.getInt("deptno"));
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if(rs != null) {
                    rs.close();
                    rs = null;
                }
                if(stmt != null) {
                    stmt.close();
                    stmt = null;
                }
                if(conn != null) {
                    conn.close();
                    conn = null;
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

}