JSP表单往数据库提交
发布时间
阅读量：
阅读量
<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<html>
<body>
<form action="p1.jsp" method="post">
<fieldset>
<legend>姓名：</legend>
<input required="required" type="text" name="name" id="a" /><br/>
</fieldset>
<fieldset>
<legend>年龄：</legend>
<input type="number" name="age" id="b" /><br/>
</fieldset>
<fieldset>
<legend>性别：</legend>
<select name="sex">
<option value="男">男</option>
<option value="女">女</option>
</select>
</fieldset>
<fieldset>
<legend>提交：</legend>
<input type="submit" value="点进来有惊喜呦">
<input name="" type="reset" value="清空" />
</fieldset>
</form>
</body>
</html>
代码解读 <%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<html>
<body>
<%
request.setCharacterEncoding("UTF-8");
//获取值
String name=request.getParameter("name");
String age=request.getParameter("age");
String sex=request.getParameter("sex");
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student??useUnicode=true&characterEncoding=UTF-8","root","123456");
//添加数据
String sql="insert into xmq(name,age,sex) values(?,?,?)";
//PreparedStatement是Statement的子接口语句的组织变量不依赖变量不容意出错
PreparedStatement p=conn.prepareStatement(sql);
p.setString(1, name);
p.setString(2, age);
p.setString(3, sex);
int i=p.executeUpdate();
out.println("成功添加"+i+"行");
p.close();
conn.close();
%>
</body>
</html>
代码解读全部评论 (0)
还没有任何评论哟~