check2.java

比较简单学生查询系统

package com.fi;

import java.io.*;
import java.sql.*;

import javax.servlet.*;
import javax.servlet.http.*;

public class Check2 extends HttpServlet {
	public void doGet(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		doPost(req, res);

	}

	public void doPost(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException 
			{
		res.setCharacterEncoding("UTF-8");
		req.setCharacterEncoding("UTF-8");
		String username = null;
		String realname = null;
		String tel= null;
		String address= null;
		int age;
		String sex= null;
		int rs;
		HttpSession session = req.getSession(true);
		String password=(String)session.getAttribute("password"); 
		username = req.getParameter("username").trim();
		//HttpSession session = req.getSession(true);
		//session.setAttribute("name",username);
		realname = req.getParameter("realname").trim();
		tel = req.getParameter("tel").trim();
		address = req.getParameter("address").trim();
		sex = req.getParameter("sex").trim();
	age=Integer.parseInt(req.getParameter("age").trim());
		// res.getWriter().print("password"+password);
	sqlBean db = new sqlBean();
	String sql = "update  userinfo set username='"+username+"',realname='"+realname+"',tel='"+tel+"',address='"+address+"',sex='"+sex+"',age="+age+" where password='"
			+ password + "'";
	try {
		 rs = db.executeInsert(sql);
		if (rs!=0) 
		{
			RequestDispatcher rd = getServletContext().getRequestDispatcher(
			"/ok.html");
		rd.forward(req, res);
			}
		else{
			
			RequestDispatcher rd = getServletContext().getRequestDispatcher(
			"/errors.jsp");
		rd.forward(req, res);	
		}
	} 
	catch (Exception e) 
	{
		
}

}
}