javax.servlet
jstl
1.2
org.mybatis
mybatis
3.5.2
org.mybatis
mybatis-spring
2.0.2
org.springframework
spring-webmvc
5.1.9.RELEASE
org.springframework
spring-jdbc
5.1.9.RELEASE
org.projectlombok
lombok
1.16.10
org.aspectj
aspectjweaver
1.9.4
src/main/java
**/*.properties
**/*.xml
false
src/main/resources
**/*.properties
**/*.xml
false
包结构
com.kuang.pojo
com.kuang.dao
com.kuang.controller
com.kuang.service
resources资源
applicationContext.xml
mybatis-config.xml
database.properties
spring-dao.xml
spring-mvc.xml
spring-service.xml
第一小步 database.proper
必看视频!获取2024年最新Java开发全套学习资料 备注Java
ties
#如果使用的是mysql8.0+,增加一个时区的配置
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8
jdbc.username=root
jdbc.password=root
第二小步 mybatis-config.xml
<?xml version="1.0" encoding="UTF-8" ?>package com.kuang.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Books {
private int bookID;
private String bookName;
private int bookCounts;
private String detail;
}
package com.kuang.dao;
import com.kuang.pojo.Books;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface BookMapper {
//增加一本书
int addBook(Books books);
//删除一本书
int deleteBookByID(@Param(“bookId”) int id);
//修改一本书
int updateBook(Books books);
//查询一本书
Books queryBookById(@Param(“bookId”)int id);
//查询全部书
List queryAllBook();
Books queryBookByName(@Param(“bookName”)String bookName);
}
<?xml version="1.0" encoding="UTF-8" ?>
insert into ssmbuild.books(bookName,bookCounts,detail)
values(#{bookName},#{bookCounts},#{detail});
delete from ssmbuild.books where bookID=#{bookId}
update ssmbuild.books set bookName =#{bookName}
,bookCounts=#{bookCounts},detail=#{detail}
where bookID=#{bookID};
select * from ssmbuild.books
where bookID=#{bookId} ;
select * from ssmbuild.books
select * from ssmbuild.books where bookName=#{bookName}
写完记得绑定Mappers
package com.kuang.service;
import com.kuang.pojo.Books;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface BookService {
//增加一本书
int addBook(Books books);
//删除一本书
int deleteBookByID( int id);
//修改一本书
int updateBook(Books books);
//查询一本书
Books queryBookById(int id);
//查询全部书
List queryAllBook();
Books queryBookByName(@Param(“bookName”)String bookName);
}
package com.kuang.service;
import com.kuang.dao.BookMapper;
import com.kuang.pojo.Books;
import java.util.List;
最后
小编精心为大家准备了一手资料
以上Java高级架构资料、源码、笔记、视频。Dubbo、Redis、设计模式、Netty、zookeeper、Spring cloud、分布式、高并发等架构技术
【附】架构书籍
- BAT面试的20道高频数据库问题解析
- Java面试宝典
- Netty实战
- 算法
BATJ面试要点及Java架构师进阶资料
–
package com.kuang.service;
import com.kuang.dao.BookMapper;
import com.kuang.pojo.Books;
import java.util.List;
最后
小编精心为大家准备了一手资料
[外链图片转存中…(img-l6PSc2IF-1716377923798)]
[外链图片转存中…(img-qCGMODny-1716377923798)]
以上Java高级架构资料、源码、笔记、视频。Dubbo、Redis、设计模式、Netty、zookeeper、Spring cloud、分布式、高并发等架构技术
【附】架构书籍
- BAT面试的20道高频数据库问题解析
- Java面试宝典
- Netty实战
- 算法
[外链图片转存中…(img-CGQLNc9u-1716377923799)]
BATJ面试要点及Java架构师进阶资料
[外链图片转存中…(img-ixscW2hK-1716377923799)]