How to databind a checkbox list in JSP and insert multiple data to DB?

<%  
String sql = "SELECT id, cook FROM cook";
ResultSet rs = s.executeQuery(sql);
%>
<% while (rs.next()) {%>
<input TYPE=checkbox NAME="cook" VALUE="<%=rs.getString("cook")%>"><%=rs.getString("cook")%><BR>
<%}%>
<%
rs.close();
s.close();
con.close();
%>	

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:

upd = "update cooking set cook";
upd = upd + "='"+Cook+"'";
upd = upd + " where cookingid = '" + ID +"';";

                                              

1:
2:
3:

<%  
String sql = "SELECT s.id as id, s.cook as cook, m.cooking as e FROM cook s join member m";
ResultSet rs = s.executeQuery(sql);
%>
<% while (rs.next()) {%>
String [] arr = rs.getString("e").split("\\,");
<input TYPE=checkbox NAME="cooking" VALUE="<%=rs.getInt("id")%>" <%if(rs.getInt("id")==Integer.parseInt("arr[]")){out.print("selected");}%>><%=rs.getString("cook")%><BR>
<%}%>
<%
rs.close();
s.close();
con.close();
%>	

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:

<%  
String sql = "SELECT s.id as id, s.cook as cook, m.cooking as e FROM cook s join member m";
ResultSet rs = s.executeQuery(sql);
%>
<% while (rs.next()) {
if(rs.getString("e") != null)
{
String arr[]= new String [rs.getString("e").split("\\,").length];
for(int i=0;i<arr.length;i++)
{
arr = rs.getString("e").split("\\,");
%>
<input TYPE=checkbox NAME="cook" VALUE="<%=rs.getInt("id")%>" <%if(rs.getInt("id")==Integer.parseInt(arr[i])){out.print("checked");}%>><%=rs.getString("cooking")%><BR>
<%
}}
else
{%>
<input TYPE=checkbox NAME="cook" VALUE="<%=rs.getInt("id")%>"><%=rs.getString("cooking")%><BR>
<%}
}%>

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:

Cooking.jsp
<%
int myID = 1;
MySQLConnector db = new MySQLConnector();
Connection con = db.Getcon();
Statement s = con.createStatement();
%>
<form name="cookingjsp" action="cooking" method="post">
Cooking:<br>    	
<%  
String sql = "SELECT s.id as id, s.cook as cook FROM cook s";
ResultSet rs = s.executeQuery(sql);
String sql1 = "SELECT m.cooking as e FROM member m where m.id=" + myID;
ResultSet rs1 = s.executeQuery(sql1);
while (rs1.next()) {
String arr[]= new String [rs.getString("e").split("\\,").length];
}
%>
<% while (rs.next()) {
if(rs.getString("e") != null)
{
for(int i=0;i<arr.length;i++) //arr cannot be resolved here
{
arr = rs.getString("e").split("\\,"); //arr cannot be resolved here
%>
<input TYPE=checkbox NAME="cook" VALUE="<%=rs.getInt("id")%>" <%if(rs.getInt("id")==Integer.parseInt(arr[i])){out.print("checked");}%>><%=rs.getString("cook")%><BR>
<%
}
}
else
{%>
<input TYPE=checkbox NAME="cook" VALUE="<%=rs.getInt("id")%>"><%=rs.getString("cook")%><BR>
<%}
}%>
 
<%
rs.close();
s.close();
con.close();
%>	
<input type="submit" name="Submit" value="Cooking" >
</form>
 
Cooking.java
public class Cooking extends HttpServlet {
	  private static final String CONTENT_TYPE = "text/html; charset=utf-8";
	  private int myID;
	  private String []inCook;
	  private String cookappend="";
	  //Initialize global variables
	  public void init() throws ServletException {
	  }
	  //Process the HTTP Get request
	  public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		HttpSession session = request.getSession(true);
		myID = 1;
		inCook = request.getParameterValues("cook");		
		for(int i=0; i<inCook.length;i++)
		{
		  cookappend += inCook[i]+",";
		}
	    try{
	      save();
	    }
	    catch (Exception e){
	    }
	  }
	  //Process the HTTP Post request
	  public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	    doGet(request, response);	    
	  }
	  //Process the HTTP Put request
	  public void doPut(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	  }
	  //Process the HTTP Delete request
	  public void doDelete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	  }
	  //Clean up resources
	  public void destroy() {
	  }
 
	  public void save() throws CookException
	  {
	    MySQLConnector db = new MySQLConnector();
	    Connection con = db.Getcon();
	    String upd;
	    int isWrite;
	    Statement stmt=null;
	    upd = "update member set cooking";
	    upd = upd + "='"+cookappend+"'";
	    upd = upd + " where id = '" + myID +"';";
        try
	    {
	      stmt = con.createStatement();
	      isWrite = stmt.executeUpdate(upd);
	      if (isWrite!=1)
	      {
	        System.out.print("Cannot insert to DB");
	      }
	    }
	    catch(Exception e){
	      e.printStackTrace();
	    }
	    finally
	    {
	        try {
	          if(stmt!=null)
	          stmt.close();
	          con.close();
	          }
	        catch (Exception e) {
	          throw new CookException("Cook error");
	          }
	    }
	  }  
	}

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116: