关于选课系统 怎么取值 然后插入数据库啊！纠结啊。。。。

wenhua.jsp
这是选课代码<%-- 
    Document   : test22
    Created on : 2011-11-19, 23:54:09
    Author     : me
--%><%@page import="java.sql.PreparedStatement"%>
<%@page contentType="textml" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="textml; charset=UTF-8">
        <title>体育课</title>
    </head>
    <body background="img/R6C.GIF">
        <form action="xkcg.jsp">
        <%
            java.sql.Connection conn = null;
            java.lang.String strConn;
            java.sql.PreparedStatement preparedStmt = null;
            java.sql.ResultSet sqlRst = null;
            PreparedStatement pstmt = null;
            try {
                Class.forName("com.mysql.jdbc.Driver");
                conn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/stumng", "root", "zhang");
                preparedStmt = conn.prepareStatement("select * from courseinfo where ctype='2'");
                sqlRst = preparedStmt.executeQuery();
        %>
        <table border="1" width="66"  cellpadding="2" align="center">            <tr>
                <td align="center"  width="66" height="20" bgcolor="#336699">&nbsp;cno</td>
                <td align="center" bgcolor="#336699">&nbsp;cname</td>
                <td align="center" bgcolor="#336699">&nbsp;tno</td>
                <td align="center" bgcolor="#336699">&nbsp;ctype</td>
            </tr>
            <%
                while (sqlRst.next()) {
            %>   
            <tr>
                <td><input type="checkbox" name="cno" value="<%=sqlRst.getString("cno")%>"><%=sqlRst.getString("cno")%></td>
                <td><%=sqlRst.getString("cname")%></td>
                <td><%=sqlRst.getString("tno")%></td>
                <td><%=sqlRst.getString("ctype")%></td>
            </tr>            <%
                }
            %>
            
        </table>
              <p align="right">
                <input type="submit" name="submit" value="OK">&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
<%
        } catch (java.sql.SQLException e) {
        out.println(e.toString());
        } finally {
        if (sqlRst != null)sqlRst.close();
        if(preparedStmt!=null)preparedStmt.close();
        if (conn != null) conn.close();                   }
        %>
        </form>
    </body>
</html>xkcg.jsp
这是提交代码
<%@page contentType="textml" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <body>
        <%  
            if(session.getAttribute("u_no") == null) {
                         response.sendRedirect("index.jsp");
                       }
            String sno = request.getParameter("u_no");
            if (sno == null) {
                sno = "";
            }
            String stars=new String("你选的课程是：");
            String[] paramValues=request.getParameterValues("cno");
                    for(int i=0;i<paramValues.length;i++) stars+=paramValues[i]+"";
            String b = request.getParameter("cno");
            if (b == null) {
                b = "";
            }
            
            java.sql.Connection conn = null;
            java.lang.String strConn;
            java.sql.Statement sqlStmt = null;
            java.sql.ResultSet sqlRst = null;
            try {
                Class.forName("com.mysql.jdbc.Driver");
                conn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/stumng", "root", "zhang");
                sqlStmt = conn.createStatement();
                String sqlQuery = "insert into sc(sno,cno) values(sno,b)";
                
                }catch(java.sql.SQLException e) {
                 out.println(e.toString());
            }finally{
                conn.close();
                               }
        %>
</body>
</html>
谢谢大哥大姐们啊 小弟初来咋到 还望各位前辈多多指点。