day33-4用java的jdbc查看数据库中表的内容

package zuoye;

import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class text3 {
    public static void main(String[] args) {
        Connection conn =null;
        PreparedStatement pre =null;
        ResultSet re =null;
        try {
            conn = zuoye.getConnection();
            String s = "select *from emp";
            pre = conn.prepareStatement(s);
            re = pre.executeQuery(s);
            while(re.next()){
                int a = re.getInt("id");
                String a1 = re.getString("ename");
                int a2 = re.getInt("job_id");
                int a3 = re.getInt("mgr");
                Date a4 = re.getDate("joindate");
                BigDecimal a5 = re.getBigDecimal("salary");
                BigDecimal a6 = re.getBigDecimal("bonus");
                int a7 = re.getInt("dept_id");
                System.out.println(a+"  "+a1+"  "+a2+"  "+a3+" "+a4+" "+a5+" "+a6+" "+a7);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            zuoye.a(conn,pre,re);
        }

    }
}