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);
}
}