JDBC六部曲

 public static void main(String []args) {
        Connection con = null;
        Statement sta = null;
        ResultSet rs = null;
        try {
            //注册驱动
            //Class.forName("com.mysql.jdbc.Driver");
            Driver d = new com.mysql.jdbc.Driver();
            DriverManager.registerDriver(d);
            //获取数据库连接
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test1","root","xucanjie");
            //获取数据库操作对象
            sta = con.createStatement();
            //执行SQL语句
            String sql = "select e.ename,e.sal,d.dname from emp e join dept d on e.deptno=d.deptno";
            rs=sta.executeQuery(sql);
            //处理查询结果集
            while(rs.next()) {
                System.out.println("员工姓名:" + rs.getString("ename") + " 员工部门：" + rs.getString("dname") + " 员工工资：" + rs.getInt("sal"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        finally {
            if(rs!=null){
                try {
                    rs.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }
            if(sta!=null){
                try {
                    sta.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }
            if(con!=null){
                try {
                    con.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }
        }

Connection con = null;
        //Statement sta = null;
        PreparedStatement psta = null;
        ResultSet rs = null;
        try {
            //注册驱动的两种方式
            //Class.forName("com.mysql.jdbc.Driver");
            Driver d = new com.mysql.jdbc.Driver();
            DriverManager.registerDriver(d);
            //获取数据库连接
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test1","root","xucanjie");
            //获取数据库操作对象,预编译
            String sql = "select e.ename,e.sal,d.dname from emp e join dept d on e.deptno=d.deptno where sal>?";
            psta = con.prepareStatement(sql);
            psta.setInt(1,2500);
            //执行SQL语句
            rs=psta.executeQuery();
            //处理查询结果集
            while(rs.next()) {
                System.out.println("员工姓名:" + rs.getString("ename") + " 员工部门：" + rs.getString("dname") + " 员工工资：" + rs.getInt("sal"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        finally {
            //关闭
            if(rs!=null){
                try {
                    rs.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }
            if(psta!=null){
                try {
                    psta.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }
            if(con!=null){
                try {
                    con.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }
        }
    }