WebRoot/jsp/reader/addreader.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java" contentType="text/html; charset=GB2312"  pageEncoding="GB2312"%>
<%@page import="com.book.dao.DBHelper"%>
<%@page import="java.sql.*"%>
<%@page import="com.book.util.*"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312">
<title>读者信息</title>
<%
	
	String name = request.getParameter("name");
	String sex = request.getParameter("sex");
	String email = request.getParameter("email");
	String qq = request.getParameter("qq");
	String phone = request.getParameter("phone");
	String address = request.getParameter("address");
	
	Connection conn =null;
	PreparedStatement ps = null;
	ResultSet rs = null;
	if(name != null){
		try{
			conn = DBHelper.getConnection();
			ps = conn.prepareStatement("insert into book_reader (reader_name,reader_sex,reader_phone,reader_address,email,qq) values (?,?,?,?,?,?)");
			ps.setString(1,Util.encodeGB2312(name));
			ps.setString(2,Util.encodeGB2312(sex));
			ps.setString(3,phone);
			ps.setString(4,Util.encodeGB2312(address));
			ps.setString(5,email);
			ps.setString(6,qq);
			
			ps.execute();
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			DBHelper.close(conn,ps,rs);
			response.sendRedirect("readerList.jsp");
		}
	}
 %>
<style type="text/css">
<!--
body {
	margin-left: 3px;
	margin-top: 0px;
	margin-right: 3px;
	margin-bottom: 0px;
}
.STYLE1 {
	color: #e1e2e3;
	font-size: 12px;
}
.STYLE6 {color: #000000; font-size: 12; }
.STYLE10 {color: #000000; font-size: 12px; }
.STYLE19 {
	color: #344b50;
	font-size: 12px;
}