public class ProduceDao {
public static void select_nofilter() throws SQLException {
// 1.获得连接
Connection conn = DBUtil.getConnection();
// 2.获得CallableStatement
CallableStatement cs = conn.prepareCall("call sp_select_nofilter() ");
// 3.执行存储过程
cs.execute();
// 4.处理返回结果:结果集,出参
ResultSet rs = cs.getResultSet();
while (rs.next()) {
System.out.println(" 姓名:"+rs.getString("user_name")+
" 邮箱:"+ rs.getString("email") +" 电话:"+ rs.getString("mobile"));
}
}
public class TestProduce {
public static void main(String[] args) throws SQLException {
ProduceDao pd=new ProduceDao();
pd.select_nofilter();
}
}