67,512
社区成员
发帖
与我相关
我的任务
分享
<form action="/NMSoftware/attendanceregister.do?method=addAttendancereGister" method="post">
for(int i=0;i<10;i++){
<input type="text" name="ID" value="<%=i%>">
<input type="text" name="AR_Notes" value="<%=i%>">
}
<input type="submit">
</form>
public ActionForward addAttendancereGister(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) throws IOException {
response.setCharacterEncoding("gb2312");
response.setContentType("text/html");
String ID[] = request.getParameterValues("ID");//因为不是一个值所以我用数组取过来了
String AR_Notes[] =request.getParameterValues("AR_Notes");
然后我想用 这条插入语句把取过来的ID和AR_Notes的信息都插入到ZC_Attendanceregister这个表里面
String sql ="insert ZC_Attendanceregister select 'ID','AR_Notes' union all select 'ID','AR_Notes'";
}
String sql = "insert into ZC_Attendanceregister values(?,?,?,?,?,?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
for(i...){
pstmt.setInt(2, ID[i]);//这句有错误类型的问题。
}
String ID[] = request.getParameterValues("ID");
pstmt.setInt(2, ID[io]);//The method setInt(int, int) in the type PreparedStatement is not applicable for the arguments (int,
String)