关于用JSP INSERT mysql的问题!急~
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<form name="frm" method="post" action="cc.jsp">
<table>
<tr>
<td align=left>ID:</td>
<td><input type=text name=id maxlength=4 value=""></td>
</tr>
<tr>
<td align=left>NAME:</td>
<td><input type=text name=name maxlength=8 value=""></td>
</tr>
<tr>
<td align=left>SEX:</td>
<td><input type=text name=sex maxlength=4 value=""></td>
</tr>
</table>
<input type="submit" name="submit" value="删除" >
</form>
</body>
</html>
cc.jsp
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import="java.sql.*" %>
<%
//驱动程序名
String driverName="com.mysql.jdbc.Driver";
//数据库用户名
String userName="root";
//密码
String userPasswd="";
//数据库名
String dbName="shujuku";
//表名
String tableName="biao";
//联结字符串
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String id = request.getParameter("id");
String name = request.getParameter("name");
String sex = request.getParameter("sex");
out.println("id ="+id );
out.println("name ="+name );
out.println("sex ="+sex );
out.print("<br>");
//String sql="SELECT id,name,sex FROM biao WHERE id= '" + id + "' and name = '" + name+ "'and sex = '" + sex + "' ";
String sql="INSERT INTO biao('"+id+"','"+name+"','"+sex+"')";
out.print("<br>");
out.print("数据库操作成功,恭喜你");
statement.close();
connection.close();
%>