用jsp将xml文件解析到网页显示，并把数据提交保存到数据库(7)

           conn=DriverManager.getConnection(url);
      //创建执行语句 
     String sql="insert into question(question_id,username,q_id,q_type,qanswer)"
      +" values('"+question_id
      +"','"+username
      +"','"+str[1]
      +"','"+str[2]
      +"','"+sing
      +"')";    
     stmt=conn.createStatement();
     stmt.execute(sql);    
     stmt.close(); //关闭连接、释放资源
     conn.close();
     out.println("<p>保存问卷"+question_id+": 单选题"+str[1]+"成功！"+"</p>");
     }catch(SQLException e){
       e.printStackTrace();
     }
         }else if(((String)entry.getKey()).matches("che_[0-99]_[0-99]")){
          try{
           String[]  ches= request.getParameterValues((String)entry.getKey());
           String cheanswer="";
           for(int i=0;i<ches.length;i++){
            cheanswer+=ches[i]+" ";
           }
           String[] str=((String)entry.getKey()).split("_");
           conn=DriverManager.getConnection(url);
      //创建执行语句 
     String sql="insert into question(question_id,username,q_id,q_type,qanswer)"
      +" values('"+question_id
      +"','"+username
      +"','"+str[1]
      +"','"+str[2]
      +"','"+cheanswer
      +"')";    
     stmt=conn.createStatement();
     stmt.execute(sql);    
     stmt.close(); //关闭连接、释放资源
     conn.close();