实现JDBC查询操作的testResultSet()

--我自己按照需求写出来的部分

@Test
public void testResultSet()
{
    Properties p = new Properties;
    InputStream in = getClass().getInstream().getInputAsStream();
    p.load(in);
    //获取id = 2 的customers 数据表的记录，并打印
    
    println();
    //1.获取Connection
    Connection conn = JDBCTools.getConnection();
    //2.获取Statement
    Statement st = conn.getConnection();
    //3.准备sql
    sql = "select * from customers where id =2 ";
    //4.准备查询，得到ResultSet
    ResultSet rs = st.executeQuery(sql);
    //5.处理ResultSet
    Int Date = rs.getInt(1);
    String Name = rs.getString(2);
    String email = rs.getString(3);
    String Birth = rs.getString(4);
    //6.关闭数据库资源
    rs.close();
    JDBCTools.release(st,conn);
}

 

 

--老师给出的范例

@Test
        public void testResultSet()
        { 
                //获取id = 2 的customers 数据表的记录，并打印
                Connection conn = null;
                Statement st = null;
                ResultSet rs = null;
                try{
                    //1.获取Connection
                    conn = JDBCTools.getConnection();
                    System.out.println(conn);
                    //2.获取Statement
                    st = conn.createStatement();
                    //3.准备sql
                    String sql = "select id,name,email,birth from customers";
                    //4.执行查询，得到ResultSet
                    rs = st.executeQuery(sql);
                    //5.处理ResultSet
                    while (rs.next())
                    {
                        int id = rs.getInt(1);
                        String name = rs.getString("name");
                        String email = rs.getString(3);
                        Date birth = rs.getDate(4);
                        System.out.println(id); 
                        System.out.println(name); 
                        System.out.println(email); 
                        System.out.println(birth); 
                    }
                    //6.关闭数据库资源
                    } catch (Exception e) {
                            e.printStackTrace();
                    } finally {
                        JDBCTools.release(rs,st, conn);
                    }
        }

 

 

--这样一比较，差距就出来了。类型定义，异常处理，结果输出都没有考虑到。