save.jsp

一个简单的同学录系统,有增、删、修改、查询、分页功能

<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="in.jsp"%>
<jsp:useBean id="cn" class="ConDb.ConDb" scope="page" />

<%String name, sex, birthday, qq, phone, email, work, addr, postcode, other, id;
			id = request.getParameter("id");
			name = new String(request.getParameter("name").getBytes("8859_1"));
			sex = new String(request.getParameter("sex").getBytes("8859_1"));
			birthday = request.getParameter("birth1") + "-"
					+ request.getParameter("birth2") + "-"
					+ request.getParameter("birth3");
			qq = request.getParameter("qq");
			phone = request.getParameter("phone");
			email = request.getParameter("email");
			work = new String(request.getParameter("work").getBytes("8859_1"));
			addr = new String(request.getParameter("addr").getBytes("8859_1"));
			postcode = request.getParameter("postcode");
			other = new String(request.getParameter("other").getBytes("8859_1"));
			if (request.getParameter("act").equals("save")) {

				cn
						.Update("insert into class(name,sex,birth,qq,phone,email,work,addr,postcode,other) values('"
								+ name
								+ "','"
								+ sex
								+ "','"
								+ birthday
								+ "','"
								+ qq
								+ "','"
								+ phone
								+ "','"
								+ email
								+ "','"
								+ work
								+ "','"
								+ addr
								+ "','"
								+ postcode
								+ "','" + other + "')");

			} else {
				cn.Update("update class set name='" + name + "',sex='" + sex
						+ "',birth='" + birthday + "',qq='" + qq + "',phone='" + phone
						+ "',email='" + email + "',work='" + work + "',addr='" + addr
						+ "',postcode='" + postcode + "',other='" + other
						+ "' where id=" + id);
			}
			cn.close();
			response.sendRedirect("index.jsp");

		%>