check3.java

比较简单学生查询系统

package com.fi;

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

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

public class Check3 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 ="";
		String realname = "";
		String tel= "";
		String address= "";
		String password= "";
		int age;
		String sex= "";
		int rs;
		username = req.getParameter("username").trim();
		password = req.getParameter("password").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 = "insert into  userinfo values('"+username+"','"+password+"','"+realname+"',"+age+",'"+tel+"','"+sex+"','"+address+"')";
	try {
		 rs = db.executeInsert(sql);
		if (rs!=0) 
		{
			RequestDispatcher rd = getServletContext().getRequestDispatcher(
			"/success.jsp");
		rd.forward(req, res);
			}
		else{
			
			RequestDispatcher rd = getServletContext().getRequestDispatcher(
			"/errors1.jsp");
		rd.forward(req, res);	
		}
	} 
	catch (Exception e) 
	{
		
}

}
}