import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import com.mhys.crm.entity.TbCard;
import com.mhys.crm.service.impl.CardService;
@Controller
public class CardContrtoller {
@Resource
CardService cardService;
// 查询方法
@RequestMapping(“/cardsList”)
public String cardsList(Model model) {
List cardList = cardService.selectAll();
model.addAttribute(“cardList”, cardList);
return “/card”;
}
// 跳转添加页面的方法
@RequestMapping(“/insertInto”)
public String insert() {
return “addCard”;
}
// 添加方法
@RequestMapping(“/insertCard”)
public String insertCard(TbCard tbCard) {
int insertCard = cardService.insertCard(tbCard);
return “redirect:/cardsList.do”;
}
// 删除方法
@RequestMapping(“/deleteCard”)
public String deleteCard(int id) {
int deletCard = cardService.deleteCard(id);
return “redirect:/cardsList.do”;
}
}
com.mhys.crm.dao
TbCardMapper.java
package com.mhys.crm.dao;
import java.util.List;
import com.mhys.crm.entity.TbCard;
public interface TbCardMapper {
int deleteByPrimaryKey(Integer id);
int insert(TbCard record);
List selectAll();
}
TbCardMapper.xml
<?xml version="1.0" encoding="UTF-8"?>delete from tb_card
where id = #{id,jdbcType=INTEGER}
insert into tb_card (id, name, sex,
cardNo, balance, level
)
values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR},
#{sex,jdbcType=VARCHAR},
#{cardno,jdbcType=VARCHAR}, #{balance,jdbcType=VARCHAR}, #{level,jdbcType=VARCHAR}
)
select id, name, sex, cardNo, balance, level
from tb_card
com.mhys.crm.entity
TbCard.java
package com.mhys.crm.entity;
public class TbCard {
private Integer id;
private String name;
private String sex;
private String cardno;
private String balance;
private String level;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name == null ? null : name.trim();
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex == null ? null : sex.trim();
}
public String getCardno() {
return cardno;
}
public void setCardno(String cardno) {
this.cardno = cardno == null ? null : cardno.trim();
}
public String getBalance() {
return balance;
}
public void setBalance(String balance) {
this.balance = balance == null ? null : balance.trim();
}
public String getLevel() {
return level;
}
public void setLevel(String level) {
this.level = level == null ? null : level.trim();
}
}
com.mhys.crm.service.impl
CardService.java
package com.mhys.crm.service.impl;
import java.util.List;
import com.mhys.crm.entity.TbCard;
public interface CardService {
//查询
List selectAll();
//添加
int insertCard(TbCard tbCard);
//删除
int deleteCard(int id);
}
CardServiceImpl.java
package com.mhys.crm.service.impl;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import com.mhys.crm.dao.TbCardMapper;
import com.mhys.crm.entity.TbCard;
@Service
public class CardServiceImpl implements CardService {
@Resource
TbCardMapper mapper;
@Override
public List selectAll() {
List selectAll=mapper.selectAll();
return selectAll;
}
@Override
public int insertCard(TbCard tbCard) {
int addCard=mapper.insert(tbCard);
return addCard;
}
@Override
public int deleteCard(int id) {
int delCard=mapper.deleteByPrimaryKey(id);
return delCard;
}
}
mybatis
sqlMapConfig.xml
<?xml version="1.0" encoding="UTF-8" ?>spring
applicationContext-dao.xml
<?xml version="1.0" encoding="UTF-8"?><beans xmlns=“http://www.springframework.org/schema/beans”
xmlns:context=“http://www.springframework.org/schema/context” xmlns:p=“http://www.springframework.org/schema/p”
xmlns:aop=“http://www.springframework.org/schema/aop” xmlns:tx=“http://www.springframework.org/schema/tx”
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/util
http://www.springframework.org/schema/util/spring-util-4.0.xsd">
<context:property-placeholder location=“classpath:database.properties” />
applicationContext-service.xml
<?xml version="1.0" encoding="UTF-8"?><beans xmlns=“http://www.springframework.org/schema/beans”
xmlns:context=“http://www.springframework.org/schema/context” xmlns:p=“http://www.springframework.org/schema/p”
xmlns:aop=“http://www.springframework.org/schema/aop” xmlns:tx=“http://www.springframework.org/schema/tx”
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
<context:component-scan base-package=“com.mhys.crm” />
<tx:annotation-driven transaction-manager=“transactionManager” />
spring-mvc.xml
<?xml version="1.0" encoding="UTF-8"?><beans xmlns=“http://www.springframework.org/schema/beans”
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xmlns:p=“http://www.springframework.org/schema/p”
xmlns:context=“http://www.springframework.org/schema/context”
xmlns:mvc=“http://www.springframework.org/schema/mvc”
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
<context:component-scan base-package=“com.mhys.crm” />
<mvc:annotation-driven />
jdbc.properties
jdbc.url=jdbc:mysql://localhost:3306/card_db?useUnicode=true&characterEncoding=UTF-8&useSSL=false
jdbc.username=root
jdbc.password=123456
jdbc.driver=com.mysql.jdbc.Driver
WebContent
web.xml
<?xml version="1.0" encoding="UTF-8"?>Card
index.html
index.htm
index.jsp
default.html
default.htm
default.jsp
contextConfigLocation
classpath:spring/applicationContext-*.xml
org.springframework.web.context.ContextLoaderListener
springmvc
org.springframework.web.servlet.DispatcherServlet
contextConfigLocation
classpath:spring/spring-mvc.xml
1
springmvc
*.do
CharacterEncodingFilter
org.springframework.web.filter.CharacterEncodingFilter
encoding
UTF-8
CharacterEncodingFilter
/*
JSP
index.jsp
<%@ page language=“java” import=“java.util.*” pageEncoding=“UTF-8”%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+“😕/”+request.getServerName()+“:”+request.getServerPort()+path;
%>
addCard.jsp
<%@ page language=“java” contentType=“text/html; charset=utf-8”
pageEncoding=“utf-8”%>
<%@taglib uri=“http://java.sun.com/jsp/jstl/core” prefix=“c”%>
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。
深知大多数Java工程师,想要提升技能,往往是自己摸索成长或者是报班学习,但对于培训机构动则几千的学费,着实压力不小。自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!
因此收集整理了一份《2024年Java开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上Java开发知识点,真正体系化!
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!
如果你觉得这些内容对你有帮助,可以扫码获取!!(备注Java获取)
![img](https://img-blog.csdnimg.cn/img_convert/abc66d72618a0950bc3ec1181cfaf157.jpeg)
最后
这份《“java高分面试指南”-25分类227页1000+题50w+字解析》同样可分享给有需要的朋友,感兴趣的伙伴们可挑战一下自我,在不看答案解析的情况,测试测试自己的解题水平,这样也能达到事半功倍的效果!(好东西要大家一起看才香)
《互联网大厂面试真题解析、进阶开发核心学习笔记、全套讲解视频、实战项目源码讲义》点击传送门即可获取!
也去过华为、OPPO等大厂,18年进入阿里一直到现在。**
深知大多数Java工程师,想要提升技能,往往是自己摸索成长或者是报班学习,但对于培训机构动则几千的学费,着实压力不小。自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!
因此收集整理了一份《2024年Java开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。[外链图片转存中…(img-KGZGasf3-1713609661081)]
[外链图片转存中…(img-4q94d2T5-1713609661082)]
[外链图片转存中…(img-sqnZnUMU-1713609661082)]
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上Java开发知识点,真正体系化!
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!
如果你觉得这些内容对你有帮助,可以扫码获取!!(备注Java获取)
![img](https://img-blog.csdnimg.cn/img_convert/abc66d72618a0950bc3ec1181cfaf157.jpeg)
最后
这份《“java高分面试指南”-25分类227页1000+题50w+字解析》同样可分享给有需要的朋友,感兴趣的伙伴们可挑战一下自我,在不看答案解析的情况,测试测试自己的解题水平,这样也能达到事半功倍的效果!(好东西要大家一起看才香)
[外链图片转存中…(img-x4KHppYi-1713609661082)]
[外链图片转存中…(img-3bHvCkDo-1713609661082)]
《互联网大厂面试真题解析、进阶开发核心学习笔记、全套讲解视频、实战项目源码讲义》点击传送门即可获取!