JDBC规范

JDBC需要做到的代码规范

void fun () throw Exception {   //这三个对象要在finally中关闭，所以要定义在try块外面    Connection conn = NULL ;    Statement stmt = NULL ;    ResultSet rs = NULL ;     try{            Class.forName("com.mysql.jdbc.Driver");            String url = "jdbc:mysql://localhost:3306/数据库名";            String username = "root";            String password = "123456";            conn = DriverManager.getConnection(url , username , password);            stmt = conn.createStatement();            String sql = "select * where people";            rs = stmt.excuteQuery(sql);            while(rs.next()){              system.out.println(rs.getObject(1)+","+...);        }    }catch(Exception e){                throw new RuntimeException (e) ;        } finally{            //关闭要倒着来关闭                  try {                    if(rs != null) rs.close();                    if(stmt != null) stmt.close();                    if(con != null) con.close();                }             catch(SQLException e) {            }    }}