各位好,ssh2整合问题我做了一个小例子,但出现了一些问题,
表结构如下
create data tb_book(id int,name varchar(20),price float)
entity:Book.java 已经设置了带参和不带参的构造方法
package com.catt.data.entity;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
@Table(name="tb_book")
public class Book {
private int id;
private String name;
private float price;
//设置带参数的构造方法
public Book(int id, String name, float price) {
super();
this.id = id;
this.name = name;
this.price = price;
}
//不设置参数的构造方法
public Book(){
}
@Id
@Column(name="id")
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
@Column(name="name")
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Column(name="price")
public float getPrice() {
return price;
}
public void setPrice(float price) {
this.price = price;
}
}
逻辑层:
package com.catt.data.dao.book.impl;import java.util.ArrayList;
import java.util.List;
import java.util.Map;import org.springframework.stereotype.Repository;import pub.dbDialectFactory.Dialect;
import pub.dbDialectFactory.DialectFactory;
import util.StringUtil;import com.catt.data.dao.BaseDao;
import com.catt.data.dao.book.BookDao;
import com.catt.data.entity.Book;
@SuppressWarnings("serial")
@Repository("bookDaoImpl")
public class BookDaoImpl extends BaseDao implements BookDao {
public int i=0;
public void addBook(Book book) {
book.setId(10*i+1);
i++;
this.save(book);
} public int deleteBookById(int id) {
// TODO Auto-generated method stub
return 0;
} public Book getBookById(int id) {
// TODO Auto-generated method stub
return null;
}
/**
* 取所有的值
public List getBookList(Map map) {
List booklist=new ArrayList();
String sql="select id,name,price from tb_ling_book where 1=1 ";
sql+=this.getCondition(map);//加上查询条件
//System.out.println(sql);
booklist=this.queryBySql(sql);//查询sql语句
return booklist;
}
*/ public Book updateBook(Book book) {
// TODO Auto-generated method stub
return null;
}
//返回条件查询值
protected String getCondition(Map map){
StringBuffer sql=new StringBuffer();
if(StringUtil.checkObj(map.get("price"))){
sql.append(" and price="+(String)map.get("price"));
}
if(StringUtil.checkObj(map.get("name"))){
sql.append(" and name like '%"+(String)map.get("name")+"%'");
}
return sql.toString();
}public List getBookList(Map map) {
// TODO Auto-generated method stub
return null;
}
}service层:
package com.catt.model.service.book.impl;import java.util.List;
import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import com.catt.data.dao.BaseDao;
import com.catt.data.dao.book.BookDao;
import com.catt.data.entity.Book;
import com.catt.model.service.book.BookService;
@SuppressWarnings("serial")
@Service("bookServiceImpl")
public class BookServiceImpl extends BaseDao implements BookService {
@Autowired
private BookDao bookDao;
/***
* @param map 是参数集合
*/
public List getBookList(Map map) {
return bookDao.getBookList(map);
}
public void addBook(Book book) {
bookDao.addBook(book);
}
}action:
package com.catt.view.action.book;
import org.apache.struts2.config.ParentPackage;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Component;import util.RequestUtil;import com.catt.data.entity.Book;
import com.catt.model.service.book.BookService;
import com.catt.view.action.BaseAction;@SuppressWarnings("serial")
@Component("bookAction")
@Scope("prototype")
@ParentPackage("struts-base")
public class BookAction extends BaseAction{
@Autowired
private BookService bookService;
@Autowired
private Book book; public String addBook()throws Exception{
Book book=this.book;
// System.out.println(this.book);
bookService.addBook(book);
RequestUtil.responseOut("GBK", book.getName()+"ddddd",this.getResponse());
return null;
}
public String getBookList()throws Exception{
/**
Map map = RequestUtil.getMapByRequest(getRequest());
// System.out.println(map);
List bookList = bookService.getBookList(map);
Struts2Utils.renderJson(bookList);**/
return null;
}public Book getModel() {
// TODO Auto-generated method stub
return book;
}
}这里进行简单的查询操作却报错,但不给出任何的提示。
各位大侠指点一下
表结构如下
create data tb_book(id int,name varchar(20),price float)
entity:Book.java 已经设置了带参和不带参的构造方法
package com.catt.data.entity;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
@Table(name="tb_book")
public class Book {
private int id;
private String name;
private float price;
//设置带参数的构造方法
public Book(int id, String name, float price) {
super();
this.id = id;
this.name = name;
this.price = price;
}
//不设置参数的构造方法
public Book(){
}
@Id
@Column(name="id")
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
@Column(name="name")
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Column(name="price")
public float getPrice() {
return price;
}
public void setPrice(float price) {
this.price = price;
}
}
逻辑层:
package com.catt.data.dao.book.impl;import java.util.ArrayList;
import java.util.List;
import java.util.Map;import org.springframework.stereotype.Repository;import pub.dbDialectFactory.Dialect;
import pub.dbDialectFactory.DialectFactory;
import util.StringUtil;import com.catt.data.dao.BaseDao;
import com.catt.data.dao.book.BookDao;
import com.catt.data.entity.Book;
@SuppressWarnings("serial")
@Repository("bookDaoImpl")
public class BookDaoImpl extends BaseDao implements BookDao {
public int i=0;
public void addBook(Book book) {
book.setId(10*i+1);
i++;
this.save(book);
} public int deleteBookById(int id) {
// TODO Auto-generated method stub
return 0;
} public Book getBookById(int id) {
// TODO Auto-generated method stub
return null;
}
/**
* 取所有的值
public List getBookList(Map map) {
List booklist=new ArrayList();
String sql="select id,name,price from tb_ling_book where 1=1 ";
sql+=this.getCondition(map);//加上查询条件
//System.out.println(sql);
booklist=this.queryBySql(sql);//查询sql语句
return booklist;
}
*/ public Book updateBook(Book book) {
// TODO Auto-generated method stub
return null;
}
//返回条件查询值
protected String getCondition(Map map){
StringBuffer sql=new StringBuffer();
if(StringUtil.checkObj(map.get("price"))){
sql.append(" and price="+(String)map.get("price"));
}
if(StringUtil.checkObj(map.get("name"))){
sql.append(" and name like '%"+(String)map.get("name")+"%'");
}
return sql.toString();
}public List getBookList(Map map) {
// TODO Auto-generated method stub
return null;
}
}service层:
package com.catt.model.service.book.impl;import java.util.List;
import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import com.catt.data.dao.BaseDao;
import com.catt.data.dao.book.BookDao;
import com.catt.data.entity.Book;
import com.catt.model.service.book.BookService;
@SuppressWarnings("serial")
@Service("bookServiceImpl")
public class BookServiceImpl extends BaseDao implements BookService {
@Autowired
private BookDao bookDao;
/***
* @param map 是参数集合
*/
public List getBookList(Map map) {
return bookDao.getBookList(map);
}
public void addBook(Book book) {
bookDao.addBook(book);
}
}action:
package com.catt.view.action.book;
import org.apache.struts2.config.ParentPackage;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Component;import util.RequestUtil;import com.catt.data.entity.Book;
import com.catt.model.service.book.BookService;
import com.catt.view.action.BaseAction;@SuppressWarnings("serial")
@Component("bookAction")
@Scope("prototype")
@ParentPackage("struts-base")
public class BookAction extends BaseAction{
@Autowired
private BookService bookService;
@Autowired
private Book book; public String addBook()throws Exception{
Book book=this.book;
// System.out.println(this.book);
bookService.addBook(book);
RequestUtil.responseOut("GBK", book.getName()+"ddddd",this.getResponse());
return null;
}
public String getBookList()throws Exception{
/**
Map map = RequestUtil.getMapByRequest(getRequest());
// System.out.println(map);
List bookList = bookService.getBookList(map);
Struts2Utils.renderJson(bookList);**/
return null;
}public Book getModel() {
// TODO Auto-generated method stub
return book;
}
}这里进行简单的查询操作却报错,但不给出任何的提示。
各位大侠指点一下
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货