基于ssh的个人银行账户管理系统的设计与实现，一整套，工程，数据库文件，word，ppt，直接运行

package com.dao.impl; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.Date; import java.util.List; import javax.mail.Folder; import org.hibernate.Hibernate; import org.hibernate.HibernateException; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.Transaction; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.dao.indexDao; /** * All rights Reserved, Designed By www.kanq.com.cn * @Title: index.java * @Package com.action * @Description: TODO() * @author: XXQ-PC * @date: 201710231:19:25 * @version V1.0 * @Copyright: 2017 www.kanq.com.cn Inc. All rights reserved. * */ public class indexDaoImpl extends HibernateDaoSupport implements indexDao{ public List<Object[]> index(String userId,String userPwd){ Session session=null; Query query = null; List<Object[]> list = null; try { session = this.getSessionFactory().openSession(); String sql ="select count(*) as con from admin_user where userid='"+userId+"' and userpwd='"+userPwd+"' "; query = session.createSQLQuery(sql) .addScalar("con", Hibernate.STRING); list = query.list(); } catch (Exception e) { e.printStackTrace(); } finally { session.close(); } return list; } public List<Object[]> zfblogin(String userId, String userPwd){ Session session=null; Query query = null; List<Object[]> list = null; try { session = this.getSessionFactory().openSession(); String sql ="select count(*) as con from zfb where userid='"+userId+"' and password='"+userPwd+"' "; query = session.createSQLQuery(sql) .addScalar("con", Hibernate.STRING); list = query.list(); } catch (Exception e) { e.printStackTrace(); } finally { session.close(); } return list; } @SuppressWarnings({ "null", "unchecked" }) public List<List> userLogin(String userId, String userPwd){ Session session=null; Query query = null; Query query1 = null; List<Object[]> list = null; List<Object[]> list1 = null; List<List> list2 = new ArrayList<List>(); try { session = this.getSessionFactory().openSession(); String sql ="select count(*) as con from user_kh where idcard='"+userId+"' and loginpwd='"+userPwd+"' "; String sql1 ="select distinct username from user_kh where idcard='"+userId+"' and loginpwd='"+userPwd+"' "; query = session.createSQLQuery(sql) .addScalar("con", Hibernate.STRING); query1 = session.createSQLQuery(sql1) .addScalar("username", Hibernate.STRING); list = query.list(); list1 = query1.list(); list2.add(list); list2.add(list1); } catch (Exception e) { e.printStackTrace(); } finally { session.close(); } return list2; } public String register(String txtName, String txtIdCard, String txtBirthDate, String txtYhCard, String txtJe, String sex, String txtDate, String txtAge, String cxkkind, String txtTel, String txtloginpwd, String txtjypwd, String txtArea){ String flag = "开户成功"; Transaction tran = null; Session session = this.getSessionFactory().openSession(); try { tran = session.beginTransaction(); session.createSQLQuery("insert into user_kh values('"+txtName+"','"+txtIdCard+"','"+txtBirthDate+"','"+txtYhCard+"','"+txtJe+"','"+sex+"','"+txtDate+"','"+txtAge+"','"+cxkkind+"','"+txtTel+"','"+txtArea+"','"+txtloginpwd+"','"+txtjypwd+"','否')").executeUpdate(); tran.commit(); } catch (HibernateException e) { tran.rollback(); e.printStackTrace(); }finally{ session.close(); } return flag; } public String xyksq(String txtName, String txtIdCard, String txtYhCard, String txtDate, String txtxykz, String txtxyed, String txtjypwd){ String flag = "信用卡申请成功！"; Transaction tran = null; Session session = this.getSessionFactory().openSession(); try { tran = session.beginTransaction(); session.createSQLQuery("insert into user_xyk values('"+txtName+"','"+txtIdCard+"','"+txtYhCard+"','"+txtDate+"','"+txtxykz+"','"+txtxyed+"','"+txtjypwd+"','审核中',0,'否')").executeUpdate(); tran.commit(); } catch (HibernateException e) { tran.rollback(); e.printStackTrace(); }finally{ session.close(); } return flag; } public String ck(String kz, String kh, String je){ int kz1=Integer.parseInt(kz); String flag = "存款成功！"; Transaction tran = null; Session session=null; Query query = null; List<Object[]> list = null; session = this.getSessionFactory().openSession(); if(kz1==1||kz1==2){ try { String sql ="select ycje from user_kh where yhcard='"+kh+"'"; query = session.createSQLQuery(sql) .addScalar("ycje", Hibernate.STRING); list = query.list(); String ycje=list.toString(); ycje=ycje.substring(1,ycje.length()-1); float ycje1=Float.parseFloat(ycje); float je1=Float.parseFloat(je); float sumje=ycje1+je1; tran = session.beginTransaction(); session.createSQLQuery("update user_kh set ycje='"+sumje+"' where yhcard='"+kh+"'").executeUpdate(); tran.commit(); } catch (HibernateException e) { tran.rollback(); e.printStackTrace(); }finally{ session.close(); } } else{ try { String sql ="select ye from user_xyk where yhcard='"+kh+"'"; query = session.createSQLQuery(sql) .addScalar("ye", Hibernate.STRING); list = query.list(); String ye=list.toString(); ye=ye.substring(1,ye.length()-1); float ye1=Float.parseFloat(ye); float je1=Float.parseFloat(je); float sumje=ye1+je1; tran = session.beginTransaction(); session.createSQLQuery("update user_xyk set ye='"+sumje+"' where yhcard='"+kh+"'").executeUpdate(); tran.commit(); } catch (HibernateException e) { tran.rollback(); e.printStackTrace(); }finally{ session.close(); } } return flag; } public String zfbbd(String kh){ String flag = "绑定成功！"; Transaction tran = null; Session session = this.getSessionFactory().openSession(); try { tran = session.beginTransaction(); session.createSQLQuery("update user_kh set bdzfb='是' where yhcard='"+kh+"'").executeUpdate(); session.createSQLQuery("update user_xyk set bdzfb='是' where yhcard='"+kh+"'").executeUpdate(); tran.commit(); } catch (HibernateException e) { tran.rollback(); e.printStackTrace(); }finally{ session.close(); } return flag; } public String zz(String time, String zckh, String zckhye, String zrkh, String zrkhxm, String zzje, String useridcard){ String flag = "转账成功！"; Transaction tran = null; Session session=null; Query query = null; List<Object[]> list = null; session = this.getSessionFactory().openSession(); try { String sql ="select ycje from user_kh where yhcard='"+zrkh+"' and username='"+zrkhxm+"'"; query = session.createSQLQuery(sql) .addScalar("ycje", Hibernate.STRING); list = query.list(); String zrycje=list.toString(); zrycje=zrycje.substring(1,zrycje.length()-1); float zrycje1=Float.parseFloat(zrycje); float zcycje=Float.parseFloat(zckhye); float zcje=Float.parseFloat(zzje); float zcsumje=zcycje-zcje; float zrsumje=zrycje1+zcje; tran = session.beginTransaction(); session.createSQLQuery("update user_kh set ycje='"+zcsumje+"' where yhcard='"+zckh+"' and idcard='"+useridcard+"'").executeUpdate(); session.createSQLQuery("update user_kh set ycje='"+zrsumje+"' where yhcard='"+zrkh+"' and username='"+zrkhxm+"'").executeUpdate(); session.createSQLQuery("insert into zz values('"+zckh+"','"+zzje+"','"+zcsumje+"','"+zrkh+"','"+zrkhxm+"','"+time+"','"