SSH sql+entity+dao+biz+test

程序员文章站 2022-06-09 17:10:53

...

SQL 语句

create user standDB identified by 123456;
grant connect,resource to standDB;

-- Oracle 删除用户
--drop user standDB cascade;

--标准信息表
create table standards (
       std_id number(10) primary key not null,--标准 id
       std_num varchar2(50) not null,--标准号
       zhname varchar2(40) not null,--中文名称
       std_version varchar2(10) not null,--版本
       keys varchar2(50) not null,--关键字/词
       release_date date null,--发布日期
       impl_date date null,--实施日期
       package_path varchar2(100) not null--//附件路径
);

create sequence seq_standards increment by 1 start with 1 cache 10;

insert into standards
  (std_id, std_num, zhname, std_version, keys, release_date, impl_date, package_path)
values
  (1, 'GB 2312-1511', 'Java 典型', '1999', 'Java',
   to_date('1991-10-16','yyyy-mm-dd'),  to_date('1999-10-16','yyyy-mm-dd'), 'xxx.jpg');
insert into standards
  (std_id, std_num, zhname, std_version, keys, release_date, impl_date, package_path)
values
  (seq_standards.nextval, 'GB 2312-1511', 'Java 典型1', '1999', 'Java',
   to_date('1991-10-16','yyyy-mm-dd'),  to_date('1999-10-16','yyyy-mm-dd'), 'xxx.jpg');
insert into standards
  (std_id, std_num, zhname, std_version, keys, release_date, impl_date, package_path)
values
  (seq_standards.nextval, 'GB 2312-1512', 'Java 典型2', '1999', 'Java',
   to_date('1991-10-16','yyyy-mm-dd'),  to_date('1999-10-16','yyyy-mm-dd'), 'xxx.jpg');
insert into standards
  (std_id, std_num, zhname, std_version, keys, release_date, impl_date, package_path)
values
  (seq_standards.nextval, 'GB 2312-1541', 'Java 典型3', '1999', 'Java',
   to_date('1991-10-16','yyyy-mm-dd'),  to_date('1999-10-16','yyyy-mm-dd'), 'xxx.jpg');
insert into standards
  (std_id, std_num, zhname, std_version, keys, release_date, impl_date, package_path)
values
  (seq_standards.nextval, 'GB 2312-1551', 'Java 典型4', '1999', 'Java',
   to_date('1991-10-16','yyyy-mm-dd'),  to_date('1999-10-16','yyyy-mm-dd'), 'xxx.jpg');
insert into standards
  (std_id, std_num, zhname, std_version, keys, release_date, impl_date, package_path)
values
  (seq_standards.nextval, 'GB 2312-1561', 'Java 典型5', '1999', 'Java',
   to_date('1991-10-16','yyyy-mm-dd'),  to_date('1999-10-16','yyyy-mm-dd'), 'xxx.jpg');
insert into standards
  (std_id, std_num, zhname, std_version, keys, release_date, impl_date, package_path)
values
  (seq_standards.nextval, 'GB 2312-1511', 'Java 典型6', '1999', 'Java',
   to_date('1991-10-16','yyyy-mm-dd'),  to_date('1999-10-16','yyyy-mm-dd'), 'xxx.jpg');
insert into standards
  (std_id, std_num, zhname, std_version, keys, release_date, impl_date, package_path)
values
  (seq_standards.nextval, 'GB 2312-1511', 'Java 典型7', '1999', 'Java',
   to_date('1991-10-16','yyyy-mm-dd'),  to_date('1999-10-16','yyyy-mm-dd'), 'xxx.jpg');
insert into standards
  (std_id, std_num, zhname, std_version, keys, release_date, impl_date, package_path)
values
  (seq_standards.nextval, 'GB 2312-1511', 'Java 典型8', '1999', 'Java',
   to_date('1991-10-16','yyyy-mm-dd'),  to_date('1999-10-16','yyyy-mm-dd'), 'xxx.jpg');
insert into standards
  (std_id, std_num, zhname, std_version, keys, release_date, impl_date, package_path)
values
  (seq_standards.nextval, 'GB 2312-1511', 'Java 典型9', '1999', 'Java',
   to_date('1991-10-16','yyyy-mm-dd'),  to_date('1999-10-16','yyyy-mm-dd'), 'xxx.jpg');

select std_id, std_num, zhname, std_version, keys, release_date, impl_date, package_path from standards

Standards 实体类及映射文件

package cn.entity;
import java.util.Date;
/**
 * 标准信息表
 * */
@SuppressWarnings("serial")
public class Standards implements java.io.Serializable {
	private Integer stdId;//标准 id
	private String stdNum;//标准号
	private String zhname;//中文名称
	private String stdVersion;//版本
	private String keys;//关键字/词
	private Date releaseDate;//发布日期
	private Date implDate;//实施日期
	private String packagePath;//附件路径
	public Standards() {
		super();
	}
	public Standards(String stdNum, String zhname, String stdVersion,
			String keys, Date releaseDate, Date implDate, String packagePath) {
		super();
		this.stdNum = stdNum;
		this.zhname = zhname;
		this.stdVersion = stdVersion;
		this.keys = keys;
		this.releaseDate = releaseDate;
		this.implDate = implDate;
		this.packagePath = packagePath;
	}
	public Standards(Integer stdId, String stdNum, String zhname,
			String stdVersion, String keys, Date releaseDate, Date implDate,
			String packagePath) {
		super();
		this.stdId = stdId;
		this.stdNum = stdNum;
		this.zhname = zhname;
		this.stdVersion = stdVersion;
		this.keys = keys;
		this.releaseDate = releaseDate;
		this.implDate = implDate;
		this.packagePath = packagePath;
	}
	public Integer getStdId() {
		return stdId;
	}
	public void setStdId(Integer stdId) {
		this.stdId = stdId;
	}
	public String getStdNum() {
		return stdNum;
	}
	public void setStdNum(String stdNum) {
		this.stdNum = stdNum;
	}
	public String getZhname() {
		return zhname;
	}
	public void setZhname(String zhname) {
		this.zhname = zhname;
	}
	public String getStdVersion() {
		return stdVersion;
	}
	public void setStdVersion(String stdVersion) {
		this.stdVersion = stdVersion;
	}
	public String getKeys() {
		return keys;
	}
	public void setKeys(String keys) {
		this.keys = keys;
	}
	public Date getReleaseDate() {
		return releaseDate;
	}
	public void setReleaseDate(Date releaseDate) {
		this.releaseDate = releaseDate;
	}
	public Date getImplDate() {
		return implDate;
	}
	public void setImplDate(Date implDate) {
		this.implDate = implDate;
	}
	public String getPackagePath() {
		return packagePath;
	}
	public void setPackagePath(String packagePath) {
		this.packagePath = packagePath;
	}
	@Override
	public String toString() {
		return "Standards [stdId=" + stdId + ", stdNum=" + stdNum + ", zhname="
				+ zhname + ", stdVersion=" + stdVersion + ", keys=" + keys
				+ ", releaseDate=" + releaseDate + ", implDate=" + implDate
				+ ", packagePath=" + packagePath + "]";
	}
}

<?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="cn.entity.Standards" table="STANDARDS" schema="STANDDB">
        <id name="stdId" type="java.lang.Integer">
            <column name="STD_ID" precision="10" scale="0" />
            <generator class="sequence">
            	<param name="sequence">seq_standards</param>
            </generator>
        </id>
        <property name="stdNum" type="java.lang.String">
            <column name="STD_NUM" length="50" not-null="true" />
        </property>
        <property name="zhname" type="java.lang.String">
            <column name="ZHNAME" length="40" not-null="true" />
        </property>
        <property name="stdVersion" type="java.lang.String">
            <column name="STD_VERSION" length="10" not-null="true" />
        </property>
        <property name="keys" type="java.lang.String">
            <column name="KEYS" length="50" not-null="true" />
        </property>
        <property name="releaseDate" type="java.util.Date">
            <column name="RELEASE_DATE" length="7" />
        </property>
        <property name="implDate" type="java.util.Date">
            <column name="IMPL_DATE" length="7" />
        </property>
        <property name="packagePath" type="java.lang.String">
            <column name="PACKAGE_PATH" length="100" not-null="true" />
        </property>
    </class>
</hibernate-mapping>

StandardsDao DAO类

package cn.dao;
import java.util.List;
import cn.entity.Standards;
public interface StandardsDao {
	/**
	 * 列表
	 * @return
	 */
	List<Standards> findAll();
	/**
	 * 列表分页
	 * @param begin
	 * @param end
	 * @return
	 */
	List<Standards> findByPage(int begin,int end);
	/**
	 * 根据标准号查询列表分页
	 * @param begin
	 * @param end
	 * @param stdNum
	 * @return
	 */
	List<Standards> findByPageOfsearch(int begin,int end,String stdNum);
	/**
	 * 根据 id 查询
	 * @param stdId
	 * @return
	 */
	Standards findById(Integer stdId);
	/**
	 * 修改内容
	 * @param standards
	 */
	void update(Standards standards);
	/**
	 * 增加内容
	 * @param standards
	 */
	void insert(Standards standards);
	/**
	 * 多条信息删除
	 * @param stdIds
	 */
	void deleteByIds(Integer[] stdIds);
}

package cn.dao.impl;
import java.util.List;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Restrictions;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import cn.dao.StandardsDao;
import cn.entity.Standards;
public class StandardsDaoImpl extends HibernateDaoSupport implements
StandardsDao {
	@SuppressWarnings("unchecked")
	@Override
	public List<Standards> findAll() {
		return super.getHibernateTemplate().find("from Standards");
	}
	@SuppressWarnings("unchecked")
	@Override
	public List<Standards> findByPage(int begin, int end) {
		DetachedCriteria criteria=DetachedCriteria.forClass(Standards.class);
		return super.getHibernateTemplate().findByCriteria(criteria, begin, end);
	}
	@SuppressWarnings("unchecked")
	@Override
	public List<Standards> findByPageOfsearch(int begin, int end, String stdNum) {
		DetachedCriteria criteria = DetachedCriteria.forClass(Standards.class);
		criteria.add(Restrictions.like("stdNum", "%"+stdNum+"%"));
		return super.getHibernateTemplate().findByCriteria(criteria, begin, end);
	}
	@Override
	public Standards findById(Integer stdId) {
		return (Standards) super.getHibernateTemplate().get(Standards.class, stdId);
	}
	@Override
	public void update(Standards standards) {
		super.getHibernateTemplate().update(standards); 
	}
	@Override
	public void insert(Standards standards) {
		super.getHibernateTemplate().save(standards);
	}
	@Override
	public void deleteByIds(Integer[] stdIds) {
		for (int i = 0; i < stdIds.length; i++) {
			Standards standard = (Standards) super.getHibernateTemplate().get(Standards.class, stdIds[i]);
			if (standard != null) {
				super.getHibernateTemplate().delete(standard);
			}
		}
	}
}

StandardsBiz 业务类

package cn.biz;
import java.util.List;
import cn.entity.Standards;
public interface StandardsBiz {
	/**
	 * 列表
	 * @return
	 */
	List<Standards> findAll();
	/**
	 * 列表分页
	 * @param begin
	 * @param end
	 * @return
	 */
	List<Standards> findByPage(int pageIndex, int pageSize);
	/**
	 * 根据标准号查询列表分页
	 * @param begin
	 * @param end
	 * @param stdNum
	 * @return
	 */
	List<Standards> findByPageOfsearch(int pageIndex,int pageSize,String stdNum);
	/**
	 * 根据 id 查询
	 * @param stdId
	 * @return
	 */
	Standards findById(Integer stdId);
	/**
	 * 修改内容
	 * @param standards
	 */
	void update(Standards standards);
	/**
	 * 增加内容
	 * @param standards
	 */
	void insert(Standards standards);
	/**
	 * 多条信息删除
	 * @param stdIds
	 */
	void deleteByIds(Integer[] stdIds);
}

package cn.biz.impl;
import java.util.List;
import cn.biz.StandardsBiz;
import cn.dao.StandardsDao;
import cn.entity.Standards;
public class StandardsBizImpl implements StandardsBiz {
	private StandardsDao standardsDao;
	public void setStandardsDao(StandardsDao standardsDao) {
		this.standardsDao = standardsDao;
	}
	@Override
	public List<Standards> findAll() {
		return standardsDao.findAll();
	}
	@Override
	public List<Standards> findByPage(int pageIndex, int pageSize) {
		int begin = (pageIndex - 1) * pageSize;
		return standardsDao.findByPage(begin, pageSize);
	}
	@Override
	public List<Standards> findByPageOfsearch(int pageIndex, int pageSize,
			String stdNum) {
		int begin = (pageIndex - 1) * pageSize;
		return standardsDao.findByPageOfsearch(begin, pageSize,stdNum);
	}
	@Override
	public Standards findById(Integer stdId) {
		return standardsDao.findById(stdId);
	}
	@Override
	public void update(Standards standards) {
		standardsDao.update(standards);
	}
	@Override
	public void insert(Standards standards) {
		standardsDao.insert(standards);
	}
	@Override
	public void deleteByIds(Integer[] stdIds) {
		for (Integer integer : stdIds) {
			System.out.println(integer);
		}
		standardsDao.deleteByIds(stdIds);
	}
}

StandardsTest 测试类

package cn.test;
import java.sql.Date;
import java.util.List;
import org.junit.After;
import org.junit.AfterClass;
import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import cn.biz.StandardsBiz;
import cn.entity.Standards;
public class StandardsTest {
	StandardsBiz standardsBiz;
	static ApplicationContext ctx;
	@BeforeClass  
	public static void init(){
		ctx=new	ClassPathXmlApplicationContext("applicationContext.xml");
	}
	@Before 
	public void setUp(){
		standardsBiz=(StandardsBiz) ctx.getBean("standardsBiz");
	}
	@After
	public void tearDown(){
		standardsBiz=null;
	}
	@AfterClass
	public static void destory(){
		ctx=null;
	}
	//@Test
	public void testFindAll(){
		List<Standards> standards = standardsBiz.findAll();
		for (Standards standard : standards) {
			System.out.println(standard);
		}
	}
	//@Test
	public void testFindByPage(){
		List<Standards> standards = standardsBiz.findByPage(2, 3);
		for (Standards standard : standards) {
			System.out.println(standard);
		}
	}
	//@Test
	public void testFindByPageOfsearch(){
		List<Standards> standards = standardsBiz.findByPageOfsearch(2, 3, "号");
		for (Standards standard : standards) {
			System.out.println(standard);
		}
	}
	//@Test
	public void testFindById(){
		Standards standards = standardsBiz.findById(2);
		System.out.println(standards);
	}
	//@Test
	public void testUpdate(){
		@SuppressWarnings("deprecation")
		Standards standards = new Standards(1, "aaaa", "bbb", "cccc", "bbbb", new Date(1911, 10, 16), new Date(1912, 10, 18), "imges.abc");
		standardsBiz.update(standards);
	}
	//@Test
	public void testInsert(){
		@SuppressWarnings("deprecation")
		Standards standards = new Standards( "aaaa", "bbb", "cccc", "bbbb", new Date(1911, 10, 16), new Date(1912, 10, 18), "imges.abc");
		standardsBiz.insert(standards);
	}
	//@Test
	public void testDeleteByIds(){
		Integer[] ids = {1,3,5};
		standardsBiz.deleteByIds(ids);
	}
}

上一篇： Python爬虫学习案例之抓取猫眼电影排行Top100

下一篇： SSH sql+entity+dao+biz

SSH sql+entity+dao+biz+test

centos基本信息和ssh

PuTTY SSH Tunnel设置图文教程

Python paramiko模块使用解析（实现ssh）

使用ssh keys实现免验证登陆远程服务器

linux下设置ssh免密码登陆的配置步骤分享

PyCharm设置SSH远程调试的方法

Windows 下的免费 SSH 客户端工具介绍

SSH远程管理

CentOS 6.5 制作可以ssh登录的Docker镜像

Ubuntu环境下SSH的安装及使用详解