Eclipse和Mysql之查询语句
来源:互联网 发布:点餐平台源码 编辑:程序博客网 时间:2024/05/22 12:41
package test;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import entity.Language;
import entity.LanguageDAO;
public class Test extends HibernateDaoSupport {
@org.junit.Test
public void select() {
ApplicationContext context = new ClassPathXmlApplicationContext(
"applicationContext.xml");
LanguageDAO dao = (LanguageDAO) context.getBean("LanguageDAO");
List<Language> list = dao.getHibernateTemplate().find("from Language");
for (Iterator<Language> iterator = list.iterator(); iterator.hasNext();) {
Language language = iterator.next();
System.out
.println("编号=" + language.getLanguageId() + "\t语言="
+ language.getName() + "\t更新日期="
+ language.getLastUpdate());
}
}
@org.junit.Test
public void selectByPage() {
ApplicationContext context = new ClassPathXmlApplicationContext(
"applicationContext.xml");
LanguageDAO dao = (LanguageDAO) context.getBean("LanguageDAO");
Session session = dao.getSessionFactory().openSession();
for (Iterator<Language> iterator = list.iterator(); iterator.hasNext();) {
Language language = iterator.next();
System.out
.println("编号=" + language.getLanguageId() + "\t语言="
+ language.getName() + "\t更新日期="
+ language.getLastUpdate());
}
}
}
import java.util.Iterator;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import entity.Language;
import entity.LanguageDAO;
public class Test extends HibernateDaoSupport {
@org.junit.Test
public void select() {
ApplicationContext context = new ClassPathXmlApplicationContext(
"applicationContext.xml");
LanguageDAO dao = (LanguageDAO) context.getBean("LanguageDAO");
List<Language> list = dao.getHibernateTemplate().find("from Language");
for (Iterator<Language> iterator = list.iterator(); iterator.hasNext();) {
Language language = iterator.next();
System.out
.println("编号=" + language.getLanguageId() + "\t语言="
+ language.getName() + "\t更新日期="
+ language.getLastUpdate());
}
}
@org.junit.Test
public void selectByPage() {
ApplicationContext context = new ClassPathXmlApplicationContext(
"applicationContext.xml");
LanguageDAO dao = (LanguageDAO) context.getBean("LanguageDAO");
Session session = dao.getSessionFactory().openSession();
Query query = session.createQuery("from Language");
query.setFirstResult(4).setMaxResults(2);
for (Iterator<Language> iterator = list.iterator(); iterator.hasNext();) {
Language language = iterator.next();
System.out
.println("编号=" + language.getLanguageId() + "\t语言="
+ language.getName() + "\t更新日期="
+ language.getLastUpdate());
}
}
}
阅读全文
0 0
- Eclipse和Mysql之查询语句
- MySql之优化查询语句
- mysql查询语句之limit
- MySQL查询语句在eclipse在出错
- MySQL查询语句之复杂查询_day04
- MySQL语句基础之单表查询
- mysql的hql语句之时间段查询
- MYSQL和SQL查询语句大全
- mysql优化SELECT语句和其它查询
- mysql优化SELECT语句和其它查询
- Oracle和MySQL分页查询SQL语句
- Oracle和Mysql的分页查询语句
- mysql和eclipse插入语句乱码问题
- mysql常用命令详解大全(二)之mysql查询语句select
- mysql 基本操作指南之mysql查询语句
- mysql分页原理和高效率的mysql分页查询语句
- mysql分页原理和高效率的mysql分页查询语句
- mysql分页原理和高效率的mysql分页查询语句
- CentOS7最小安装后应做的配置&必要软件安装流程
- Qt基础 02_Qt对话框(一)
- OpenGL实现碰撞检测与模拟重力效果(简单的物理系统)
- 关键字之流程控制
- Spark性能优化指南——高级篇
- Eclipse和Mysql之查询语句
- Java8之lambda表达式详解
- 安卓控件2
- 用malloc分配动态二维数组
- 网络监控利器-Zabbix的简介
- Python的requests软件包详解
- 美团 Robust热更新使用图解
- C6678多核DSP开发——vlib应用之连通域标记
- Hive on Tez部署及验证测试