基于SSM的城市商业银行农村信用社信贷贷款管理系统(javaweb-php-asp.netC#-j2ee)包含预算管理利息复息计算统计分析查询

 

目录

 

 

1 概述

2 数据库表

3 关键代码

4 效果演示

 

---

 

1 概述

 

 

系统最终实现了：系统管理(系统属性、管理员维护、公告管理、留言管理、修改密码)，客户管理（客户管理、添加客户），贷款审批（贷款申请、贷款申请添加、贷款审核、贷款审批查询），贷后管理（贷款发放、贷款发放查询、贷款归还、贷款归还查询、贷款逾期），利息管理（计算利息统计、利息收息统计），业务管理（贷款预算、货款统计）等主要功能模块。

2 数据库表

 

 用户信息表

字段名	类型	长度	说明
Id	Int	4	编号（主键）
Name	varchar	20	用户名
Psaaword	varchar	30	密码
Juesename	varchar	50	角色名称
Status	varchar	30	状态

 客户表

字段名	类型	长度	说明
Id	Int	4	编号（主键）
Name	varchar	8	客户名
Leixing	varchar	20	类型
Address	varchar	50	地址
Postcard	varchar	20	邮编
Tel	varchar	20	电话
Idcard	Int	4	身份证号
Email	varchar	20	邮箱

 贷款信息表

字段名	类型	长度	说明
Id	Int	4	编号（主键）
Cos-id	Int	4	客户编号（外键）
LoanType	varchar	20	贷款类型
ApplyDate	Datetime	8	申请时间
Qixian	Datetime	8	期限
Lilv	varchar	50	利率
ApplyAmount	Float	8	申请金额

3 关键代码

 

package com.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.directwebremoting.WebContext;
import org.directwebremoting.WebContextFactory;

import com.dao.DB;
import com.orm.TAdmin;
import com.orm.TShenhe;
import com.orm.TShenqin;
import com.service.liuService;

public class shenhe_servlet extends HttpServlet
{ 
	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
	{
		String type=req.getParameter("type");
		
		
		
		if(type.endsWith("shenheFafang"))
		{
			shenheFafang(req, res);
		}
		
		if(type.endsWith("shenheMana"))
		{
			shenheMana(req, res);
		}
		if(type.endsWith("shenheSearch"))
		{
			shenheSearch(req, res);
		}
		if(type.endsWith("shenheDel"))
		{
			shenheDel(req, res);
		}
		
	}
	
	
	
	
	

	public void shenheFafang(HttpServletRequest req,HttpServletResponse res)
	{

		int id=Integer.parseInt(req.getParameter("id"));
		int shenqinid=Integer.parseInt(req.getParameter("shenqinid"));
			
		String status="已发放";
		String sql="update t_shenqin set status=? where  id="+shenqinid;
		Object[] params={status};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
	
		
		String sql1="update t_shenhe set status=? where id="+id;
		Object[] params1={status};
		DB mydb1=new DB();
		mydb1.doPstm(sql1, params1);
		mydb1.closed();
		
	
		
	
		
		
		
		
		//int shenheid=id;
		String fafangriqi=req.getParameter("fafangriqi");
		String jine=req.getParameter("jine");
		
		status="未归还";
	
		
		HttpSession session = req.getSession();
		TAdmin admin=(TAdmin)session.getAttribute("admin");
		int adminid=admin.getUserId();
		
		
		//添加到发放表
		 sql="insert into t_fafang (`shenqinid`, `fafangriqi`, `jine`, `adminid`,  `status`, `del`)  values(?, ?, ?, ?, ?, ?)";
		 Object[]  params2={shenqinid, fafangriqi, jine,  adminid, status,"no"};
		 mydb=new DB();
		mydb.doPstm(sql, params2);
		mydb.closed();
			
		
		
		
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "shenhe?type=shenheMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	
	
	public void shenheDel(HttpServletRequest req,HttpServletResponse res)
	{
		int id=Integer.parseInt(req.getParameter("id"));
		
		String sql="update t_shenhe set del=? where id=?";
		Object[] params={"yes",id};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "shenhe?type=shenheMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	
	
	
	
	
	
	
	public void shenheMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		String page1=req.getParameter("page");
		if(page1==null){
			page1="1";
		}
		//分页设置
		int EVERYPAGENUM=10;//每页条数
		int page=Integer.parseInt(page1);   //传递过来的当前页
		int cou = 1;//得到信息总数	
		int pagecount=1;  //总页数
		String sql1="select count(*) as cou from t_shenhe where del='no'";
		Object[] params1={};
		DB mydb1=new DB();
		try
		{
			mydb1.doPstm(sql1, params1);
			ResultSet rs=mydb1.getRs();
			while(rs.next())
			{
			cou= rs.getInt("cou");
			}
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb1.closed();
		
		
		
		if (cou % EVERYPAGENUM == 0) {
			pagecount= cou / EVERYPAGENUM;
        } else {
        	pagecount=cou / EVERYPAGENUM + 1;
        }	
		
		
		
		
		
		
		req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);	
		req.setAttribute("page", page);
		req.setAttribute("cou", cou);
		req.setAttribute("pagecount", pagecount);
		
		
		
		List shenheList=new ArrayList();
		String sql="select t_shenhe.*,t_shenqin.kehuid from t_shenhe,t_shenqin where t_shenhe.del='no' and t_shenhe.shenqinid=t_shenqin.id";
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			 for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
	                rs.next();
	            }
	            for (int t = 0; t < EVERYPAGENUM; t++) {
	                if (rs.next()) {
				TShenhe shenhe=new TShenhe();
				shenhe.setId(rs.getString("id"));
				
				shenhe.setShenheriqi(rs.getString("shenheriqi"));
				shenhe.setJine(rs.getString("jine"));
				shenhe.setLilu(rs.getString("lilu"));
				shenhe.setAdminid(rs.getString("adminid"));
				shenhe.setRemark(rs.getString("remark"));
				shenhe.setStatus(rs.getString("status"));
				shenhe.setShenqinid(rs.getString("shenqinid"));
				
				
			
				
				

				shenhe.setKehuname(liuService.getKehuName(rs.getInt("kehuid")));
				
				shenheList.add(shenhe);
	                } else {
	                    break; //减少空循环的时间
	                }
	            }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("shenheList", shenheList);
		req.getRequestDispatcher("admin/shenhe/shenheMana.jsp").forward(req, res);
	}
	
	public void shenheSearch(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		String page1=req.getParameter("page");
		if(page1==null){
			page1="1";
		}
		//分页设置
		int EVERYPAGENUM=10;//每页条数
		int page=Integer.parseInt(page1);   //传递过来的当前页
		int cou = 1;//得到信息总数	
		int pagecount=1;  //总页数
		String sql1="select count(*) as cou from t_shenhe " +
				" left join t_shenqin on t_shenqin.id=t_shenhe.shenqinid" +
				" left join t_kehu on t_shenqin.kehuid=t_kehu.id where t_shenhe.del='no'";
		String key=req.getParameter("name");
		
		if(key!=null)sql1+=" and t_kehu.name like '%"+key+"%'";
	Object[] params1={};
		DB mydb1=new DB();
		try
		{
			mydb1.doPstm(sql1, params1);
			ResultSet rs=mydb1.getRs();
			while(rs.next())
			{
			cou= rs.getInt("cou");
			}
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb1.closed();
		
		
		
		if (cou % EVERYPAGENUM == 0) {
			pagecount= cou / EVERYPAGENUM;
        } else {
        	pagecount=cou / EVERYPAGENUM + 1;
        }	
		
		
		
		
		
		
		req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);	
		req.setAttribute("page", page);
		req.setAttribute("cou", cou);
		req.setAttribute("pagecount", pagecount);
		
		
		
		List shenheList=new ArrayList();
		String sql="select t_shenhe.*,t_shenqin.kehuid  from t_shenhe " +
				" left join t_shenqin on t_shenqin.id=t_shenhe.shenqinid" +
				" left join t_kehu on t_shenqin.kehuid=t_kehu.id where t_shenhe.del='no'";
		if(key!=null)sql+=" and t_kehu.name like '%"+key+"%'";
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			 for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
	                rs.next();
	            }
	            for (int t = 0; t < EVERYPAGENUM; t++) {
	                if (rs.next()) {
				TShenhe shenhe=new TShenhe();
				shenhe.setId(rs.getString("id"));
				
				shenhe.setShenheriqi(rs.getString("shenheriqi"));
				shenhe.setJine(rs.getString("jine"));
				shenhe.setLilu(rs.getString("lilu"));
				shenhe.setAdminid(rs.getString("adminid"));
				shenhe.setRemark(rs.getString("remark"));
				shenhe.setStatus(rs.getString("status"));
				shenhe.setShenqinid(rs.getString("shenqinid"));
				
				
			
				
				

				shenhe.setKehuname(liuService.getKehuName(rs.getInt("kehuid")));
				
				shenheList.add(shenhe);
	                } else {
	                    break; //减少空循环的时间
	                }
	            }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("shenheList", shenheList);
		req.setAttribute("name", key);
		req.getRequestDispatcher("admin/shenhe/shenheSearch.jsp").forward(req, res);
	}
	
	
	
	public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
	{
		RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
		try 
		{
		    dispatch.forward(request, response);
		    return;
		} 
		catch (ServletException e) 
		{
                    e.printStackTrace();
		} 
		catch (IOException e) 
		{
			
		    e.printStackTrace();
		}
	}
	public void init(ServletConfig config) throws ServletException 
	{
		super.init(config);
	}
	
	public void destroy() 
	{
		
	}
}

4 效果演示