<%//连接数据库
Connection con=null;
try
{
con=DBConnection.getConnection();
Statement stmt=con.createStatement();
//循环拆分rec取出r_name
while(rec.indexOf(",")>0){
String str=rec.substring(0,rec.indexOf(","));
rec=rec.substring(rec.indexOf(",")+1);
stmt.execute("insert into message(r_name,s_name,s_title,s_message,s_date,status) Values('"+str+"','"+sender+"','"+title+"','"+message+"','"+strDate+"','0')");
}
stmt.execute("insert into message(r_name,s_name,s_title,s_message,s_date,status) Values('"+rec+"','"+sender+"','"+title+"','"+message+"','"+strDate+"','0')");
response.sendRedirect("succeed.jsp");
%>
<%
stmt.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>
Connection con=null;
try
{
con=DBConnection.getConnection();
Statement stmt=con.createStatement();
//循环拆分rec取出r_name
while(rec.indexOf(",")>0){
String str=rec.substring(0,rec.indexOf(","));
rec=rec.substring(rec.indexOf(",")+1);
stmt.execute("insert into message(r_name,s_name,s_title,s_message,s_date,status) Values('"+str+"','"+sender+"','"+title+"','"+message+"','"+strDate+"','0')");
}
stmt.execute("insert into message(r_name,s_name,s_title,s_message,s_date,status) Values('"+rec+"','"+sender+"','"+title+"','"+message+"','"+strDate+"','0')");
response.sendRedirect("succeed.jsp");
%>
<%
stmt.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>