simpleservletdemo2.java

java servlet add by username userpassword

package careers; 
import java.io.*; 
import test.DataBase; 
import javax.servlet.*;
import javax.servlet.http.*; 
public class SimpleServletDemo2 extends HttpServlet
{
	public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
		{
			request.getCharacterEncoding("GB2312");
			response.setContentType("text/html;charset=gb2312");
			String name1 = request.getParameter("userName");
			String result = request.getParameter("result");
			String age = request.getParameter("age"); 
			Student s = new Student();
			DataBase w = new DataBase();
			
			PrintWriter p = response.getWriter();
			//System.out.println(name+"--"+result+"--"+age);  
			String sql = "select name from student where name='"+name1+"'";
			
			ResultSet rs = s.executeQuery(sql);
			try
			{
				if(rs.next())
				{
					p.write("已经有这个用户名!!");
				}
				else
				{
String sql = "insert into student(userName,result,age) values ('"+name1+"','"+result+"','"+age+"')";

					s.executeUpdate(sql);
				}
			}
			catch(Exception e)
			{
				p.write("错误!");
			} 
			w.closeStmt();
			w.closeConn();
			//name = new String(name.getBytes("iso8859-1"),"gb2312");
			
			//PrintWriter pa= response.getWriter();
			p.write("姓名："+name1+"<br>");
			p.write("年龄："+age+"<br>");
			p.write("成绩："+result+"<br>");
			p.close();
		 }

		public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
		{
			doGet(request,response);
		}	
}