网站建立吸引人的策划活动,百度平台电话,怎么样评价网站做的好坏,广州天河区医院前言
隔壁组的云计算零零后女同事#xff0c;后文简称 云女士 #xff0c;非说 Go 的 Gin 框架比 Springboot 更加的开箱即用#xff0c;我心想在 Java 里面 Springboot 已经打遍天下无敌手#xff0c;这份底蕴岂是 Gin 能比。
但是云女士突出一个执拗#xff0c;非我要…前言
隔壁组的云计算零零后女同事后文简称 云女士 非说 Go 的 Gin 框架比 Springboot 更加的开箱即用我心想在 Java 里面 Springboot 已经打遍天下无敌手这份底蕴岂是 Gin 能比。
但是云女士突出一个执拗非我要 PK 一把 PK 内容就是她使用 Gin而我使用 Springboot 快速搭建一个简单的 Crud 工程最后让其他同事来评判哪个更开箱即用。我毫不犹豫就答应了作为搭建 Springboot 学习工程的资深 Crud 选手咱这份底气还是有的。
云女士选择使用 Gin Gorm 来搭建而我原本想选择 Springboot MyBatis后面转念一想这 MyBatis 要写 XML 文件指不定就因为这个被云女士嘲笑了所以我把 MyBatis 替换为了 MyBatis-Plus这就足够的简洁了吧。
正文
准备事项
既然是 Crud 工程自然要准备好操作的表我和云女士通过如下语句在各自的数据库中创建好了如下两张表。
CREATE TABLE people (id INT(11) PRIMARY KEY AUTO_INCREMENT,p_name VARCHAR(255) NOT NULL,p_age INT(11) NOT NULL
)CREATE TABLE book (id INT(11) PRIMARY KEY AUTO_INCREMENT,b_name VARCHAR(255) NOT NULL,b_price FLOAT NOT NULL
)Gin快速搭建Crud工程
云女士的工程结构如下所示。 云女士的 go.mod 文件内容如下所示。
module gobasego 1.17require (github.com/gin-gonic/gin v1.6.0github.com/jinzhu/gorm v1.9.16github.com/sirupsen/logrus v1.9.3github.com/spf13/cast v1.5.1
)云女士定义了两个结构体作为模型 Model book.go 文件内容如下所示。
package modelconst (BookTableName book
)type Book struct {ID int64 gorm:column:idBookName string gorm:column:b_nameBookPrice float64 gorm:column:b_price
}func (b *Book) TableName() string {return BookTableName
}people.go 文件内容如下所示。
package modelconst (PeopleTableName people
)type People struct {ID int64 gorm:column:idPeopleName string gorm:column:p_namePeopleAge int64 gorm:column:p_age
}func (p *People) TableName() string {return PeopleTableName
}云女士补充道TableName()方法是为模型指定对应的表名。
云女士为 book 表和 people 表分别定义了 Dao 接口dao.go 文件内容如下所示。
package daoimport gobase/modeltype BookDao interface {AddBook(book *model.Book) errorUpdateBook(book *model.Book) errorDeleteBook(book *model.Book) errorListBookById(id uint) (*model.Book, error)
}type PeopleDao interface {AddPeople(book *model.People) errorUpdatePeople(book *model.People) errorDeletePeople(book *model.People) errorListPeopleById(id uint) (*model.People, error)
}BookDao 接口对应的实现在book_dao_impl.go文件中实现如下。
package daoimport (github.com/jinzhu/gormgobase/model
)type BookDaoImpl struct {DB *gorm.DB
}func (b *BookDaoImpl) AddBook(book *model.Book) error {if createResult : b.DB.Create(book); createResult.Error ! nil {return createResult.Error}return nil
}func (b *BookDaoImpl) UpdateBook(book *model.Book) error {if saveResult : b.DB.Save(book); saveResult.Error ! nil {return saveResult.Error}return nil
}func (b *BookDaoImpl) DeleteBook(book *model.Book) error {if deleteResult : b.DB.Delete(book); deleteResult.Error ! nil {return deleteResult.Error}return nil
}func (b *BookDaoImpl) ListBookById(id uint) (*model.Book, error) {var book model.Bookif listResult : b.DB.Where(id ?, id).First(book); listResult.Error ! nil {return nil, listResult.Error}return book, nil
}PeopleDao 接口对应的实现在people_dao_impl.go文件中实现如下。
package daoimport (github.com/jinzhu/gormgobase/model
)type PeopleDaoImpl struct {DB *gorm.DB
}func (b *PeopleDaoImpl) AddPeople(people *model.People) error {if createResult : b.DB.Create(people); createResult.Error ! nil {return createResult.Error}return nil
}func (b *PeopleDaoImpl) UpdatePeople(people *model.People) error {if saveResult : b.DB.Save(people); saveResult.Error ! nil {return saveResult.Error}return nil
}func (b *PeopleDaoImpl) DeletePeople(people *model.People) error {if deleteResult : b.DB.Delete(people); deleteResult.Error ! nil {return deleteResult.Error}return nil
}func (b *PeopleDaoImpl) ListPeopleById(id uint) (*model.People, error) {var people model.Peopleif listResult : b.DB.Where(id ?, id).First(people); listResult.Error ! nil {return nil, listResult.Error}return people, nil
}要操作数据库肯定需要数据库连接云女士将数据库连接的管理实现在了mysql_connection_pool.go文件中内容如下所示。
package mysqlimport (fmtgithub.com/jinzhu/gormgobase/daologtime
)const (UserName rootPassWord rootHost 192.168.101.8Port 3306Database gotestMaxLifetime 60 * time.SecondMaxIdletime 30 * time.SecondMaxOpenconns 6MaxIdleconns 2Dialect mysql
)type DataSouce struct {db *gorm.DB
}func NewDataSource() *DataSouce {var db *gorm.DBdsn : fmt.Sprintf(%s:%stcp(%s:%d)/%s?charsetutf8parseTimeTruelocAsia%%2FShanghai,UserName, PassWord, Host, Port, Database)db, err : gorm.Open(Dialect, dsn)if err ! nil {log.Fatal(err.Error())}db.DB().SetConnMaxLifetime(MaxLifetime)db.DB().SetConnMaxIdleTime(MaxIdletime)db.DB().SetMaxOpenConns(MaxOpenconns)db.DB().SetMaxOpenConns(MaxIdleconns)return DataSouce{db: db,}
}// BookDao 操作book表
func (d *DataSouce) BookDao() dao.BookDao {return dao.BookDaoImpl{DB: d.db,}
}// PeopleDao 操作people表
func (d *DataSouce) PeopleDao() dao.PeopleDao {return dao.PeopleDaoImpl{DB: d.db,}
}云女士将路由写在了webservice.go文件中内容如下。
package adapterimport (github.com/gin-gonic/gingobase/mysql
)func Init() error {dataSouce : mysql.NewDataSource()bookController : NewBookController(dataSouce)propleController : NewPropleController(dataSouce)engine : gin.Default()routerGroupBook : engine.Group(/book)routerGroupBook.POST(/add, bookController.AddBook)routerGroupBook.POST(/update, bookController.UpdateBook)routerGroupBook.POST(/delete, bookController.DeleteBook)routerGroupBook.POST(/list, bookController.ListBookById)routerGroupPeople : engine.Group(/people)routerGroupPeople.POST(/add, propleController.AddPeople)routerGroupPeople.POST(/update, propleController.UpdatePeople)routerGroupPeople.POST(/delete, propleController.DeletePeople)routerGroupPeople.POST(/list, propleController.ListPeopleById)return engine.Run()
}其实除了绑定路由云女士还在Init()函数中进行了简单的服务注入也就是创建数据库连接池然后将数据库连接池给到对应的 web 服务。
云女士将操作 book 表对应的 web 服务写在了book_controller.go文件中其实现如下所示。
package adapterimport (github.com/gin-gonic/gingithub.com/sirupsen/logrusgithub.com/spf13/castgobase/modelgobase/mysqlnet/http
)type BookController struct {dataSource *mysql.DataSouce
}func NewBookController(dataSource *mysql.DataSouce) BookController {return BookController{dataSource: dataSource,}
}func (b *BookController) AddBook(ctx *gin.Context) {var book model.Bookif err : ctx.ShouldBind(book); err ! nil {logrus.Error(读取Book信息失败)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}bookDao : b.dataSource.BookDao()err : bookDao.AddBook(book)if err ! nil {logrus.Error(添加Book失败, err)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}ctx.JSON(http.StatusOK, gin.H{message: success,})
}func (b *BookController) UpdateBook(ctx *gin.Context) {var book model.Bookif err : ctx.ShouldBind(book); err ! nil {logrus.Error(读取Book信息失败)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}bookDao : b.dataSource.BookDao()err : bookDao.UpdateBook(book)if err ! nil {logrus.Error(更新Book失败, err)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}ctx.JSON(http.StatusOK, gin.H{message: success,})
}func (b *BookController) DeleteBook(ctx *gin.Context) {var book model.Bookif err : ctx.ShouldBind(book); err ! nil {logrus.Error(读取Book信息失败)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}bookDao : b.dataSource.BookDao()err : bookDao.DeleteBook(book)if err ! nil {logrus.Error(删除Book失败, err)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}ctx.JSON(http.StatusOK, gin.H{message: success,})
}func (b *BookController) ListBookById(ctx *gin.Context) {id : cast.ToUint(ctx.Query(id))bookDao : b.dataSource.BookDao()book, err : bookDao.ListBookById(id)if err ! nil {logrus.Error(查询Book失败, err)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}ctx.JSON(http.StatusOK, book)
}云女士将操作 people 表对应的 web 服务写在了people_controller.go文件中其实现如下所示。
package adapterimport (github.com/gin-gonic/gingithub.com/sirupsen/logrusgithub.com/spf13/castgobase/modelgobase/mysqlnet/http
)type PeopleController struct {dataSource *mysql.DataSouce
}func NewPropleController(dataSource *mysql.DataSouce) PeopleController {return PeopleController{dataSource: dataSource,}
}func (p *PeopleController) AddPeople(ctx *gin.Context) {var people model.Peopleif err : ctx.ShouldBind(people); err ! nil {logrus.Error(读取People信息失败)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}peopleDao : p.dataSource.PeopleDao()err : peopleDao.AddPeople(people)if err ! nil {logrus.Error(添加People失败, err)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}ctx.JSON(http.StatusOK, gin.H{message: success,})
}func (p *PeopleController) UpdatePeople(ctx *gin.Context) {var people model.Peopleif err : ctx.ShouldBind(people); err ! nil {logrus.Error(读取People信息失败)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}peopleDao : p.dataSource.PeopleDao()err : peopleDao.UpdatePeople(people)if err ! nil {logrus.Error(更新People失败, err)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}ctx.JSON(http.StatusOK, gin.H{message: success,})
}func (p *PeopleController) DeletePeople(ctx *gin.Context) {var people model.Peopleif err : ctx.ShouldBind(people); err ! nil {logrus.Error(读取People信息失败)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}peopleDao : p.dataSource.PeopleDao()err : peopleDao.DeletePeople(people)if err ! nil {logrus.Error(删除People失败, err)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}ctx.JSON(http.StatusOK, gin.H{message: success,})
}func (p *PeopleController) ListPeopleById(ctx *gin.Context) {id : cast.ToUint(ctx.Query(id))peopleDao : p.dataSource.PeopleDao()people, err : peopleDao.ListPeopleById(id)if err ! nil {logrus.Error(查询People失败, err)ctx.JSON(http.StatusInternalServerError, gin.H{message: failed,})return}ctx.JSON(http.StatusOK, people)
}最后云女士简单的展示了一下对 book 表和 prople 表的 Crud 操作。
book 表和 people 表的增删改成功时返回内容如下所示。 book 表和 people 表的查询成功时返回内容如下所示。 Spring boot 快速搭建Crud工程
Spring Boot 基础就不介绍了
云女士基于 Gin 和 Gorm 搭建的 Crud 工程我看完后内心扑哧一笑不过如此。
那现在该轮到我表演了。首先给出整个工程结构图如下所示。 POM 文件内容如下所示。
?xml version1.0 encodingUTF-8?
project xmlnshttp://maven.apache.org/POM/4.0.0xmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsdmodelVersion4.0.0/modelVersionparentgroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-parent/artifactIdversion2.4.1/version/parentgroupIdcom.lee.javabase/groupIdartifactIdjavabase/artifactIdversion1.0-SNAPSHOT/versiondependenciesdependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-jdbc/artifactId/dependencydependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-boot-starter/artifactIdversion3.1.0/version/dependencydependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.16/version/dependencydependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactId/dependency/dependencies/project同样定义 book 表和 people 表对应的实体类 Book 和 People如下所示。
Getter
Setter
public class Book {TableField(id)private int id;TableField(b_name)private String bookName;TableField(b_price)private float bookPrice;}Getter
Setter
public class People {TableField(id)private int id;TableField(p_name)private String peopleName;TableField(p_age)private int peopleAge;}然后定义定义接口如下所示。
Mapper
public interface BookMapper extends BaseMapperBook {
}Mapper
public interface PeopleMapper extends BaseMapperPeople {
}最后是对应的 Controller 实现 BookController 实现如下。
Slf4j
RestController
RequestMapping(/book)
public class BookController {Autowiredprivate BookMapper bookMapper;PostMapping(/add)public ResponseEntityString addBook(RequestBody Book book) {try {bookMapper.insert(book);return new ResponseEntity(添加图书成功, HttpStatus.OK);} catch (Exception e) {log.error(添加图书失败, e);return new ResponseEntity(添加图书失败, HttpStatus.INTERNAL_SERVER_ERROR);}}PostMapping(/update)public ResponseEntityString updateBook(RequestBody Book book) {try {bookMapper.updateById(book);return new ResponseEntity(更新图书成功, HttpStatus.OK);} catch (Exception e) {log.error(更新图书失败, e);return new ResponseEntity(更新图书失败, HttpStatus.INTERNAL_SERVER_ERROR);}}PostMapping(/delete)public ResponseEntityString deleteBook(RequestParam(id) int id) {try {bookMapper.deleteById(id);return new ResponseEntity(删除图书成功, HttpStatus.OK);} catch (Exception e) {log.error(删除图书失败, e);return new ResponseEntity(删除图书失败, HttpStatus.INTERNAL_SERVER_ERROR);}}PostMapping(/list)public ResponseEntityBook listBook(RequestParam(id) int id) {try {Book book bookMapper.selectById(id);return new ResponseEntity(book, HttpStatus.OK);} catch (Exception e) {log.error(查询图书失败, e);return new ResponseEntity(null, HttpStatus.INTERNAL_SERVER_ERROR);}}
}PeopleController 实现如下所示。
Slf4j
RestController
RequestMapping(/people)
public class PeopleController {Autowiredprivate PeopleMapper peopleMapper;PostMapping(/add)public ResponseEntityString addPeople(RequestBody People people) {try {peopleMapper.insert(people);return new ResponseEntity(添加人物成功, HttpStatus.OK);} catch (Exception e) {log.error(添加人物失败, e);return new ResponseEntity(添加人物失败, HttpStatus.INTERNAL_SERVER_ERROR);}}PostMapping(/update)public ResponseEntityString updatePeople(RequestBody People people) {try {peopleMapper.updateById(people);return new ResponseEntity(更新人物成功, HttpStatus.OK);} catch (Exception e) {log.error(更新人物失败, e);return new ResponseEntity(更新人物失败, HttpStatus.INTERNAL_SERVER_ERROR);}}PostMapping(/delete)public ResponseEntityString deletePeople(RequestParam(id) int id) {try {peopleMapper.deleteById(id);return new ResponseEntity(删除人物成功, HttpStatus.OK);} catch (Exception e) {log.error(删除人物失败, e);return new ResponseEntity(删除人物失败, HttpStatus.INTERNAL_SERVER_ERROR);}}PostMapping(/list)public ResponseEntityPeople listPeople(RequestParam(id) int id) {try {People people peopleMapper.selectById(id);return new ResponseEntity(people, HttpStatus.OK);} catch (Exception e) {log.error(查询人物失败, e);return new ResponseEntity(null, HttpStatus.INTERNAL_SERVER_ERROR);}}
}启动应用程序 book 表的 Crud 操作结果如下所示。 prople 表的 Crud 操作结果如下所示。 总结
我宣布Springboot 就是快速搭建 Crud 工程的神。
其实在基于 Gin 和 Gorm 搭建 Crud 工程时云女士还是写得复杂了一点但是我有幸看过她们云平台的项目的代码云女士写得也没毛病虽然是个简化版但也是严格遵从她们项目的代码结构来实现的。
说回 Springboot毫无疑问无论是天然自带 Tomcat 或 Jetty 还是和三方框架整合的各种 Starter 包Springboot 都将开箱即用做到了极致但是转念又一想其实 Springboot 和 Gin 严格来说做比较没啥意义就像 Java 和 Go 的比较一样我觉得也没啥意义各自的优势区间不一样并且各自也都在相关的领域叱咤风云。
各位看官你们觉得呢。
