关于hibernate和struts2结合的用法

关于一个完整数据传输过程，即数据从页面通过三层传到数据库，或者数据从数据库通过三层传到页面，目前我使用了 两个框架，这里我做个总结。

hibernate：

相对于struts2，hibernate还是比较容易理解，即改变service层和dao层的结构，service层变化不大，主要是把sql改变成hql，这里就不多讲，主要的改变是dao层，其中主要代码如下：

Session session=null;
Transaction tx=null;
public List<Student> selectAll(String hql,int page) {
session=HibernateUtil.getSession();
Query q=session.createQuery(hql);
List<Student> list=q.setFirstResult((page-1)*5).setMaxResults(5).list();
return list;
}
public int add(Student s) {
session=HibernateUtil.getSession();
Serializable sb=session.save(s);
Transaction tx=session.beginTransaction();
tx.commit();
return Integer.parseInt(sb.toString());
}
public Student selectOne(int id) {
session=HibernateUtil.getSession();
Student st=(Student) session.get(Student.class, id);
return st;
}
public int update(Student st) {
int a=1;
try {
session=HibernateUtil.getSession();
session.update(st);
Transaction tx=session.beginTransaction();
tx.commit();
} catch (Exception e) {
a=0;
e.printStackTrace();
}
return a;
}
public int delete(Student st) {
int a=1;
try {
session=HibernateUtil.getSession();
session.delete(st);
Transaction tx=session.beginTransaction();
tx.commit();
} catch (Exception e) {
a=0;
e.printStackTrace();
}
return a;
}
public int counts(String hql) {
session=HibernateUtil.getSession();
int count=session.createQuery(hql).list().size();
return count;
}

struts2：

struts2主要改变servlet层，简化了数据从页面与servlet层传输的代码，使用了struts2后，servlet层讲不存在，改变成action层，主要代码如下：

private String page;
private String tname;
private String tage;
private String tid;

//封装文件标题属性
private String title;
//封装上传文件属性
private File upload;
//获取提交的文件类型
private String uploadContentType;
//封装上传文件名称
private String uploadFileName;

public String getTid() {
return tid;
}
public void setTid(String tid) {
this.tid = tid;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public File getUpload() {
return upload;
}
public void setUpload(File upload) {
this.upload = upload;
}
public String getUploadContentType() {
return uploadContentType;
}
public void setUploadContentType(String uploadContentType) {
this.uploadContentType = uploadContentType;
}
public String getUploadFileName() {
return uploadFileName;
}
public void setUploadFileName(String uploadFileName) {
this.uploadFileName = uploadFileName;
}
public String getPage() {
return page;
}
public void setPage(String page) {
this.page = page;
}
public String getTname() {
return tname;
}
public void setTname(String tname) {
this.tname = tname;
}
public String getTage() {
return tage;
}
public void setTage(String tage) {
this.tage = tage;
}


StuService u=new StuServiceImpl();
Student st=new Student();
public Student getModel() {
// TODO Auto-generated method stub
return st;
}
TeaService t=new TeaServiceImpl();
public String add(){
try {
byte[] buffer=new byte[1024];
FileInputStream fis=new FileInputStream(this.getUpload());
String p=ServletActionContext.getServletContext().getRealPath("/upload");
FileOutputStream fos=new FileOutputStream(p+"\\"+this.getUploadFileName());
String path=p+"\\"+this.getUploadFileName();
System.out.println(path);
int length=fis.read(buffer);
while (length>0) {
//每次写入length长度的内容
fos.write(buffer,0, length);
length=fis.read(buffer);
}
fis.close();
fos.flush();
fos.close();
st.setPhoto("upload\\"+this.getUploadFileName());
Teacher teacher=t.selectOne(Integer.parseInt(tid));
Student s=new Student(st.getName(), st.getSex(), st.getAge(), st.getPhoto(), teacher);
int a=u.add(s);
if(a>0){
System.out.println("添加成功");
return "Menu";
}else{
System.out.println("添加失败");
}
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return "error";

}
public void selectAll(){
try {
if(page==null){
page="1";
}
Student s=new Student();
if(tage==null||"".equals(tage.trim())){
tage="0";
}
s.setName(tname);
s.setAge(Integer.parseInt(tage));
datagrade dg=u.selectAll(s,Integer.parseInt(page));
super.writeJson(dg);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public String selectOne(){
Student s=u.selectOne(st.getId());
Map<String , Object> session=ActionContext.getContext().getSession();
session.put("s", s);
return "Update";
}
public String update(){
Teacher teacher=t.selectOne(Integer.parseInt(tid));
Student s=new Student(st.getId(),st.getName(), st.getSex(), st.getAge(), st.getPhoto(), teacher);
int a=u.update(s);
if(a>0){
System.out.println("修改成功");
return "Menu";
}else{
System.out.println("修改失败");
}
return "error";
}
public String delete(){
Student s=new Student(st.getId());
int a=u.delete(s);
if(a>0){
System.out.println("删除成功");
return "Menu";
}else{
System.out.println("删除失败");
}
return "error";

}

ajax：

function show(page){
var tname=$("#tname").val();
var tage=$("#tage").val();
$.ajax({
url:'Teacher!selectAll.action',
type:'post',
data:{'tname':tname,'tage':tage,'page':page},
dataType:'json',
async:false,
success:function(data){
var h="<table><tr>"+
"<td>Name</td>"+
"<td>Sex</td>"+
"<td>Age</td>"+
"<td>Photo</td>"+
"<td>Function</td>"+
"<td>Function</td>"+
"</tr>";
for(var i=0;i<data.list.length;i++){
h+="<tr>"+
"<td>"+data.list[i].name+"</td>"+
"<td>"+data.list[i].sex+"</td>"+
"<td>"+data.list[i].age+"</td>"+
"<td><img src='"+data.list[i].photo+"' width='50' height='50'/></td>"+
"<td><a href='Teacher!selectOne.action?id="+data.list[i].id+"'>Update</a></td>"+
"<td><a href='Teacher!delete.action?id="+data.list[i].id+"'>Delete</a></td>"+
"</tr>";
}
h+="</table><a οnclick='show("+(data.page-1<=0?data.page:data.page-1)+")'>上一页</a>"+
"<a οnclick='show("+(data.page+1>=data.sumpage?data.sumpage:data.page+1)+")'>下一页</a><span>总页数:"+data.sumpage+"</span>";
$("#h1").html(h);
},
error:function(){
}
});
}

总结：

以上代码是关于学生类和老师类的增删改查，因为老师关联了学生，我只显示学生类，自然老师可以想象出来。以上代码没有任何意义，这篇博客只是让我在想不起代码的时候拿来看的，对各位看客毫无意义。