JDBC???д洢????????

???????????? ???????[ 2012/11/7 10:11:41 ] ????????

??????Java??????????????????????????洢???????????????洢???????????????????????????????????????

?????????????????????????????????????????洢????????????洢????????????????????????????????

????????????????????????????????????????洢?????????????????趨?磺

?????????????????????????в??????????

?????????????????

??????????????????????????????????????????洢??????????????洢????????????????????????е???????????磺

??????????Щ??????????????????????????????????????????????????????????????洢???????????

???????棬???????γ?????????????????????????Ч????

?????÷?????????????????????????洢?????????????洢?????????????????????????Ч????

publicvoid getProcedureOut(){
              con = DBCManager.getConnect();//??????????

              try {

                  //??????????con??prepareCall()??????? CallableStatement???? cs
               CallableStatement cs = con.prepareCall("{callmeOut(???????)}");

                  //?????????θ??

                  cs.setInt(1?? 1);
                  //????????????????????
                  cs.registerOutParameter(2?? Types.VARCHAR);
                  cs.registerOutParameter(3?? Types.INTEGER);
                  //??????
                  cs.execute();
                  //?????ε???????
                  System.out.print("name:"+cs.getString(2)+" age:"+cs.getInt(3));



              } catch (SQLException e) {
                  // TODO Auto-generatedcatch block
                  e.printStackTrace();
              }
              DBCManager.release(rs?? ps?? con);
           }

?????÷?????????????????????????洢?????????????洢?????????????????????е????????????????

publicvoid getProcedureIn(){
              con = DBCManager.getConnect();//??????????

              try {

                  //??????????con??prepareCall()??????? CallableStatement???? cs
                  CallableStatement cs = con.prepareCall("{call me(???????)}");

                  //?????????θ??

                  cs.setInt(1?? 7);
                  cs.setString(2?? "lang");
                  cs.setInt(3??30);
                  //???÷?????
                  boolean flag;
                  //??????
                   flag =cs.execute();

                   if(!flag){
                      System.out.print("????????");
                   }



              } catch (SQLException e) {
                  // TODO Auto-generatedcatch block
                  e.printStackTrace();
              }
              DBCManager.release(rs?? ps?? con);
           }