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

核心提示：//out.println("<p>"+entry.getKey()+":"+request.getParameter((String)entry.getKey())+"</p>");conn=DriverManager.getConn

//out.println("<p>"+entry.getKey()+":"+request.getParameter((String)entry.getKey())+"</p>");
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();
out.println("<p>保存问卷"+question_id+": 多选题"+str[1]+"成功！"+"</p>");
}catch(SQLException e){
e.printStackTrace();
}
}else if(((String)entry.getKey()).matches("te_[0-99]_[0-99]")){
try{
String te= request.getParameter((String)entry.getKey());
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]
+"','"+te
+"')";
stmt=conn.createStatement();
stmt.execute(sql);
stmt.close(); //关闭连接、释放资源
conn.close();
out.println("<p>保存问卷"+question_id+": 问答题"+str[1]+"成功！"+"</p>");
}catch(SQLException e){
e.printStackTrace();
}
}
}

}else{
out.println("<p>保存失败，没有输入用户名</p>");
}
%>
</body>
</html>