<%
        String  sid = request.getParameter("s_id");
        String sname=request.getParameter("s_name");
        sname.trim();
        System.out.println(sname);
        String country = request.getParameter("cname");
        out.print(sid+" "+sname +" "+country);
    try {
             Class.forName("com.mysql.jdbc.Driver");
                Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/zxc", "root", "");
                String ins ="insert into state1(s_id,s_name,ccname) values (?,?,?)";
                PreparedStatement ps = con.prepareStatement(ins);
                ps.setInt(1, Integer.valueOf(sid));
                ps.setString(2,sname);
                ps.setString(3,country);
                ps.executeUpdate();
                response.sendRedirect("insert_state.jsp");
        } catch (Exception e) {
            out.print(e);
        }
    %>