1.MVC架构在JavaWeb中的应用
每个部分都有不同的职责和功能,以实现代码的分离和可维护性。
- JSP: 用户访问前端页面并发起请求,JSP将请求传递给Servlet
- Servlet: 接收来自JSP的请求,调用Service,完成页面跳转
- Service: 处理业务层代码
- Dao: 访问数据库
2.代码分离,来完成修改密码的功能
先从最底层的Dao写起:
updateUserPassword方法里:写sql语句,执行sql语句
package com.code.dao.user;
import com.code.dao.BaseDao;
import com.code.pojo.User;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class UserDaoImpl implements UserDao{
public User getLoginUser(Connection connection, String userCode) throws Exception {
User user = null;
if(connection!=null){
String sql = "select* from smbms_user where userCode = ?";
Object[] params = {userCode};
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
resultSet = BaseDao.execute(connection, preparedStatement, sql, params,resultSet);
while(resultSet.next()){
user = new User();
user.setAddress(resultSet.getString("address"));
user.setUserCode(resultSet.getString("userCode