软件工程作业01

软件工程作业01
今天在做登录功能,首先实现了后端的代码,创建数据表,配置环境,书写pojo类,mapper代码

登录

package com.itheima.service;

import com.itheima.mapper.BrandMapper;
import com.itheima.pojo.Brand;
import com.itheima.util.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

import java.util.List;

public class BrandService {
    SqlSessionFactory factory = new SqlSessionFactoryUtils().getSqlSessionFactory();
   public List<Brand> SelectAll(){
         SqlSession session = factory.openSession();
        BrandMapper brandMapper = session.getMapper(BrandMapper.class);
        List<Brand> list =brandMapper.SelectAll();
         session.close();
        return list;
    }

    public void addBrand(Brand brand){

          SqlSession session = factory.openSession();
          BrandMapper brandMapper = session.getMapper(BrandMapper.class);
          brandMapper.addBrand(brand);
          session.commit();
          session.close();
    }
    public void deleteBrand(Brand brand){

       SqlSession session = factory.openSession();
       BrandMapper brandMapper = session.getMapper(BrandMapper.class);
       brandMapper.deleteBrand(brand);
       session.commit();
       session.close();

    }

    public void changeBrand(Brand brand){

        SqlSession session = factory.openSession();
        BrandMapper brandMapper = session.getMapper(BrandMapper.class);
        brandMapper.changeBrand(brand);
        session.commit();
        session.close();

    }


}

package com.stdu.pojo;

public class User {

    private String username;
    private String password;
    private String type;

    public User(String username, String password, String type) {
        this.username = username;
        this.password = password;
        this.type = type;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }
}

package com.stdu.mapper;

import com.stdu.pojo.User;
import org.apache.ibatis.annotations.*;

import java.util.List;

public interface UserMapper {


    // 新增用户
    @Insert("INSERT INTO user (username, password, type) VALUES (#{username}, #{password}, #{type})")
    int insertUser(User user);

    // 根据用户名删除用户
    @Delete("DELETE FROM user WHERE username = #{username}")
    int deleteByUsername(String username);

    // 更新用户信息
    @Update("UPDATE user SET password = #{password}, type = #{type} WHERE username = #{username}")
    int updateUser(User user);

    // 根据用户名查询用户
    @Select("SELECT * FROM user WHERE username = #{username}")
    @Results(id = "userResultMap", value = {
            @Result(property = "username", column = "username"),
            @Result(property = "password", column = "password"),
            @Result(property = "type", column = "type")
    })
    User selectByUsername(String username);

    // 查询所有用户
    @Select("SELECT * FROM user")
    @ResultMap("userResultMap") // 复用上面定义的Results
    List<User> selectAllUsers();

    // 其他可能的查询（例如按类型查询）
    @Select("SELECT * FROM user WHERE type = #{type}")
    List<User> selectUsersByType(String type);


}