基于jsp和servlet的项目(servlet开发)

截取部分界面

package IT.org.Util;

import java.sql.Connection;
import java.sql.SQLException;

import javax.naming.InitialContext;
import javax.sql.DataSource;

public class DatabaseConnection {
	private Connection conn=null;
	private DataSource ds=null;
	private InitialContext ctx=null;
	public DatabaseConnection() {
		try {
			ctx=new InitialContext();
			ds=(DataSource)ctx.lookup("java:comp/env/jdbc/IT");
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	public Connection getConnection() {
		try {
			this.conn=ds.getConnection();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			return conn;
		}
	}
	
	public void closeCon() {
		try {
			if(conn!=null) conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	public static void main(String[] args) {
		DatabaseConnection d=new DatabaseConnection();
		System.out.println(d.getConnection());
	}
}

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>












			
				
					
					
						

						    
							登录
							 

							

							 

							 

		
							
							
未注册账户请点击 注册
						
					
				
		
				
		
					
						
						

						    
							注册
							
							
							
							
							
							
已注册账户请点击登录
						
					
					
				
		
			
		

文件目录

 Dao

实现类部分：

public class IUserDAOImpl implements IUserDAO{
	private Connection conn;
	public IUserDAOImpl(Connection conn) {
		this.conn=conn;
	}
	@Override
	public boolean findLogin(TUser tuser) throws Exception {
		// TODO Auto-generated method stub
		String sql="SELECt * FROM tuser;";
		Statement st=conn.createStatement();
		ResultSet rs=st.executeQuery(sql);
		boolean isfind=false;
		while(rs.next()) {
			if(tuser.getUserName().equals(rs.getString("username").trim())&&tuser.getPassword().equals(rs.getString("password").trim())) {
				isfind=true;
				break;
			}
		}
		if(isfind) return true;
		else return false;
	}

	@Override
	public int register(TUser tuser) throws Exception {
		// TODO Auto-generated method stub
		String userid=String.valueOf(System.nanoTime()); 
		String sql="INSERT INTO tuser VALUE(?,?,?,'待填','待填','待填','待填',?,'待填','待填');";
		PreparedStatement ppst=conn.prepareStatement(sql);
		ppst.setString(1,userid);
		ppst.setString(2,tuser.getUserName());
		ppst.setString(3,tuser.getPassword());
		ppst.setString(4,tuser.getEmail());
		int rs = ppst.executeUpdate();
		ppst.close() ;
		return rs;
	}

Servlet部分：

package IT.org.Controller;

import java.io.IOException;
import java.util.*;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import IT.org.DAO.IUserDAO;
import IT.org.Factory.DAOFactory;
import IT.org.VO.TUser;


@WebServlet("/Login_Register")
public class Login_Register extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    
    public Login_Register() {
        super();
        // TODO Auto-generated constructor stub
    }

	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		response.setContentType("text/html;charset=UTF-8");
        request.setCharacterEncoding("UTF-8");
        String mytype=request.getParameter("mytype");
        String path="Login.jsp";
        
        //登录功能
        if(mytype.equals("login")) {
	        String username=request.getParameter("un");
	        String password=request.getParameter("pw");
	        System.out.println(username);
	        System.out.println(password);
	        TUser tuser=new TUser(username.trim(),password.trim());
	        IUserDAO dao=DAOFactory.getIUserInstance();
	        try {
				if(dao.findLogin(tuser)) { 
					 ArrayList users=DAOFactory.getIUserInstance().findAllTUser();
					 for(TUser us:users) {
						 if(us.getUserName().equals(tuser.getUserName())) {
							 tuser=us;
							 break;
						 }
					 }
					 HttpSession session=request.getSession();
					 
					 System.out.println("登录者id"+tuser.getUserID());
                     session.setAttribute("tuser",tuser);
					 request.getRequestDispatcher("index.jsp").forward(request, response); 
				}
				else  request.getRequestDispatcher(path).forward(request, response);
				
				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
        }
        //注册功能
        else if(mytype.equals("register")) {
        	String username=request.getParameter("reun");
	        String password=request.getParameter("repw");
	        String email=request.getParameter("email");
	        boolean isexist=false;
	        try {
				ArrayList users=DAOFactory.getIUserInstance().findAllTUser();
				for(TUser u:users) {
					if(u.getUserName().equals(username.trim())||u.getEmail().equals(email.trim())) {
						isexist=true;
						break;
					}
				}
				if(!isexist) {
		        	 TUser tuser=new TUser(username, password,email);
		        try {
					DAOFactory.getIUserInstance().register(tuser);
					request.getRequestDispatcher(path).forward(request, response);
				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
	        }else {
	        	System.out.println("用户名or邮箱已使用");
	        }
			} catch (Exception e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
	       
	        
        }
        
	        
	     
	}

	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}