跟我一起学“仓颉Web”基础编程-图书管理Demo

目录一、数据库二、图书管理Demo三、小结一、数据库创建数据库create database web_study; use web_study;创建数据表CREATE TABLE book ( id INT NOT NULL AUTO_INCREMENT COMMENT 图书id, name VARCHAR(20) NOT NULL COMMENT 图书名称, author VARCHAR(20) NOT NULL COMMENT 作者, type VARCHAR(10) NOT NULL COMMENT 图书分类, price DOUBLE NOT NULL COMMENT 图书价格, PRIMARY KEY (id) ) COMMENT图书信息表;给数据表添加数据INSERT INTO book (id, name, author, type, price) VALUES (1, CangJie编程, 钝子生, 名著, 89.90), (2, MySQL必知必会, Ben Forta, 科幻, 39.80), (3, 计算机网络, 谢希仁, 小说, 49.90), (4, 数据结构与算法, 严蔚敏, 社科, 55.20), (5, 活着, 余华, 历史, 29.80), (6, 三体, 刘慈欣, 外国, 38.50), (7, 流浪地球, 刘慈欣, 科普, 25.90), (8, 红楼梦, 曹雪芹, 计算机, 52.00), (9, 西游记, 吴承恩, 数据库, 43.70), (10, 水浒传, 施耐庵, 网络, 40.20), (11, 三国演义, 罗贯中, 算法, 45.10), (12, 百年孤独, 马尔克斯, 文学, 56.80), (13, 老人与海, 海明威, 名著, 22.50), (14, 解忧杂货店, 东野圭吾, 科幻, 37.30), (15, 白夜行, 东野圭吾, 小说, 49.00), (16, 嫌疑人X的献身, 东野圭吾, 社科, 35.60), (17, 乡土中国, 费孝通, 历史, 28.40), (18, 人类简史, 尤瓦尔, 外国, 68.20), (19, 时间简史, 霍金, 科普, 48.90);二、图书管理Demo采用三层架构MVC实现在Src目录下创建book目录以及分层目录如图所示entity包的book代码package WebStudy.book.entity import std.convert.* // Book实体类 public class Book { // 主构造函数 public Book( private var _id: Int64, private var _name: String, private var _author: String, private var _type: String, private var _price: Float64, ){} // 无参构造函数 public init() { this._id 0 this._name this._author this._type this._price 0.0 } // id public mut prop id: Int64 { get() { this._id } set(v) { this._id v } } // 名称 public mut prop name: String { get() { this._name } set(v) { this._name v } } // 作者 public mut prop author: String { get() { this._author } set(v) { this._author v } } // 类别 public mut prop bookType: String { get() { this._type } set(v) { this._type v } } // 价格 public mut prop price: String { get() { this._price.format(.2) } set(v) { this._price Float64.parse(v) } } }mapper包的book_mapper代码package WebStudy.book.mapper import WebStudy.book.entity.* import std.collection.* import std.database.sql.* import std.convert.* import mariadb.cdbc.* /* * 图书数据访问层 */ public class BookMapper { // 获取数据库驱动 // return 数据资源 和 连接 private static func getDriver(): (Datasource, Connection) { // 创建驱动 let driver DriverManager.getDriver(mariadb).getOrThrow() // 数据库的链接 let url mariadb://127.0.0.1:3306 // 数据库用户 let username (username, root) // 数据库密码 let password (password, YGBG372S1) // 需要连接数据库 let database (database, web_study) // 启动驱动获取数据资源 let dataSource driver.open(url, [username, password, database]) // 创建连接 let connection dataSource.connect() return (dataSource, connection) } // 新增图书 // book 图书实体类 // return 数据库影响行数 public func addBook(book: Book): Int64 { let (dataSource, connection) BookMapper.getDriver() let sql insert into book (name, author, type, price) values (?,?,?,?) let statement connection.prepareStatement(sql) statement.setString(1, book.name) statement.setString(2, book.author) statement.setString(3, book.bookType) statement.setFloat64(4, Float64.parse(book.price)) let updateResult statement.update() let row updateResult.rowCount // 释放资源 statement.close() connection.close() dataSource.close() return row } // 根据id删除图书 // id id // return 数据库影响行数 public func deleteBook(id: Int64): Int64 { let (dataSource, connection) BookMapper.getDriver() let sql delete from book where id? let statement connection.prepareStatement(sql) statement.setInt64(1, id) let updateResult statement.update() let row updateResult.rowCount // 释放资源 statement.close() connection.close() dataSource.close() return row } // 更新图书 // book 图书实体类 // return 数据库影响行数 public func updateBook(book: Book): Int64 { let (dataSource, connection) BookMapper.getDriver() let sql update book set name?, author?, type?, price? where id? let statement connection.prepareStatement(sql) statement.setString(1, book.name) statement.setString(2, book.author) statement.setString(3, book.bookType) statement.setFloat64(4, Float64.parse(book.price)) statement.setInt64(5, book.id) let updateResult statement.update() let row updateResult.rowCount // 释放资源 statement.close() connection.close() dataSource.close() return row } // 根据id获取图书信息 // id id // return 图书信息 public func getBook(id: Int64): Book { let (dataSource, connection) BookMapper.getDriver() let sql select * from book where id? let statement connection.prepareStatement(sql) statement.setInt64(1, id) let queryResult statement.query() let book Book() while (queryResult.next()) { book.id queryResult.getInt64(1) book.name queryResult.getString(2) book.author queryResult.getString(3) book.bookType queryResult.getString(4) book.price queryResult.getFloat64(5).toString() } // 释放资源 queryResult.close() statement.close() connection.close() dataSource.close() return book } // 分页查询图书列表 // page 当前页 // row 每页显示行数 // return 图书列表 public func getBookList(page: Int64, row: Int64): ArrayListBook { let (dataSource, connection) BookMapper.getDriver() let sql select * from book where id ? order by id limit ? let statement connection.prepareStatement(sql) statement.setInt64(1, (page-1) * row) statement.setInt64(2, row) let queryResult statement.query() let books ArrayListBook() while (queryResult.next()) { let book Book( queryResult.getInt64(1), queryResult.getString(2), queryResult.getString(3), queryResult.getString(4), queryResult.getFloat64(5) ) books.add(book) } // 释放资源 queryResult.close() statement.close() connection.close() dataSource.close() return books } // 获取图书列表总数 public func getTotal(): Int64 { let (dataSource, connection) BookMapper.getDriver() let sql select COUNT(*) as total from book let statement connection.prepareStatement(sql) let queryResult statement.query() var total 0 while (queryResult.next()) { total queryResult.getInt64(1) } // 释放资源 queryResult.close() statement.close() connection.close() dataSource.close() return total } }service包的book_service代码package WebStudy.book.service import WebStudy.book.entity.* import WebStudy.book.mapper.* import std.collection.* /* * 图书业务逻辑层 */ public class BookService { // 图书数据访问层 private let bookMapper BookMapper() // 新增图书 // book 图书实体类 // return 数据库影响行数 public func addBook(book: Book): Int64 { return this.bookMapper.addBook(book) } // 根据id删除图书 // id id // return 数据库影响行数 public func deleteBook(id: Int64): Int64 { return this.bookMapper.deleteBook(id) } // 更新图书 // book 图书实体类 // return 数据库影响行数 public func updateBook(book: Book): Int64 { return this.bookMapper.updateBook(book) } // 根据id获取图书信息 // id id // return 图书信息 public func getBook(id: Int64): Book { return this.bookMapper.getBook(id) } // 分页查询图书列表 // page 当前页 // row 每页显示行数 // return 图书列表 public func getBookList(page: Int64, row: Int64): ArrayListBook { return this.bookMapper.getBookList(page, row) } // 获取图书列表总数 public func getTotal(): Int64 { return this.bookMapper.getTotal() } }controller包的book_controller代码package WebStudy.book.controller import WebStudy.book.entity.* import WebStudy.book.service.* import std.collection.* /* * 图书控制器 */ public class BookController { // 图书业务逻辑层 private let bookService BookService() // 新增图书 // book 图书实体类 // return 数据库影响行数 public func addBook(book: Book): Int64 { return this.bookService.addBook(book) } // 根据id删除图书 // id id // return 数据库影响行数 public func deleteBook(id: Int64): Int64 { return this.bookService.deleteBook(id) } // 更新图书 // book 图书实体类 // return 数据库影响行数 public func updateBook(book: Book): Int64 { return this.bookService.updateBook(book) } // 根据id获取图书信息 // id id // return 图书信息 public func getBook(id: Int64): Book { return this.bookService.getBook(id) } // 分页查询图书列表 // page 当前页 // row 每页显示行数 // return 图书列表 public func getBookList(page: Int64, row: Int64): ArrayListBook { return this.bookService.getBookList(page, row) } // 图书列表页 public func bookListPage(page: Int64, row: Int64, books: ArrayListBook): String { let total this.bookService.getTotal() // 计算总页数 var totalPage if (total % row 0) { total / row } else { total / row 1 } var currentPage page var bookListPage !DOCTYPE html html langzh-CN head meta charsetUTF-8 title图书列表/title style table { width: 800px; margin: 20px auto; border-collapse: collapse; } th, td { border: 1px solid #333; padding: 8px; text-align: center; } th { background-color: #eee; } .btn { padding: 5px 10px; cursor: pointer; margin:0 3px; } .add-btn { margin: 20px auto; display: block; width: 120px; } .page { text-align: center; margin: 20px; font-size:16px; } /style /head body h2 classbtn add-btn图书列表/h2 button classbtn add-btn onclicktoAdd()新增图书/button table thead tr thID/th th图书名称/th th作者/th th类型/th th价格/th th操作/th /tr /thead tbody // 循环渲染图书数据 for (book in books) { bookListPage tr td${book.id}/td td${book.name}/td td${book.author}/td td${book.bookType}/td td${book.price}/td td button classbtn onclicktoUpdate(${book.id})修改/button button classbtn onclickdeleteBook(${book.id})删除/button /td /tr } bookListPage /tbody /table div classpage button classbtn onclickgetList(1)首页/button button classbtn onclickprevPage() ${if (currentPage 1) {disabled} else {} }上一页/button span第 ${currentPage} 页 / 共 ${totalPage} 页/span button classbtn onclicknextPage() ${if (currentPage totalPage) {disabled} else {} }下一页/button /div script // 获取列表跳转到指定页 function getList(pageNum) { // 这里替换成你真实的后端分页接口/路由 location.href /book/getList?page pageNum row${row}; } // 上一页 function prevPage() { if (${currentPage} 1) { getList(${currentPage} - 1); } } // 下一页 function nextPage() { if (${currentPage} ${totalPage}) { getList(${currentPage} 1); } } // 新增页面 function toAdd() { location.href /book/add; } // 修改页面 function toUpdate(id) { location.href /book/update?id id; } // 删除图书 function deleteBook(id) { if (confirm(确定删除该图书吗)) { location.href /book/delete?id id page${currentPage} row${row}; } } /script /body /html return bookListPage } // 新增图书页面 public func addBookPage(): String { return !DOCTYPE html html langzh-CN head meta charsetUTF-8 title新增图书/title style .form { width: 400px; margin: 50px auto; } .form div { margin: 15px 0; } label { display: inline-block; width: 80px; } input { width: 250px; padding: 5px; } .btn { padding: 8px 20px; margin: 10px 5px; cursor: pointer; } /style /head body div classform h2新增图书/h2 form action/book/doAdd methodpost div label图书名称/label input typetext namename required /div div label作者/label input typetext nameauthor required /div div label类型/label input typetext namebookType required /div div label价格/label input typenumber nameprice required /div div input typesubmit value提交 classbtn button typebutton classbtn onclickback()返回/button /div /form /div script // 返回列表 function back() { window.location.href /book/getList?page1row10; } /script /body /html } // 修改图书页面 public func updateBookPage(book: Book): String { return !DOCTYPE html html langzh-CN head meta charsetUTF-8 title修改图书/title style .form { width: 400px; margin: 50px auto; } .form div { margin: 15px 0; } label { display: inline-block; width: 80px; } input { width: 250px; padding: 5px; } .btn { padding: 8px 20px; margin: 10px 5px; cursor: pointer; } /style /head body div classform h2修改图书/h2 form action/book/doUpdate methodpost input typehidden nameid idbookId value${book.id} div label图书名称/label input typetext namename idname value${book.name} required /div div label作者/label input typetext nameauthor idauthor value${book.author} required /div div label类型/label input typetext namebookType idtype value${book.bookType} required /div div label价格/label input typetext nameprice idprice value${book.price} required /div div input typesubmit value提交 classbtn button typebutton classbtn onclickback()返回/button /div /form /div script // 返回列表 function back() { window.location.href /book/getList?page1row10; } /script /body /html } }book包的server代码package WebStudy.book import WebStudy.book.entity.* import WebStudy.book.controller.* import stdx.net.http.* import std.convert.* /* * 图书服务启动类 */ public class BookServer { // 图书控制器 private let bookController BookController() // 图书列表 private func bookList(): FuncHandler { return FuncHandler { httpContext let request httpContext.request // 获取Form let form request.form // 页数 let page Int64.parse(form.get(page) ?? ) // 每页显示行数 let row Int64.parse(form.get(row) ?? ) // 图书列表 let books this.bookController.getBookList(page, row) httpContext.responseBuilder.header(Content-Type, text/html;charsetUTF-8) httpContext.responseBuilder.body(this.bookController.bookListPage(page, row, books)) } } // 新增图书页 private func addBook(): FuncHandler { return FuncHandler { httpContext httpContext.responseBuilder.header(Content-Type, text/html;charsetUTF-8) httpContext.responseBuilder.body(this.bookController.addBookPage()) } } // 执行新增图书 private func doAddBook(): FuncHandler { return FuncHandler { httpContext // 获取请求参数 let request httpContext.request let form request.form let book Book() book.name form.get(name) ?? book.author form.get(author) ?? book.bookType form.get(bookType) ?? book.price form.get(price) ?? // 执行添加 let row this.bookController.addBook(book) if (row 1) { // 重定向 httpContext.responseBuilder.status(302) httpContext.responseBuilder.header(Location, /book/getList?page1row10) } } } // 删除图书 private func deleteBook(): FuncHandler { return FuncHandler { httpContext let request httpContext.request // 获取Form let form request.form // id let id Int64.parse(form.get(id) ?? ) // 页数 let page Int64.parse(form.get(page) ?? ) // 每页显示行数 let row Int64.parse(form.get(row) ?? ) // 图书列表 let flag this.bookController.deleteBook(id) if (flag 1) { // 重定向 httpContext.responseBuilder.status(302) httpContext.responseBuilder.header(Location, /book/getList?page${page}row${row}) } } } // 修改图书页 private func updateBook(): FuncHandler { return FuncHandler { httpContext // 获取请求参数 let request httpContext.request let form request.form let id Int64.parse(form.get(id) ?? ) let book this.bookController.getBook(id) httpContext.responseBuilder.header(Content-Type, text/html;charsetUTF-8) httpContext.responseBuilder.body(this.bookController.updateBookPage(book)) } } // 执行修改图书 private func doUpdateBook(): FuncHandler { return FuncHandler { httpContext let request httpContext.request let form request.form // 获取表单参数 let id Int64.parse(form.get(id) ?? ) let name form.get(name) ?? let author form.get(author) ?? let bookType form.get(bookType) ?? let price Float64.parse(form.get(price) ?? ) // 构造修改后的图书对象 let book Book(id, name, author, bookType, price) // 执行修改 let row this.bookController.updateBook(book) if (row 1) { // 重定向 httpContext.responseBuilder.status(302) httpContext.responseBuilder.header(Location, /book/getList?page1row10) } } } // 启动服务 public func startServer(): Unit { let server: Server ServerBuilder().addr(127.0.0.1).port(8080).build() server.distributor.register(/book/getList, this.bookList()) server.distributor.register(/book/add, this.addBook()) server.distributor.register(/book/doAdd, this.doAddBook()) server.distributor.register(/book/delete, this.deleteBook()) server.distributor.register(/book/update, this.updateBook()) server.distributor.register(/book/doUpdate, this.doUpdateBook()) println(Web服务已启动...) println(http://localhost:8080/book/getList?page1row10) server.serve() } }主文件main代码package WebStudy import WebStudy.book.BookServer main() { BookServer().startServer() }运行结果图书列表新增修改删除三、小结本章为大家详细的介绍了仓颉Web开发实现图书管理Demo的内容。最后创作不易如果大家觉得我的文章对学习仓颉Web基础编程有帮助的话就动动小手点个免费的赞吧收到的赞越多我的创作动力也会越大哦谢谢大家