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); } }
相关推荐
asp.net+wcf+entity framework
asp.net+spring.net+entity framework 的一个简单例子
Programming+Entity+Framework+Code+First是基于微软的EF架构开发的一个aproach 建议结合Programming+Entity+Framework+DbContext
CMS(MVC+ Entity FramWork + Repository)
springboot+mybatis逆向生成controller+service+mapper+entity 直接生成一个简单的CURD的swagger风格的代码工具,集成了多种通用Mapper。
微信+MVC+EntityFramework Demo
修改webconfig的sql密碼後 遠行項目 隨便輸入什麼點登錄 會自動生成數據庫 生成數據庫之後執行下面的語句 添加種子數據 --數據庫種子數據 use EXTMVC insert [dbo].[users] values('tomoto','tomoto',1,'2014-05-06 ...
WCF+Silverlight+EntityFramework+Sqlite所做的学生信息管理系统,自己闲暇时间做着玩的,页面什么的比较丑,不过不要在意那些细节……数据库采用Sqlite,非常小的一个数据库,我就不提供了,网上一大堆,表结构什么...
WCF+Silverlight+EntityFramework+Sqlite所做的学生信息管理系统
.NET core3.1+entityframework+mysql+增删改查
Ado.Net+Entity+Framework整理后资料.rar
本范例实践了当前流行的WEB开发技术,bootstrap+asp.net core+entity framework
MVC5+EntityFramewrok+EasyUi+WorkFlow权限管理、流程审批系统源码 管理员账户密码:admin admin888
NHinbernate+LINQ+Entity Framework完成的课程设计平台,分为website和project两个部分,project主要是nhibernate,linq和ef在website的app_Code中。 数据库使用sql 2008.
DevExpress+Entity Frameword案例源码,实现了登录,布局等Devexpress学习和entityframework学习以及他们之间的结合使用的案例
NHinbernate+LINQ+Entity Framework完成的课程设计平台,分为website和project两个部分,project主要是nhibernate,linq和ef在website的app_Code中。 数据库使用sql 2008 该部分是nhibernate
自己搭建的 .Net系列框架-Dapper+EntityFrameworkCore+Autofac+WebApi+Web 详细介绍见:https://blog.csdn.net/zhangjiankun880/article/details/106540475
WPF+Entity Frame的Database first模式,使用用户指定的连接字符串的方法,我也曾在网上找了很久,基本没看到有明确说明的,也没有想过示例。 终于结合相关人的描述让我找到了修改的地方。压缩包内为原版工程代码,...
3、如果要使用EntityFramework还需要JetEntityFrameworkProvider,这是第三方github提供的软件,在NuGet上也提供了,不过它仅支持32位的,如果想要使用64位的,可以下载源码重新编译dll。 4、上面说的accessdatabase...
利用EntiyFramWork6.0+WPF 写的一个简单DB Frist Demo 环境:VS2013 SqlServer