目录
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 | 身份证号 |
| 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 效果演示