EasyUi Hibernate 增加编辑book对象，里面又有book类型对象；添加编辑时在combobox动态加载book的类型
浏览数：111 /
时间：2015年06月09日
最近弄book的增改花了不少时间，主要是在bookType上花的时间较多。
Book
@Entity
@Table(name="T_Book")
@DynamicInsert(true)
@DynamicUpdate(true)
public class Book implements java.io.Serializable {
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name="BookId")
private int BookId;
//虚拟属性，每次查询时，还要查询有多少本书，可借多少本，然后赋值,这样book就能添加这两个参数了
@Transient
private int totalNum;//馆藏数
@Transient
private int canBorrowNum;//可借数
/**
* 用于业务逻辑的字段，注解@Transient代表不需要持久化到数据库中
*/
@ManyToOne
<span style="white-space:pre"> </span>@JoinColumn(name="BookTypeId") //重点！！！！！！！！！！！！！
private BookType BookType;
//抓取策略为EAGER，要不然bookService统计有多少本书时错误。
@OneToMany(mappedBy="Book",cascade=(CascadeType.ALL), fetch=FetchType.EAGER)
private Set<BookSN> BookSNs;
@Column(name="BookName")
private String BookName;
//省略部分属性和set，get函数
}@Entity
@Table(name="T_BookType")
@DynamicInsert(true)
@DynamicUpdate(true)
public class BookType implements java.io.Serializable {
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name="BookTypeId")
private int BookTypeId;
@Column(name="BookTypeName")
private String BookTypeName;
@Column(name="BookTypeCode")
private String BookTypeCode;
@OneToMany(mappedBy="BookType")
private Set<Book> Books;
//省略get和set函数
}
jsp（用html创建而不是jquery）：<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<%@ include file="/common/base.jsp"%> <%--前面加了/就是代表绝对路径，即包含了localhost+端口号+项目名 --%>
<script type="text/javascript">
var url;
function newBook(){
$('#dlg').dialog('open').dialog('setTitle','添加书籍');
$('#fm').form('clear');
document.getElementById("fieldBookID").style.visibility="hidden"; //这里书籍id是自增长，所以不用显示id字段
url = 'book/addBook';
}
function editBook(){
var row = $('#dg').datagrid('getSelected');
// alert(row.userId);
if (row){
$('#dlg').dialog('open').dialog('setTitle','编辑书籍');
$('#fm').form('load',row);
//解决编辑是不能显示书类型问题 这里要注意的是设置combox的值是bookTypeId而不是bookTypeName，因为传到后台是要bookTypeId的而//不是bookTypeName！！！！！！！！！！！！！！！
if(row.bookType.bookTypeName!=null){
$('#formBookType').combobox('setValue',row.bookType.bookTypeId);
}
url ='book/updateBook';
}
}
function saveBook(){
$.post(url, sy.serializeObject($('#fm')), function(result) {
if (result.success) {
$.messager.show({
title:'Info',
msg:result.msg,
showType:'fade',
style:{
right:'',
bottom:''
}
});
$('#dlg').dialog('close'); // close the dialog
$('#dg').datagrid('reload'); // reload the user data
} else {
$.messager.show({
title: 'Error',
msg: result.msg
});
}
}, 'json');
}
function doSearch(){
$('#dg').datagrid('load',{
queryBookName: $('#searchBox').val()
});
}
function clearSearch(){
$('#searchBox').val('');
$('#dg').datagrid('load',{});
}
//这里因为不能再field里面直接用bookType.bookTypeName，所以要用formatter！！！！！！！
function formatBookType(val,row,index){
//alert(row.bookType);
if(row.bookType==null){
return "";
}else
return row.bookType.bookTypeName;
}
</script>
</head>
<body class="easyui-layout" data-options="fit:true,border:false">
<table id="dg" class="easyui-datagrid" data-options="fit:true,border:false"
url="book/listBookForUser"
toolbar="#toolbar" pagination="true"
rownumbers="true" fitColumns="true" singleSelect="true">
<thead>
<tr>
<th field="bookId" value= width="50">书ID</th>
<th field="bookName" width="50">书名</th>
<th field="bookType.bookTypeName" width="50" formatter="formatBookType">书类型</th>
<th field="author" width="50">作者</th>
<th field="callNumber" width="50">索书号</th>
<th field="iSBN" width="50">ISBN</th>
<th field="publisher" width="50">出版社</th>
<th field="publishYear" width="50">出版年份</th>
<th field="series" width="50">系列</th>
<th field="language" width="50">语言</th>
<th field="price" width="50">价格</th>
<th field="page" width="50">页数</th>
</tr>
</thead>
</table>
<div id="toolbar">
<br>
<a href="javascript:void(0);" class="easyui-linkbutton" iconCls="icon-add" plain="true" onclick="newBook()">New Book</a>
<a href="javascript:void(0);" class="easyui-linkbutton" iconCls="icon-edit" plain="true" onclick="editBook()">Edit Book</a>
<div>
<span>BookName:</span>
<input id="searchBox" style="line-height:26px;border:1px solid #ccc">
<a href="javascript:void(0);" class="easyui-linkbutton" iconCls="icon-search" plain="true" onclick="doSearch()">Search</a>
<td><a href="javascript:void(0);" class="easyui-linkbutton" iconCls="ext-icon-zoom_out" plain="true" onclick="clearSearch()">清空查询</a></td>
</div>
</div>
<div id="dlg" class="easyui-dialog" style="width:300px;height:350px;padding:10px 20px"
closed="true" buttons="#dlg-buttons">
<form id="fm" method="post" novalidate>
<table cellpadding="5">
<div class="fitem" id="fieldBookID">
<label>书ID:</label>
<input name="bookId" readonly="readonly">
</div>
<div class="fitem">
<label>书名:</label>
<input name="bookName" class="easyui-validatebox" required="true" >
</div>
<label>书类型:</label> <!--这里极其注意每一个字段。select name为bookTypeId ->
<select name="bookType.bookTypeId" id="formBookType" class="easyui-combobox" data-options="required:true,editable:false,valueField:'bookTypeId',textField:'bookTypeName',url:'bookType/getBookType',panelHeight:'auto'" style="width: 155px;"></select>
<div class="fitem">
<label>作者:</label>
<input name="author">
</div>
//省略部分属性！！！！！！！！！！！！！！！！
</table>
</form>
</div>
<div id="dlg-buttons">
<a href="javascript:void(0);" class="easyui-linkbutton" iconCls="icon-ok" onclick="saveBook()">Save</a>
<a href="javascript:void(0);" class="easyui-linkbutton" iconCls="icon-cancel" onclick="javascript:$('#dlg').dialog('close')">Cancel</a>
</div>
</body>
</html>jsp要注意的地方很多。。。
BookController：
@Controller
@RequestMapping("/book")
public class BookController extends BaseController {
@Autowired
private IBookService bookService;
@RequestMapping("/borrow")
/**
* 用于管理员查询和添加书籍
* @param request
* @param response
* @return 书籍基本信息列表
* @throws Exception
*/
@RequestMapping("listBookForUser")
public String listBookForUser(HttpServletRequest request,
HttpServletResponse response) throws Exception {
page=ServletRequestUtils.getIntParameter(request, "page", 1);//默认值为1
rows=ServletRequestUtils.getIntParameter(request, "rows", 0);
String queryBookName=request.getParameter("queryBookName");//获取要查询的用户账号
// System.out.println(queryBookName);
Grid grid = new Grid();
String hql=null;
long totalNum;
List<Book>books;
if(queryBookName!=null)
{
hql="from Book as book where book.BookName like '%"+queryBookName+"%'";
}else{
hql="from Book";
}
books=(List<Book>)bookService.find(hql, page, rows);
totalNum=bookService.count("select count(*)"+hql);
grid.setTotal(totalNum);
grid.setRows(books);
writeJson(grid,response);
return null;
}
@RequestMapping("/goAddBook")
public ModelAndView goAddBook(){
return new ModelAndView("book/addBook");
}
/**
* 管理员添加书籍
* @param book
* @param request
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/addBook")
public String addBook(Book book,HttpServletRequest request,
HttpServletResponse response) throws Exception{
Json json = new Json();//用于向前端发送消息
//这里怎么判断一本书是否存在？ ISBN不同版次可能一样么？
//if(bookService.getById(book.getBookId())!=null){
// json.setMsg("添加书籍失败，用户已存在！");
//}else{
System.out.println("34657");
bookService.save(book);
json.setMsg("添加书籍成功！");
json.setSuccess(true);
// }
writeJson(json,response);
return null;
}
@RequestMapping("/updateBook")
public String updateBook(Book book,HttpServletResponse response) throws Exception{
Json json = new Json();//用于向前端发送消息
try{
bookService.update(book);
json.setMsg("更新成功！");
json.setSuccess(true);
}catch(Exception e){
json.setMsg("更新失败！"+e.getMessage());
}
writeJson(json,response);
return null;
}
}
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
