資源簡介
前段時期一直使用三層來寫從頁面對數據庫的增刪改查,今天用hibernate框架來實現從頁面對數據庫的增刪改查,
首先介紹下今天我們要實現的功能,
1、用戶能夠注冊,2、注冊成功后直接跳到登錄頁面,3、登錄成功后直接跳到對公司、人員的增刪改查,
4、要有對人員界面的分頁功能

代碼片段和文件信息
package?dao;
import?java.util.List;
import?org.hibernate.Session;
import?org.hibernate.Transaction;
import?entity.bm;
import?entity.ry;
import?entity.user;
import?unity.unitl;
public?class?BmDao?{
//調用工具包
static?unitl?unitl=new?unitl();
static?Session?session=unitl.lj();
int?a=0;
/***********添加部門****************************************************/
public?int?addbm(String?bmname){
int?a=0;
//3、開啟事務
????????Transaction?ts=session.beginTransaction();
????????//執行數據庫操作
????????//添加操作
????????bm?b=new?bm();
????????b.setBmname(bmname);
????????session.save(b);
????????//提交
ts.commit();
//關閉session
//session.close();
a=1;
return?a;
}
/***********查看所有部門****************************************************/
@SuppressWarnings(“unchecked“)
public?List?selectall(){
//執行數據庫操作
//編寫hql
String?hql=“from?bm?“;
List?list=session.createQuery(hql).list();
return?list;
}
/***********根據ID刪除部門****************************************************/
public?int?delete(int?id){
int?a=0;
//3、開啟事務
????????Transaction?ts=session.beginTransaction();
????????//執行數據庫操作
????????//刪除操作
????????bm?b=(bm)session.get(bm.class?id);//注意強轉
????????session.delete(b);
????????
????????
????????//提交
ts.commit();
//關閉session
//session.close();
a=1;
return?a;
}
/***********修改部門****************************************************/
public?void?update(int?id?String?name){
//執行數據庫操作
//編寫hql
Transaction?ts=session.beginTransaction();
bm?b=(bm)session.load(bm.class?id);
System.out.println(name);
b.setBmname(name);
session.update(b);
//提交
ts.commit();
}
/***********根據ID查詢一個部門****************************************************/
public?List??selectone(int?id){
//執行數據庫操作
//編寫hql
String?hql=“select?new?bm(idbmname)?from?bm?where?id=?“;
List?list=session.createQuery(hql)
.setInteger(0?id)
.list();
// for(bm?bb:list){
// System.out.println(bb.getBmname()+bb.getId());
//
// }
return?list;
}
/***********查詢部門有沒有人****************************************************/
@SuppressWarnings(“unchecked“)
public?int??selectonee(int?id){
int?a=1;
String?sql=“select?*from?ry?where?bmid=“+id+““;
List?list=session.createSQLQuery(sql).list();
if(list.size()>0){
a=0;
}
return?a;
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1455??2017-09-05?23:06??company\.classpath
?????文件????????294??2017-09-05?20:06??company\.myme
?????文件???????1280??2017-09-05?21:21??company\.project
?????文件????????330??2017-09-05?20:06??company\.settings\org.eclipse.jdt.core.prefs
?????文件?????445288??2017-09-05?21:06??company\lib\antlr-2.7.7.jar
?????文件?????313898??2017-09-05?21:06??company\lib\dom4j-1.6.1.jar
?????文件??????75324??2017-09-05?21:06??company\lib\hibernate-commons-annotations-4.0.5.Final.jar
?????文件????5283651??2017-09-05?21:06??company\lib\hibernate-core-4.3.11.Final.jar
?????文件?????113371??2017-09-05?21:06??company\lib\hibernate-jpa-2.1-api-1.0.0.Final.jar
?????文件??????76551??2017-09-05?21:06??company\lib\jandex-1.1.0.Final.jar
?????文件?????714194??2017-09-05?21:06??company\lib\javassist-3.18.1-GA.jar
?????文件??????57183??2017-09-05?21:06??company\lib\jboss-logging-3.1.3.GA.jar
?????文件??????11558??2017-09-05?21:06??company\lib\jboss-logging-annotations-1.2.0.Beta1.jar
?????文件??????27717??2017-09-05?21:06??company\lib\jboss-transaction-api_1.2_spec-1.0.0.Final.jar
?????文件?????999018??2017-09-03?10:35??company\lib\mysql-connector-java-5.1.43-bin.jar
?????文件???????2676??2017-09-06?22:13??company\src\dao\BmDao.java
?????文件???????3312??2017-09-06?22:45??company\src\dao\RyDao.java
?????文件???????1300??2017-09-05?23:26??company\src\dao\selectone.java
?????文件????????492??2017-09-06?19:42??company\src\entity\bm.hbm.xm
?????文件????????530??2017-09-06?19:19??company\src\entity\bm.java
?????文件????????638??2017-09-06?19:36??company\src\entity\ry.hbm.xm
?????文件???????1230??2017-09-06?20:46??company\src\entity\ry.java
?????文件????????534??2017-09-05?20:26??company\src\entity\user.hbm.xm
?????文件????????429??2017-09-05?20:23??company\src\entity\user.java
?????文件???????1012??2017-09-06?11:08??company\src\hibernate.cfg.xm
?????文件???????4728??2017-09-06?22:08??company\src\servlet\BmServlet.java
?????文件???????6191??2017-09-06?22:50??company\src\servlet\RyServlet.java
?????文件???????2491??2017-09-05?22:58??company\src\servlet\Userzhuceservlet.java
?????文件????????717??2017-09-05?17:11??company\src\unity\unitl.java
?????文件???????1094??2017-09-05?23:17??company\WebRoot\addbm.jsp
............此處省略54個文件信息
- 上一篇:LPddr3與ddr3功能介紹
- 下一篇:onvif ptz控制 soap協議
評論
共有 條評論