【Java开源代码栏目提醒】:网学会员Java开源代码为您提供BoardAdapter.java参考,解决您在BoardAdapter.java学习中工作中的难题,参考学习。
package bbsmodel;
import java.util.List;
import java.util.ListIterator;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
public class BoardAdapter {
SessionFactory sessionFactory=null;
Session session=null;
Transaction transaction;
public BoardAdapter() {
sessionFactory = new Configuration()
.configure().buildSessionFactory();
//session =sessionFactory.openSession();
//transaction = session.beginTransaction();
}
public void open() {
session =sessionFactory.openSession();
transaction = session.beginTransaction();
}
public void close(){
session.close();
sessionFactory.close();
}
/**
* query database
* @param hql
* @return
*/
public List query(String hql) {
open();
List retList=null;
try {
Query query = session.createQuery(hql);
retList = query.list();
session.close();
return retList;
} catch (Exception e) {
e.printStackTrace();
}
return retList;
}
/**
* insert database
* @param user
*/
public void insert(Board board) {
open();
session.save(board);
transaction.commit();
session.close();
//sessionFactory.close();
}
public void update(Board board) {
open();
session.update(board);
transaction.commit();
session.close();
}
public void delete(int i) {
open();
Board board = (Board) session.load(Board.class,i);
session.delete(board);
transaction.commit();
session.close();
}
public List GetList(String hql,int pageNum,
int pageSize) {
int numBegin = 0;
if(pageNum<1){
numBegin = 0;
}
else {
numBegin = (pageNum - 1)*pageSize;
}
List retList=null;
try {
open();
Query query = session.createQuery(hql);
query.setFirstResult(numBegin);
query.setMaxResults(pageSize);
retList = query.list();
session.close();
//sessionFactory.close();
return retList;
} catch (Exception e) {
e.printStackTrace();
}
return retList;
}
///////////////
public List getBoards(){
this.open();
return this.query("from Board");
}
/**
* 返回一个板块对象
* @return
*/
public String [] getOldboard(int bdid){
this.open();
String[] it=new String[3];
List itt=this.query("from Board where bdid="+bdid);
for (ListIterator iteratorp = itt.listIterator();
iteratorp.hasNext();) {
Board bo = (Board) iteratorp.next();
it[0]=bo.getBdname();
it[1]=bo.getBdadmin();
it[2]=String.valueOf(bo.getBdnum());
}
return it;
}
public static void main(String[] args) {
BoardAdapter tp=new BoardAdapter();
//.addTopic("bbs test",1,"test",new Date(),0);
/*tp.open();
List it =tp.getBoards();
for (ListIterator iterator = it.listIterator();
iterator.hasNext();) {
Board mess = (Board) iterator.next();
System.err.println(mess.getBdname()+","+mess.getBdnum()+"\n"
);
}
TopicAdapter tpp=new TopicAdapter();
//.addTopic("bbs test",1,"test",new Date(),0);
List itp =tpp.TopicList(0, 3,0);
for (ListIterator iteratorp = itp.listIterator();
iteratorp.hasNext();) {
Topic mess = (Topic) iteratorp.next();
System.err.println(mess.getTpid()+"\n"+
mess.getTptitle()+"\n"+mess.getTpcontent()+"\n"+
mess.getTpuserid()+"\n"+mess.getTptime()+"\n"+
mess.getTpboardid()+"\n"+mess.getTpreplynum()+"\n"
);
}*/
}
}
上一篇:
Board.java
下一篇:
法律专业开题报告范文