dealupdate.jsp

这个程序是我们学习JSP的时候做的一个课程设计,是关于动态网页和TOMCAT相结合,然后使用ODBC作为后台数据库.

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%
request.setCharacterEncoding("gb2312");

String id="0";
String name="";
String password="";
String sex="";
String age="0";
String phone="";
String email="";
String address="";

if(request.getParameter("updateid")!=null)
	id=request.getParameter("updateid");
if(request.getParameter("username")!=null)
	name=request.getParameter("username");
if(request.getParameter("password")!=null)
	password=request.getParameter("password");
if(request.getParameter("sex")!=null)
	sex=request.getParameter("sex");
if(request.getParameter("age")!=null && !(request.getParameter("age").equals("")))
	age=request.getParameter("age");
if(request.getParameter("phone")!=null)
	phone=request.getParameter("phone");
if(request.getParameter("email")!=null)
	email=request.getParameter("email");
if(request.getParameter("address")!=null)
	address=request.getParameter("address");

	String sql="update user set name='"+name+"',password='"+password+"',sex='"+sex+"',age="+age+",phone='"+phone+"',email='"+email+"',address='"+address+"' where id="+id;
	conn.executeUpdate(sql);
	conn.close();
	response.sendRedirect("right.jsp");
%>