?? managerdao.java
字號(hào):
package com.dao;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
import org.hibernate.Query;
import com.actionForm.ManagerForm;
import java.util.List;
public class ManagerDao {
private static SessionFactory sessionFactory = null;
private Session session = null;
Transaction tx = null;
static {
try {
Configuration config = new Configuration().configure();
sessionFactory = config.buildSessionFactory();
} catch (Exception e) {
System.out.println(e.getMessage());
}
}
//===
public boolean updateManager(ManagerForm form) {
Session session = sessionFactory.openSession();
try {
tx = session.beginTransaction();
session.load(ManagerForm.class, form.getId());
// session.saveOrUpdate(form);
session.update(form);
tx.commit();
return true;
} catch (Exception e) {
return false;
} finally {
session.close();
}
}
public void deleteManager(int id) {
Session session = sessionFactory.openSession();
try {
tx = session.beginTransaction();
ManagerForm form=(ManagerForm)session.load(ManagerForm.class,id);
session.delete(form);
tx.commit();
} catch (Exception e) {
System.out.println("刪除數(shù)據(jù)出錯(cuò):" + e);
} finally {
session.close();
}
}
//==========
public void insertManager(ManagerForm form) { //對(duì)管理員的插入操作
Session session = sessionFactory.openSession();
try {
tx = session.beginTransaction();
session.save(form);
tx.commit();
} catch (Exception e) {
System.out.println("插入數(shù)據(jù)出錯(cuò):" + e);
} finally {
session.close();
}
}
//==========
public ManagerForm selectOneManager(String account) { //管理員賬號(hào)為條件查詢數(shù)據(jù)
session = sessionFactory.openSession();
tx = session.beginTransaction();
String hql = "from ManagerForm where account='" + account + "'";
ManagerForm form = null;
try {
Query query = session.createQuery(hql);
form = (ManagerForm) query.uniqueResult();
} catch (Exception e) {
System.out.println(e.getMessage());
}
tx.commit();
session.close();
return form;
}
//=========
public List selectManager() {
session = sessionFactory.openSession();
tx = session.beginTransaction();
String hql = "from ManagerForm where not manager=1 order by id desc";
List list = null;
try {
Query query = session.createQuery(hql);
list = query.list();
} catch (Exception e) {
System.out.println(e.getMessage());
}
tx.commit();
session.close();
return list;
}
public void addManagerNumber(int id) {
Session session = sessionFactory.openSession();
try {
tx = session.beginTransaction();
String hql = "from ManagerForm where id='"+id+"'";
Query query = session.createQuery(hql);
List list = query.list();
ManagerForm managerForm = (ManagerForm)list.get(0);
managerForm.setNumber(managerForm.getNumber() + 1);
session.saveOrUpdate(managerForm);
tx.commit();
} catch (Exception e) {
System.out.println("更新數(shù)據(jù)出錯(cuò):" + e);
} finally {
session.close();
}
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -