一、继续理解练习form表单值的获取
编写input.jsp文件,运行。
<%@ page language="java" contentType="text/html" pageEncoding="GBK"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>index.jsp</title>
</head><body>
<form action="show.jsp" method="post">
<ul style="list-style: none; line-height: 30px">
<li>
输入用户姓名:
<input type="text" name="name" />
<br />
</li>
<li>
选择性别:
<input name="sex" type="radio" value="男" />
男
<input name="sex" type="radio" value="女" />
女
</li>
<li>
选择密码提示问题:
<select name="question">
<option value="母亲生日">
母亲生日
</option>
<option value="宠物名称">
宠物名称
</option>
<option value="电脑配置">
电脑配置
</option>
</select>
</li>
<li>
请输入问题答案:
<input type="text" name="key" />
</li>
<li>
请选择个人爱好:
<div style="width: 400px">
<input name="like" type="checkbox" value="舞蹈" />
唱歌跳舞
<input name="like" type="checkbox" value="上网冲浪" />
上网冲浪
<input name="like" type="checkbox" value="户外登山" />
户外登山
<br />
<input name="like" type="checkbox" value="体育运动" />
体育运动
<input name="like" type="checkbox" value="读书看报" />
读书看报
<input name="like" type="checkbox" value="欣赏电影" />
欣赏电影
</div>
</li>
<li>
<input type="submit" value="提交" />
</li>
</ul>
</form>
</body>
</html>
编写show.jsp文件,运行。
<%@ page language="java" contentType="text/html" pageEncoding="GBK"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>show.jsp</title>
</head><body>
<ul style="list-style:none; line-height:30px">
<li>输入用户姓名:<%=new String(request.getParameter("name").getBytes("ISO8859_1"),"GBK") %></li>
<li>选择性别:<%=new String(request.getParameter("sex").getBytes("ISO8859_1"),"GBK") %></li>
<li>选择密码提示问题:<%=new String(request.getParameter("question").getBytes("ISO8859_1"),"GBK") %></li>
<li>
请输入问题答案:<%=new String(request.getParameter("key").getBytes("ISO8859_1"),"GBK") %>
</li>
<li>
请选择个人爱好:
<%
String[] like =request.getParameterValues("like");
for(int i =0;i<like.length;i++){
%>
<%= new String(like[i].getBytes("ISO8859_1"),"GBK")+" " %>
<%
}
%>
</li>
</ul>
</body>
</html>
二、mysql数据库及表的建立
对数据进行插入操作,运行。
import java.sql.*;
public class test {
public static void main(String[] args) {
try {
Class.forName("com.mysql.cj.jdbc.Driver");Connection c = DriverManager
.getConnection(
"jdbc:mysql://127.0.0.1:3306/student?characterEncoding=UTF-8",
"root", "456");Statement s = c.createStatement();
// 准备sql语句
// 注意: 字符串要用单引号'
String Sql = "INSERT INTO name (姓名, 性别) VALUES ('王雪', '女')";
s.executeUpdate(Sql); // 执行插入语句
String sql= "select * from name " ;
ResultSet rs =s.executeQuery(sql);
while (rs.next()) {
System.out.print( rs.getString(1));
System.out.print(" ");
System.out.print(rs.getString(2));
System.out.println(" ");
}} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}}
}
删除操作,运行。
import javasql.*;
public class test {
public static void main(String[] args) {
try {
Class.forName("com.mysql.cj.jdbc.Driver");Connection c = DriverManager
.getConnection(
"jdbc:mysql://127.0.0.1:3306/student?characterEncoding=UTF-8",
"root", "456");Statement s = c.createStatement();
// 准备sql语句
// 注意: 字符串要用单引号'
String Sql = "DELETE FROM name WHERE 姓名 = ?";
PreparedStatement pstmt = c.prepareStatement(Sql);
pstmt.setString(1, "王雪"); // 设置参数值为"王雪"
pstmt.executeUpdate(); // 执行删除操作String sql= "select * from name " ;
ResultSet rs =s.executeQuery(sql);
while (rs.next()) {
System.out.print( rs.getString(1));
System.out.print(" ");
System.out.print(rs.getString(2));
System.out.println(" ");
}} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}}
}