Question

jsp向数据库中插入数组的语句怎么写

表格
</p>
<tr><td>项目名称</td><td>内容</td><td>分值</td></tr>
<tr>

<td><input type="text" name="item/"></td>

<td><input type="text" name="detail"/></td>

<td><input type="text" name="score"/></td>
</tr>
<tr>

<td><input type="text" name="item/"></td>

<td><input type="text" name="detail"/></td>

<td><input type="text" name="score"/></td>
</tr>
<tr>

<td><input type="text" name="item/"></td>

<td><input type="text" name="detail"/></td>

<td><input type="text" name="score"/></td>
</tr>

</table>
<input type="submit" name="Submit" value="提交" />
提交到另一个页面post
然后进行插入数据库动作
String dep=request.getParameter("ks");
String type=request.getParameter("ducha");
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
String url = "jdbc:sqlserver://localhost:1433; DatebaseName=sd";

String user = "sa";
String password = "abc123";

Connection conn = DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
String item[]=request.getParameterValues("item");
String detail[]=request.getParameterValues("detail");
String score[]=request.getParameterValues("score");
for(int i=0;i<item.length;i++)
{
String sql="insert into dcb(item,detail,score)values('"+item+"','"+detail+"','"+score+"')";
stmt.executeUpdate(sql);
}
这句sql语句应该怎么写？我这样写貌似是错误，请大侠帮忙

Answer 1

String sql="insert into dcb(item,detail,score)values('"+item[i]+"','"+detail[i]+"','"+score[i]+"')";