jsp mysql 表单提交_jsp--提交表单→插入数据库→成功后返回提示信息

request.setCharacterEncoding("UTF-8");

response.setCharacterEncoding("UTF-8");

response.setContentType("text/html; charset=utf-8");

%>

add message into table

String id=request.getParameter("id"); //从表单获得

String name=request.getParameter("name"); //从表单获得

String sex=request.getParameter("sex"); //从表单获得

String age=request.getParameter("age"); //从表单获得

java.util.Date date=new java.util.Date();

String datetime=new Timestamp(date.getTime()).toString();

try

{

/** 连接数据库参数 **/

String driverName = "com.mysql.jdbc.Driver"; //驱动名称

String DBUser = "root"; //mysql用户名

String DBPasswd = "123456"; //mysql密码

String DBName = "html_db"; //数据库名

String connUrl = "jdbc:mysql://localhost/" + DBName + "?user=" + DBUser + "&password=" + DBPasswd;

Class.forName(driverName).newInstance();

Connection conn = DriverManager.getConnection(connUrl);

Statement stmt = conn.createStatement();

stmt.executeQuery("SET NAMES UTF8");

String insert_sql = "insert into person_tb values('" + id + "','" + name + "','" + sex + "','" + age + "')";

String query_sql = "select * from person_tb";

try {

stmt.execute(insert_sql);

}catch(Exception e) {

e.printStackTrace();

}

try {

ResultSet rs = stmt.executeQuery(query_sql);

while(rs.next()) {

%>

ID：

姓名：

性别：

年龄：

}

}catch(Exception e) {

e.printStackTrace();

}

//rs.close();

stmt.close();

conn.close();

}catch (Exception e) {

e.printStackTrace();

}

%>

界面显示查询结果