1. JavaWeb实现用户注册功能
框架:Register之下分成三个包:
action:控制层,dao:数据访问层,service:服务层
这就是标准的MVC的开发模式。
action包下:RegisterServlet.java ,从页面得到注册信息,注册到mySQL中去。
框架:Login之下同样分成三个包:
action:控制层,dao:数据访问层,service:服务层
action包下:LoginServlet.java ,查找SQL数据库中是否已经注册了这个用户。
2.增加过滤功能
新建MyFilter的class,让它实现javax.servlet(自己添加的包servlet-api-2.4.jar) Interface.
框架:Register之下分成三个包:
action:控制层,dao:数据访问层,service:服务层
这就是标准的MVC的开发模式。
action包下:RegisterServlet.java ,从页面得到注册信息,注册到mySQL中去。
@WebServlet("/RegisterServlet")
public class RegisterServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private RegisterService service;
public RegisterServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doPost(request,response); //都用doPost方法
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();//获得上下文路径
response.setContentType("text/html;charset=utf-8");
//服务器端的编码格式,客户端提交页码的格式要一致
PrintWriter out = response.getWriter(); //打印信息
String username = request.getParameter("username");
String pswd = request.getParameter("pswd");
String realname = request.getParameter("realname");
List<Object> params = new ArrayList<Object>();
params.add(username);
params.add(pswd);
params.add(realname);
; out.println("-username--->:"+username);
boolean flag = service.registerUser(params); //注册
if (flag) {
request.getSession().setAttribute("username", username);
response.sendRedirect(path + "/main.jsp");
}
out.flush();
out.close();
}
@Override
public void init() throws ServletException {
service = new RegisterDao(); //生成注册对象
}
}
dao包下:RegisterDao.java, 调用JDBC去实现注册的功能
public class RegisterDao implements RegisterService{
private JdbcUtils utils = null;
public RegisterDao() {
utils = new JdbcUtils();
}
//完成了对用户注册的dao的编写
@Override
public boolean registerUser(List<Object> params) {
boolean flag = false;
String sql = "insert into user(username,pswd,realname) values(?,?,?)";
try {
// 先获得链接
utils.getConnection();
flag = utils.updateByPreparedStatement(sql, params);
System.out.println("-flag-->>" + flag);
} catch (Exception e) {
e.printStackTrace();//打印出出错信息
} finally {
// 关闭数据库的链接
utils.releaseConn();
}
return flag;
}
}
service包下:RegisterService.java, 定义注册的接口
public interface RegisterService {
//完成用户的注册功能
public boolean registerUser(List<Object> params);
}
2. JavaWeb实现用户登录功能
框架:Login之下同样分成三个包:
action:控制层,dao:数据访问层,service:服务层
action包下:LoginServlet.java ,查找SQL数据库中是否已经注册了这个用户。
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath(); //获得路径
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
String username = request.getParameter("username");
String pswd = request.getParameter("pswd"); //得到用户和密码
List<Object> params = new ArrayList<Object>();
params.add(username);
params.add(pswd);
boolean flag = service.login(params); //调用login方法
if (flag) {
request.getSession().setAttribute("username", username);
response.sendRedirect(path + "/main.jsp");//跳转到主界面
}
out.flush();
out.close();
}
dao包下:LoginDao.java, 调用JDBC去实现查询功能
public boolean login(List<Object> params) {
boolean flag = false;
String sql = "select * from user where username=? and pswd=?";
try {
jdbcUtils.getConnection();
Map<String, Object> map = jdbcUtils.findSimpleResult(sql, params);
flag = !map.isEmpty() ? true : false;//空是默认值
} catch (Exception e) {
e.printStackTrace();
} finally {
jdbcUtils.releaseConn();
}
return flag;
}
service包下:LoginService.java, 定义查询的接口.
2.增加过滤功能
新建MyFilter的class,让它实现javax.servlet(自己添加的包servlet-api-2.4.jar) Interface.
public class MyFilter implements Filter {
public MyFilter() {
}
@Override
public void destroy() {
}
@Override
public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException {
// 过滤用户的请求,判断是否登录
HttpServletRequest httpServletRequest = (HttpServletRequest) request;//请求
String path = httpServletRequest.getContextPath();
HttpServletResponse httpServletResponse = (HttpServletResponse) response;//响应
httpServletRequest.setCharacterEncoding("utf-8");
httpServletResponse.setCharacterEncoding("utf-8");
String username = (String)httpServletRequest.getSession().getAttribute("username");
if (username==null) { //假如用户名为空时,停在首页
httpServletResponse.sendRedirect(path + "/index.jsp");
}
chain.doFilter(httpServletRequest, httpServletResponse);
}
@Override
public void init(FilterConfig arg0) throws ServletException {
}
}
WebContent下的web.xml,中要做添加:
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<servlet>
<description>This is the description of my J2EE component</description>
<display-name>This is the display name of my J2EE component</display-name>
<servlet-name>RegisterServlet</servlet-name>
<servlet-class>com.product.dbutil.register.action.RegisterServlet</servlet-class>
</servlet>
<servlet>
<description>This is the description of my J2EE component</description>
<display-name>This is the display name of my J2EE component</display-name>
<servlet-name>LoginServlet</servlet-name>
<servlet-class>com.product.dbutil.login.action.LoginServlet</servlet-class>
</servlet>
<filter>
<filter-name>MyFilter</filter-name>
<filter-class>com.product.dbutil.filter.MyFilter</filter-class>
</filter>
<servlet-mapping>
<servlet-name>RegisterServlet</servlet-name>
<url-pattern>/RegisterServlet</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>LoginServlet</servlet-name>
<url-pattern>/LoginServlet</url-pattern>
</servlet-mapping>
<filter-mapping>
<filter-name>MyFilter</filter-name>
<url-pattern>/main.jsp</url-pattern> <!-- 过滤哪个界面 -->
</filter-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
加入Filter之后,就要登录了才能访问main.jsp,直接在地址栏输入http://192.168.0.221:8080/xianfengProject/main.jsp访问不了。