JAVA存储过程详解

try{   
          con   =   DriverManager.getConnection(url,"huangqiang","tidesoft");   
                    
                          CallableStatement   cs   =   con.prepareCall("{call   huangqiang.C_TESTSQL_PROC(?,?,?,?,?)}");   
                                          cs.setString(1,"1");   
                                          cs.setString(2,"2");   
                                          cs.setString(3,"j");   
                                          cs.setString(4,"3");   
                                          cs.registerOutParameter(5,Types.VARCHAR);   
                                          result=cs.executeQuery();   
      String   sql=cs.getString(5);   
      System.out.println("sql::::"+sql);   
    
  while   (result.next()){   
  String   id=result.getString(1);   
  String   fname=   result.getString(2);   
  String   lname=   result.getString(3);   
  System.out.println(id+"-----"+fname+"---"+lname);   
  }   
            
          
          cs.close();   
          con.close();   
  }catch(SQLException   ex){   
  System.err.println("SQLException:   "   +   ex.getMessage());   
  

我来跟yuchenjushi同学讨论吧.   
  你这个问题我斟酌了一下,觉得有两个地方是关键.   
  首先,存储过程是怎么写的,怎么用的你要明白.为了解决这个问题,我在本机操作了一下.   
  环境sqlserver2000.   
  1.建表   
  create   table   tonyProducts(   
  mingcheng   varchar(20),   
  xinghao   varchar(10),   
  guige   varchar(10),   
  miaoshu   varchar(20),   
  pici   varchar(4),   
  qichu   varchar(2),   
  yixiajia   varchar(2),   
  zhuangtai   varchar(10),   
  danwei   varchar(4),   
  weizhi   varchar(3)   
  )   
  2.插数据   
  insert   into   tonyProducts   values('chocolate','PNP9000199','24G×10','f1','2006','10','16','in','pack','c1')   
  insert   into   tonyProducts   values('icecream','PNP9000198','24G×20','f2','2005','20','26','out','box','c2')   
  insert   into   tonyProducts   values('melon','PNP9000197','24G×30','f3','2004','30','36','way','bund','c3')   
  insert   into   tonyProducts   values('sugar','PNP9000196','24G×40','f4','2003','40','46','crupt','bott','c4')