package com.example.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Books {
private int bookId;
private String bookName;
private int bookCounts;
private String bookDetail;
}
Mapper接口
package com.example.dao;
import com.example.pojo.Books;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.util.List;
public interface BookMapper {
int insertBook(Books books);
int deleteBookById(@Param("bookId") int bookId);
int updateBook(Books books);
Books getBookById(@Param("bookId") int bookId);
@Select("select * from ssm_build.books")
List listBooks();
}
Mapper.xml
insert into ssm_build.books(book_id, book_name, book_counts, book_detail)
VALUES (#{bookId}, #{bookName}, #{bookCounts}, #{bookDetail})
delete from ssm_build.books where book_id = #{bookId}
update ssm_build.books
set book_name = #{bookName}, book_counts = #{bookCounts}, book_detail = #{bookDetail}
where book_id = #{bookId}
Service层
接口
package com.example.service;
import com.example.pojo.Books;
import java.util.List;
public interface BookService {
int insertBook(Books books);
int deleteBookById(int bookId);
int updateBook(Books books);
Books getBookById(int bookId);
List listBooks();
}
实现类
package com.example.service;
import com.example.dao.BookMapper;
import com.example.pojo.Books;
import java.util.List;
public class BookServiceImpl implements BookService{
// service层 调 dao层
private BookMapper bookMapper;
public void setBookMapper(BookMapper bookMapper) {
this.bookMapper = bookMapper;
}
@Override
public int insertBook(Books books) {
return bookMapper.insertBook(books);
}
@Override
public int deleteBookById(int bookId) {
return bookMapper.deleteBookById(bookId);
}
@Override
public int updateBook(Books books) {
return bookMapper.updateBook(books);
}
@Override
public Books getBookById(int bookId) {
return bookMapper.getBookById(bookId);
}
@Override
public List listBooks() {
return bookMapper.listBooks();
}
}
本文介绍了在使用Laravel和sqlsrv连接到SQL Server 2016时,如何在插入查询中使用输出子句,并返回所需的值。同时讨论了使用CreatedOn字段返回最近创建的行的解决方法以及使用Eloquent模型创建后,值正确插入数据库但没有返回uniqueidentifier字段的问题。最后给出了一个示例代码。 ...
[详细]