ssh+json开发实例

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(