ssh整合+json实现增删改查,一个标准的Demo,可以按这个模式开发,感觉蛮方便的,记录下来,避免忘记。
数据库:Oracle;平台:myeclipse
项目结构:
POJO类和映射文件:
package org.jvsun.pojo;
/**
* UserInfo entity. @author MyEclipse Persistence Tools
*/
public class UserInfo implements java.io.Serializable {
// Fields
private Integer userId;
private String userName;
private String userPassword;
private String userRemark;
private String userEmail;
private String userTel;
// Constructors
/** default constructor */
public UserInfo() {
}
/** full constructor */
public UserInfo(String userName, String userPassword, String userRemark,
String userEmail, String userTel) {
this.userName = userName;
this.userPassword = userPassword;
this.userRemark = userRemark;
this.userEmail = userEmail;
this.userTel = userTel;
}
// Property accessors
public Integer getUserId() {
return this.userId;
}
public void setUserId(Integer userId) {
this.userId = userId;
}
public String getUserName() {
return this.userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getUserPassword() {
return this.userPassword;
}
public void setUserPassword(String userPassword) {
this.userPassword = userPassword;
}
public String getUserRemark() {
return this.userRemark;
}
public void setUserRemark(String userRemark) {
this.userRemark = userRemark;
}
public String getUserEmail() {
return this.userEmail;
}
public void setUserEmail(String userEmail) {
this.userEmail = userEmail;
}
public String getUserTel() {
return this.userTel;
}
public void setUserTel(String userTel) {
this.userTel = userTel;
}
}
映射文件:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
<class name="org.jvsun.pojo.UserInfo" table="USER_INFO" schema="ssh">
<id name="userId" type="java.lang.Integer">
<column name="USER_ID" precision="10" scale="0" />
<generator class="sequence" />
</id>
<property name="userName" type="java.lang.String">
<column name="USER_NAME" length="30" />
</property>
<property name="userPassword" type="java.lang.String">
<column name="USER_PASSWORD" length="30" />
</property>
<property name="userRemark" type="java.lang.String">
<column name="USER_REMARK" length="200" />
</property>
<property name="userEmail" type="java.lang.String">
<column name="USER_EMAIL" length="30" />
</property>
<property name="userTel" type="java.lang.String">
<column name="USER_TEL" length="15" />
</property>
</class>
</hibernate-mapping>
DAO接口类:
package org.jvsun.dao;
import java.util.List;
import org.jvsun.pojo.UserInfo;
public interface UserInfoDAO {
public boolean doIns(UserInfo pojo);
public boolean doDel(int sId);
public boolean doUpd(UserInfo pojo);
public UserInfo findById(int sId);
public List<UserInfo> findByUserName(String userName, int currentPage,
int pageSize);
public int findCountByUserName(String userName);
}
DAO接口实现类
package org.jvsun.dao.impl;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.jvsun.dao.UserInfoDAO;
import org.jvsun.pojo.UserInfo;
public class UserInfoDAOImpl implements UserInfoDAO {
SessionFactory sessionFactoy;
public SessionFactory getSessionFactoy() {
return sessionFactoy;
}
public void setSessionFactoy(SessionFactory sessionFactoy) {
this.sessionFactoy = sessionFactoy;
}
public boolean doDel(int sId) {
boolean bool = false;
try {
UserInfo user = (UserInfo) this.sessionFactoy.getCurrentSession()
.get(UserInfo.class, sId);
this.sessionFactoy.getCurrentSession().delete(user);
bool = true;
} catch (Exception e) {
e.printStackTrace();
}
return bool;
}
public boolean doIns(UserInfo pojo) {
boolean bool = false;
try {
this.sessionFactoy.getCurrentSession().save(pojo);
bool = true;
} catch (Exception e) {
e.printStackTrace();
}
return bool;
}
public boolean doUpd(UserInfo pojo) {
boolean bool = false;
try {
UserInfo user = (UserInfo) this.sessionFactoy.getCurrentSession()
.get(UserInfo.class, pojo.getUserId());
user.setUserEmail(pojo.getUserEmail());
user.setUserName(pojo.getUserName());
user.setUserPassword(pojo.getUserPassword());
user.setUserRemark(pojo.getUserRemark());
user.setUserTel(pojo.getUserTel());
bool = true;
} catch (Exception e) {
e.printStackTrace();
}
return bool;
}
public UserInfo findById(int sId) {
UserInfo user = null;
try {
user = (UserInfo) this.sessionFactoy.getCurrentSession().get(