public static void main(String[] args) {
Connection con = new DBconn().getConn();
try {
CallableStatement cs =con.prepareCall("{call lsq.pro_userinfo(?,?)}");
cs.setString(1, date);
cs..setString(2, name);
cs.execute();
} catch (SQLException e2) {
e2.printStackTrace();
}finally{
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}