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);
           }