jsp+server+mysql注册登录.zip

jsp+server+mysql简单实现注册登录功能,自己写的比较简单易懂适合入门

package com.yly.dao;



import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import com.yly.DB.DBconn;
import com.yly.util.User;

public class UserDao {
	public User login（String usernameString password） {
		User u=null;
		Connection conn=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		try {
			conn=DBconn.getconnection（）;
			String sql=“select*from user where username=? and password=?“;
			ps=（PreparedStatement） conn.prepareStatement（sql）;
			ps.setString（1 username）;
			ps.setString（2 password）;
			rs=ps.executeQuery（）;
			if（rs.next（）） {
				u=new User（）;
				u.setName（rs.getString（“username“））;
				u.setPassword（rs.getString（“password“））;
				System.out.println（“登录成功！“）;
			}
		}catch（Exception e） {
			e.printStackTrace（）;
		}finally {
			DBconn.closeConn（conn）;
		}
		
		
		return u;
	}
	
	
	
     public void addUser（User user） {
    	 Connection conn=null;
    	 PreparedStatement ps=null;
    	 try {
    	   conn=DBconn.getconnection（）;
    	   String sql=“insert into user（usernamepassword） values（??）“;
    	   ps=（PreparedStatement） conn.prepareStatement（sql）;
    	   ps.setString（1user.getName（））;
    	   ps.setString（2 user.getPassword（））;
    	   ps.executeUpdate（）;
    	 }catch（SQLException e）{
    		 e.printStackTrace（）;
    	 }finally {
			DBconn.closeConn（conn）;
		}
     }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     文件         939  2019-10-10 14:22  demo\.classpath
     文件         904  2019-10-10 14:22  demo\.project
     目录           0  2019-10-14 09:07  demo\.settings\
     文件         567  2019-10-10 14:22  demo\.settings\.jsdtscope
     文件         364  2019-10-10 14:22  demo\.settings\org.eclipse.jdt.core.prefs
     文件         464  2019-10-10 14:22  demo\.settings\org.eclipse.wst.common.component
     文件         345  2019-10-10 14:22  demo\.settings\org.eclipse.wst.common.project.facet.core.xml
     文件          49  2019-10-10 14:22  demo\.settings\org.eclipse.wst.jsdt.ui.superType.container
     文件           6  2019-10-10 14:22  demo\.settings\org.eclipse.wst.jsdt.ui.superType.name
     目录           0  2019-10-14 09:07  demo\build\
     目录           0  2019-10-14 09:07  demo\build\classes\
     目录           0  2019-10-14 09:07  demo\build\classes\com\
     目录           0  2019-10-14 09:07  demo\build\classes\com\yly\
     目录           0  2019-10-14 09:07  demo\build\classes\com\yly\dao\
     文件        2415  2019-10-10 17:37  demo\build\classes\com\yly\dao\UserDao.class
     目录           0  2019-10-14 09:07  demo\build\classes\com\yly\DB\
     文件        1265  2019-10-10 17:02  demo\build\classes\com\yly\DB\DBconn.class
     目录           0  2019-10-14 09:07  demo\build\classes\com\yly\servlet\
     文件        1939  2019-10-10 17:23  demo\build\classes\com\yly\servlet\addservlet.class
     文件        1695  2019-10-10 17:20  demo\build\classes\com\yly\servlet\LoginServlet.class
     目录           0  2019-10-14 09:07  demo\build\classes\com\yly\util\
     文件         707  2019-10-10 14:43  demo\build\classes\com\yly\util\User.class
     目录           0  2019-10-14 09:07  demo\src\
     目录           0  2019-10-14 09:07  demo\src\com\
     目录           0  2019-10-14 09:07  demo\src\com\yly\
     目录           0  2019-10-14 09:07  demo\src\com\yly\dao\
     文件        1471  2019-10-10 17:37  demo\src\com\yly\dao\UserDao.java
     目录           0  2019-10-14 09:07  demo\src\com\yly\DB\
     文件         664  2019-10-10 17:02  demo\src\com\yly\DB\DBconn.java
     目录           0  2019-10-14 09:07  demo\src\com\yly\servlet\
     文件        1238  2019-10-10 17:23  demo\src\com\yly\servlet\addservlet.java
............此处省略15个文件信息