servlet实现用户，注册，登录功能

package com.homework.servlet; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.homework.dao.JDBCServlet; /** * @author jt *2015-8-2 下午4:38:57 * */ public class DataAdd extends HttpServlet { /** * Constructor of the object. */ public DataAdd() { super(); } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); response.setContentType("text/html;charset=utf-8;"); PrintWriter out = response.getWriter(); String uname=request.getParameter("uname"); String pwd=request.getParameter("pwd"); String name=request.getParameter("name"); int age=Integer.parseInt(request.getParameter("age")); String tel=request.getParameter("tel"); String qq=request.getParameter("qq"); System.out.println("用户名"+uname+"密码"+pwd+"xm"+name+"nl"+age+"t"+tel+"QQ"+qq); //out.println("登录成功！"); Connection conn=null; Statement st=null; ResultSet rs=null; conn=JDBCServlet.getconn(); String sql="insert into userst(uname,name,age,tel,qq,pwd)values('"+uname+"', '"+name+"',"+age+",'"+tel+"','"+qq+"','"+pwd+"')"; try { st=conn.createStatement(); st.executeUpdate(sql); System.out.println("加入成功！"); request.getRequestDispatcher("loginPageServlet").forward(request, response); //response.sendRedirect("loginPageServlet"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ JDBCServlet.close(conn, st, rs); } // Connection conn = null; // 表示数据库的连接的对象 // Statement st = null; // 表示数据库的更新操作 // ResultSet rs=null; // try // { // // String sql="select * from users"; // // System.out.println(sql) ; // // 1、使用Class类加载驱动程序 // Class.forName("oracle.jdbc.driver.OracleDriver"); // // 2、连接数据库 // conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:MYORACLE", "jt", "Jiangtao11"); // // 3、Statement接口需要通过Connection接口进行实例化操作 // st = conn.createStatement(); // //用 rs获取查询结果 ，这里的SQL语句最好不要用* 我的字段比较少所以就偷一下懒，－，－ // rs=st.executeQuery(sql); // while(rs.next()) // { // //获取数据库中的ID // String id=rs.getString("id"); // //输出一列元素 // out.print(id ); // } // } catch (Exception e) // { // e.printStackTrace(); // }finally{ // try { // rs.close(); // st.close(); // conn.close(); // } catch (SQLException e) { // // TODO Auto-generated catch block // e.printStackTrace(); // } // } // } /** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }