菜鸟求助！将arraylist中的查询结果插入数据库该怎么做啊
从来没有接触过代码，上来就让弄这个，实在没头绪，关键是时间紧，请帮忙了！！！
有一个查询结果列表的jsp页面
<%@ page contentType= "text/html;charset=GBK " %>
<%@ page import= "java.util.* "%>
<%@ page import= "web.vrlab.gsmis.action.xj.pages.Xjpages "%>
<%@ taglib uri= "/WEB-INF/struts-bean.tld " prefix= "bean " %>
<%@ taglib uri= "/WEB-INF/struts-html.tld " prefix= "html " %>
<%@ taglib uri= "/WEB-INF/struts-logic.tld " prefix= "logic " %>
<%
String ctxPath = request.getContextPath();
String nowSesson = (String)request.getSession().getAttribute( "zcSesson ");
nowSesson = nowSesson.equals( "spring ")? "春 ": "秋 ";
String nowYear = (String)request.getSession().getAttribute( "zcYear ");
String submitType = (String)request.getSession().getAttribute( "zcSubmitType ");
%>
<link href= " <%=ctxPath%> /css/phonenix.css " rel= "stylesheet " type= "text/css ">
<script language= 'javascript ' src= ' <%=ctxPath%> /js/dm/DM_XB.js '> </script>
<script language= 'javascript ' src= ' <%=ctxPath%> /js/dm/DM_BXZY.js '> </script>
<script language= 'javascript ' src= ' <%=ctxPath%> /js/dm/DM_YXDM.js '> </script>
<script language= 'javascript ' src= ' <%=ctxPath%> /js/dm/DM_ZCXX.js '> </script>
<script language= "javascript ">
function get_dm_value(v,def_dm)
{
var str = '未知 ';
for (var x in def_dm)
{
if(v == x)
{
str = def_dm[x];
return str;
}
}
return str;
}
</script>
<%@ page session= "true "%>
<table>
<tr class= "tablefont3 " bgcolor= "#6699CC ">
<td colspan= '4 '>
学生注册情况 学生列表
</td>
</tr>
<%
int flag=-1;
ArrayList SList = (ArrayList)request.getAttribute( "studentList ");
if(SList!= null)
{
String rowIndex= " ";
for(int i=0; i <SList.size(); i++)
{
flag=-flag;
if(flag <0)
{
out.print( " <tr bgcolor= '#eaffe0 ' class= 'tablefont1 '> ");
}
else
{
out.print( " <tr bgcolor= '#eaeeff 'class= 'tablefont1 '> ");
}
String sInf[] = (String[])SList.get(i);
rowIndex = (sInf[9]!=null) ? sInf[9]: " "+(i+1)+ " ";
out.print( " <td> <font color= 'red '> "+ rowIndex + " </font> </td> ");
out.print( " <td> "+ sInf[0] + " </td> ");
out.print( " <td> <a href= 'javascript:getStuDetail(\ " "+sInf[0]+ "\ ") '> "+ sInf[1] + " </a> </td> ");
out.print( " <td> <script language= 'javascript '> document.write(get_dm_value( ' "+sInf[5]+ " ',DM_ZCXX)); </script> </td> ");
out.print( " </tr> ");
}
}
%>
</table>
<br>
<script language= "javascript ">
function getStuDetail(xh)
{
parent.frames[ "body "].location= " <%=ctxPath%> /toModule.do?prefix=/xj&page=/xjZcInfUpdatePage.do?zc_xsxh= "+xh;
}
</script>
现在想在下面加一个按钮，把这些查询出来的学生一人一条记录的全都插到数据库中，该怎么做呢？请大家一定帮忙，谢谢了
[解决办法]
SomeElement e = list.get(i);
insert into table1 values(e.value1,e.value2...)
[解决办法]
String sInf[] = (String[])SList.get(i);
insert into yourtab(item1,item2,....)values(sInf[0],sInf[1],......)
根据你的代码理解,这个sInf就是一条记录.循环SList拼成sql,然后数据库连接,插入.关闭.
[解决办法]
if(flg> 0)将你选的记录拼成以特殊符号间隔的字符串，或是数组，调用.do，在.do中链接数据库，将你传入的参数进行解析，拼装成动态的sql进行数据插入就可以了