Document : insert
Created on : 2010-5-19, 18:20:30
Author : ure
--%>
/p>
"http://www.w3.org/TR/html4/loose.dtd">
注册注册
学号:
姓名:
年龄:
性别:
String num = request.getParameter("num");
String name = request.getParameter("name");
String age = request.getParameter("age");
String sex = request.getParameter("sex");
String userName = "root";
String userPasswd = "gujunjia";
String dbName = "db";
String tableName = "student";
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 sql="insert into student values('"+num+"','"+name+"','"+age+"','"+sex+"')";
statement.executeUpdate(sql);
%>
上述是我的代码,请高手帮忙解决,万分感谢!