从有“，”分隔的字符串中取出被分隔的字符串并存储

<%//连接数据库
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();
}
%>