- 前言
- 一、数据库设计
- 二、项目架构设计
- 三、配置文件
- 1、web.xml
- 2、applicationContext.xml
- 3、database.properties
- 4、mybatis.xml
- 5、spring-mvc.xml
- 四、注册功能实现
- 1、regist.html
- 2、EmpController
- 3、EmpService
- 4、EmpServiceImpl
- 5、EmpMapper
- 6、Emp
- 四、登录功能实现
- 1、login.html
- 2、EmpController
- 3、EmpService
- 4、EmpServiceImpl
- 5、EmpMapper
- 6、Emp
- 五、跟踪信息功能实现
- 1、展示
- 2、添加
- 3、修改
- 六、跟踪信息功能实现
- 1、展示
- 2、添加
- 3、修改
- 七、密码修改
- 总结
前言
本系统是一款PC端的员工客户关系管理系统,方便公司员工对客户进行管理和意向记录。用户注册以后可以登录系统,可以查看员工对接客户信息,包括用户电话、公司、职位等信息,还可以查看用户的意向等操作。页面展示不是jsp,是Ajax请求。动态生成dom节点和数据。
一、数据库设计SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for customer -- ---------------------------- DROP TABLE IF EXISTS `customer`; CREATE TABLE `customer` ( `cid` int NOT NULL AUTO_INCREMENT, `cname` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `csex` char(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ctel` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cjob` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ccompany` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`cid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for emp -- ---------------------------- DROP TABLE IF EXISTS `emp`; CREATE TABLE `emp` ( `eid` int NOT NULL AUTO_INCREMENT, `ename` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `esex` char(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `etel` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `etx` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `passwd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`eid`) USING BTREE, UNIQUE INDEX `username`(`username`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for track -- ---------------------------- DROP TABLE IF EXISTS `track`; CREATE TABLE `track` ( `tid` int NOT NULL AUTO_INCREMENT, `cid` int NULL DEFAULT NULL, `eid` int NULL DEFAULT NULL, `record` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `intention` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`tid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; SET FOREIGN_KEY_CHECKS = 1;二、项目架构设计 三、配置文件 1、web.xml
3、EmpServiceencoding org.springframework.web.filter.CharacterEncodingFilter encoding utf-8 encoding @RequestMapping("/crm/reg") public ResponseEntity reg(Emp emp) { emp.setPasswd(MD5Util.toMd5(emp.getPasswd())); int i = empService.addEmp(emp); ResponseEntity responseEntity = new ResponseEntity<>(); if (i == -1) { responseEntity.setCode(200); responseEntity.setMessage("用户名已存在!"); responseEntity.setData(i); return responseEntity; } if (i == -2) { responseEntity.setCode(500); responseEntity.setMessage("添加失败!"); responseEntity.setData(i); return responseEntity; } responseEntity.setCode(200); responseEntity.setMessage("添加成功!"); responseEntity.setData(i); return responseEntity; } }
public interface EmpService {
int addEmp(Emp emp);
}
4、EmpServiceImpl
@Service
public class EmpServiceImpl implements EmpService {
@Resource
private EmpMapper empMapper;
@Override
public int addEmp(Emp emp) {
try {
Emp empByUsername = empMapper.findEmpByUsername(emp.getUsername());
if (empByUsername == null) {
int i = empMapper.addEmp(emp);
return i;
} else {
//用户已被注册
return -1;
}
} catch (Exception e) {
//注册失败
return -2;
}
}
}
5、EmpMapper
public interface EmpMapper {
int addEmp(Emp emp);
}
6、Emp
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Emp {
private int eid;
private String ename;
private String esex;
private String etel;
private String etx;
private String username;
private String passwd;
}
四、登录功能实现
1、https://blog.csdn.net/weixin_51596697/article/details/login.html
登录页面
2、EmpController
@RestController
public class EmpController {
@Autowired
private EmpService empService;
@RequestMapping("/reg/login")
public ResponseEntity login(Emp emp) {
emp.setPasswd(MD5Util.toMd5(emp.getPasswd()));
int i = empService.login(emp);
ResponseEntity responseEntity = new ResponseEntity<>();
if (i == -1) {
responseEntity.setCode(200);
responseEntity.setMessage("用户密码输入错误!");
responseEntity.setData(i);
return responseEntity;
}
if (i == -2) {
responseEntity.setCode(500);
responseEntity.setMessage("没有此用户!");
responseEntity.setData(i);
return responseEntity;
}
responseEntity.setCode(200);
responseEntity.setMessage("登录成功!");
responseEntity.setData(i);
return responseEntity;
}
}
3、EmpService
public interface EmpService {
int login(Emp emp);
}
4、EmpServiceImpl
@Service
public class EmpServiceImpl implements EmpService {
@Resource
private EmpMapper empMapper;
@Override
public int login(Emp emp) {
try {
Emp emp1 = empMapper.findEmpByUsername(emp.getUsername());
if (emp1.getPasswd().equals(emp.getPasswd())) {
//密码正确
return emp1.getEid();
}
//用户输入密码错误
return -1;
} catch (Exception e) {
//用户未注册·用户名输入错误
return -2;
}
}
}
5、EmpMapper
public interface EmpMapper {
Emp findEmpByUsername(String username);
}
6、Emp
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Emp {
private int eid;
private String ename;
private String esex;
private String etel;
private String etx;
private String username;
private String passwd;
}
五、跟踪信息功能实现 1、展示 2、添加 3、修改 六、跟踪信息功能实现 1、展示 2、添加 3、修改 七、密码修改 总结
博客只给了部分代码,全套资源+sql(开源),均已上传。



