JDBC链接Oracle数据库的6个步骤

来源：互联网发布：药品网络经营许可证编辑：程序博客网时间：2024/05/16 04:03

public class JDBC {    public static void main(String[] args) {        //1.注册驱动器        Class.forName(oracle.jdbc.driver.OracleDriver);        //2.得到Connection        Connection conn = DriverManager.getConnection();        try {            //3.创建Statement            Statement stmt = conn.createStatement();            //4.得到结果集            ResultSet rs = stmt.executeQuery("Select * from t_student");            //5.对结果集进行处理(例如遍历t_student表中的sname字段)            while(rs.next()) {                System.out.println(rs.getString("sname"));            }        catch(SQLException e) {            e.printStackTrace();        }        //6.资源释放        if(rs != null) {            try {                rs.close();                rs = null;            } catch(SQLException e) {                e.printStackTrace();            }        }        if(stmt != null) {            try {                stmt.close();                stmt = null;            } catch(SQLException e) {                e.printStackTrace();            }        }        if(conn != null) {            try {                conn.close();                conn = null;            } catch(SQLException e) {                e.printStackTrace();            }        }    }}

0 0