package dao;
//实现底层(数据访问层)层操作员(管理员)管理系统接口
import java.sql.*;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import po.Tcharge;
import po.TchargeRule;
import po.Tmobiles;
import po.Toperator;
public class AdminOperatorDAOImp implements IAdminOperatorDAO {
//hibernate SessionFactory对象,由spring注入.
private SessionFactory factory;
//增加操作员
public boolean addOperator(Toperator operator) {
Session session=factory.openSession();
Transaction ts=session.beginTransaction();
session.save(operator);
ts.commit();
boolean isok=ts.wasCommitted();
session.close();
return isok;
}
//增加业务收费
public boolean addChargeRule(TchargeRule rule) {
Session session=factory.openSession();
Transaction ts=session.beginTransaction();
session.save(rule);
ts.commit();
boolean isok=ts.wasCommitted();
session.close();
return isok;
}
//删除原有业务收费
public boolean delAllChargeRule(String business) {
boolean isok=true;
Session session=factory.openSession();
Transaction ts=session.beginTransaction();
Connection conn=session.connection();
try {
Statement state=conn.createStatement();
int i=state.executeUpdate("delete from TCHARGE_RULE where FUNC_ID='"+business+"'");
if(i==0){
isok=false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
ts.commit();
session.close();
return true;
}
//设置收费细项
public boolean setMoney(Tcharge charge) {
boolean isok=true;
Session session=factory.openSession();
Transaction ts=session.beginTransaction();
System.out.println(charge.getChargeCode());
Connection conn=session.connection();
try {
Statement state = conn.createStatement();
int i=state.executeUpdate("update TCHARGE set charge="+charge.getCharge()+" where charge_code='"+charge.getChargeCode()+"'");
if(i==0){
isok=false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
ts.commit();
session.close();
return isok;
}
//判断操作员是否存在
public boolean isOperatorExist(Toperator operator) {
boolean isExist=false;
Session session=factory.openSession();
Transaction ts=session.beginTransaction();
Query query=session.createQuery("from Toperator t where t.operatorId="+operator.getOperatorId()+"");
List list=query.list();
Iterator it=list.iterator();
if(it.hasNext()){
isExist=true;
}
ts.commit();
session.close();
return isExist;
}
//增加手机号码
public boolean addNumber(Tmobiles mobile) {
Session session=factory.openSession();
Transaction ts=session.beginTransaction();
session.save(mobile);
ts.commit();
boolean isok=ts.wasCommitted();
session.close();
return isok;
}
//判断手机卡号是否存在
public boolean isCardExist(String cardnumber) {
boolean isExist=false;
Session session=factory.openSession();
Transaction ts=session.beginTransaction();
Query query=session.createQuery("from Tmobiles t where t.cardNumber='"+cardnumber+"'");
List list=query.list();
Iterator it=list.iterator();
if(it.hasNext()){
isExist=true;
}
ts.commit();
session.close();
return isExist;
}
//判断手机号是否存在
public boolean isMobileExist(String mobilenumber) {
boolean isExist=false;
Session session=factory.openSession();
Transaction ts=session.beginTransaction();
Query query=session.createQuery("from Tmobiles t where t.mobileNumber='"+mobilenumber+"'");
List list=query.list();
Iterator it=list.iterator();
if(it.hasNext()){
isExist=true;
}
ts.commit();
session.close();
return isExist;
}
// get/set方法在spring注入时使用
public SessionFactory getFactory() {
return factory;
}
public void setFactory(SessionFactory factory) {
this.factory = factory;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
基于java的移动ssh项目(struts+spring+hibernate+oracle).zip (166个子文件)
AdminOperatorDAOImp.class 5KB
AdminOperatorImp.class 4KB
OperatorDAOImp.class 3KB
AddUserAction.class 3KB
AddCustomerAction.class 3KB
AddOperatorAction.class 3KB
AbstractTcustomer.class 2KB
EditChargeAction.class 2KB
EditChargeRuleAction.class 2KB
HibernateSessionFactory.class 2KB
ResourceAction.class 2KB
LoginAction.class 2KB
AddCustomerForm.class 2KB
LoginDAOImp.class 2KB
SecondFilter.class 2KB
AbstractTmobiles.class 2KB
AbstractTchargeRuleId.class 2KB
AbstractTuser.class 2KB
OperatorImp.class 2KB
FirstFilter.class 2KB
AddOperatorForm.class 2KB
AbstractTcharge.class 2KB
AbstractToperator.class 2KB
ResourceForm.class 1KB
AddUserForm.class 1KB
EditChargeForm.class 1KB
EditChargeRuleForm.class 1KB
Test.class 1KB
LoginForm.class 1KB
EncodingFilter.class 1KB
AbstractTchargeRule.class 1KB
LoginImp.class 769B
Tcustomer.class 713B
Tmobiles.class 667B
Toperator.class 614B
TchargeRule.class 596B
Tuser.class 571B
Tcharge.class 548B
TchargeRuleId.class 538B
IAdminOperator.class 413B
IAdminOperatorDAO.class 406B
IOperator.class 301B
IOperatorDAO.class 285B
ILoginDAO.class 179B
ILogin.class 178B
.classpath 1KB
style.css 3KB
index_04.gif 53KB
index_01.gif 35KB
index_06.gif 16KB
index_02.gif 8KB
logo.gif 8KB
pic04.gif 7KB
pic05.gif 7KB
pic03.gif 6KB
pic01.gif 6KB
pic02.gif 6KB
index_03.gif 5KB
index_05.gif 3KB
Arrow1.gif 104B
blank(1).gif 43B
blank.gif 43B
spacer.gif 43B
index.html 2KB
spring.jar 1.84MB
classes12.jar 1.14MB
classes12.jar 1.14MB
struts.jar 486KB
commons-collections.jar 161KB
commons-beanutils.jar 116KB
commons-digester.jar 107KB
jakarta-oro.jar 64KB
commons-lang.jar 62KB
commons-validator.jar 46KB
commons-logging.jar 31KB
commons-fileupload.jar 22KB
struts-legacy.jar 10KB
AdminOperatorDAOImp.java 4KB
AddCustomerForm.java 3KB
AdminOperatorImp.java 3KB
AddCustomerAction.java 3KB
HibernateSessionFactory.java 3KB
AbstractTcustomer.java 3KB
OperatorDAOImp.java 3KB
AddUserAction.java 2KB
AddOperatorForm.java 2KB
AbstractTchargeRuleId.java 2KB
AddOperatorAction.java 2KB
EditChargeRuleAction.java 2KB
EditChargeAction.java 2KB
LoginAction.java 2KB
AddUserForm.java 2KB
ResourceForm.java 2KB
ResourceAction.java 2KB
AbstractTmobiles.java 2KB
AbstractTuser.java 2KB
EditChargeForm.java 2KB
AbstractToperator.java 2KB
LoginForm.java 2KB
EditChargeRuleForm.java 2KB
共 166 条
- 1
- 2
资源评论
心悦蛋糕
- 粉丝: 163
- 资源: 883
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功