📄 clientimpt.java
字号:
package com.jn0801.clientmanage;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import org.hibernate.Transaction;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.jn0801.common.UserInfo;
import com.jn0801.datadictionary.DataDictionary;
import com.jn0801.grademanage.Auditinguserlog;
import com.jn0801.login.systemuser.SystemuserBean;
import com.jn0801.operation.operationtype;
import com.jn0801.tools.DBConnection;
public class Clientimpt extends HibernateDaoSupport implements ClientInf{
/**
*
* 查询客户资料
*
*
* @param phone
* 电话号码
* @param area
* 地区
* @param userid
* 客户编号
* @return 客户的集合
*/
public List<UserInfo> listGradeRule(String phone, String area,int userid) {
List<UserInfo> list = new ArrayList<UserInfo>();
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String sql = "select * from userinfo where 1=1 ";
if(phone!=null)
sql = sql + " and phone = '" + phone + "'";
if(area!=null)
sql = sql + " and area = '" + area + "'";
if(userid!=-1)
sql = sql + " and userid = " + userid;
try {
conn = DBConnection.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()){
UserInfo userinfo = new UserInfo();
userinfo.setUserid(rs.getLong(1));
userinfo.setPhone(rs.getString(2));
userinfo.setIntegralsign(rs.getString(3));
userinfo.setUsername(rs.getString(4));
userinfo.setPapertype(rs.getString(5));
userinfo.setPaperid(rs.getString(6));
userinfo.setServetype(rs.getString(7));
userinfo.setArea(rs.getString(8));
userinfo.setCity(rs.getString(9));
userinfo.setBusinessroom(rs.getString(10));
userinfo.setPostaddress(rs.getString(11));
userinfo.setTel(rs.getString(12));
userinfo.setPostalcode(rs.getLong(13));
userinfo.setOptiontype(rs.getString(14));
userinfo.setMainoption(rs.getString(15));
userinfo.setRegtime(rs.getString(16));
userinfo.setOldoption(rs.getString(17));
userinfo.setIsgroupclient(rs.getLong(18));
userinfo.setUsergrade(rs.getString(19));
userinfo.setBootstrap(rs.getString(20));
userinfo.setIsmember(rs.getLong(21));
userinfo.setGetmembertime(rs.getString(22));
userinfo.setClientmanagerid(rs.getLong(23));
userinfo.setAddintegral(rs.getLong(24));
userinfo.setIntegrallosttime(rs.getString(25));
userinfo.setIslock(rs.getLong(26));
list.add(userinfo);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(conn!=null)
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return list;
}
/**
*
* 查询客户资料
*
*
* @param phone
* 电话号码
* @param area
* 地区
* @return 客户的集合
*/
public List<UserInfo> listGradeRule1(String phone, String area,HttpServletRequest request) {
List<UserInfo> list = new ArrayList<UserInfo>();
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
int rscount=0;
PageDAO pagedao = new PageDAO(request);
pagedao.setPagesize(20);
int pagesize = pagedao.getPagesize();
String sql1 = "select count(userid) from userinfo where 1=1 ";
if(phone!=null)
sql1 = sql1 + " and phone = '" + phone + "'";
if(area!=null)
sql1 = sql1 + " and area like '%" + area + "%'";
conn = DBConnection.getConnection();
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql1);
if(rs.next())
{
rscount=rs.getInt(1);
}
} catch (SQLException e1) {
// TODO 自动生成 catch 块
e1.printStackTrace();
}
System.out.println("总记录数"+rscount);
// 获取总记录数
pagedao.setRscount(rscount);
// 获取总页数
int pagecount = pagedao.getPageCount();
// 获取当前页
int currentpage = pagedao.getCurrentPage();
// 构建工具栏
String pagetool = pagedao.pagetool(PageDAO.BbsText);
request.setAttribute("pagetool", pagetool);
int prend=0;
int prstart=0;
prend=currentpage*pagesize;
prstart=(currentpage - 1) * pagesize+1;
String sql = "select * from(select t.* ,rownum as myrow from userinfo t where 1=1 ";
if(phone!=null)
sql = sql + " and phone = '" + phone + "'";
if(area!=null)
sql = sql + " and area like '%" + area + "%'";
if(prend!=-1)
{
sql = sql + " and rownum<="+prend+" order by t.userid desc"+")";
}
if(prstart!=-1)
{
sql = sql + " where myrow>="+prstart;
}
System.out.println(sql);
try {
conn = DBConnection.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()){
UserInfo userinfo = new UserInfo();
userinfo.setUserid(rs.getLong(1));
userinfo.setPhone(rs.getString(2));
userinfo.setIntegralsign(rs.getString(3));
userinfo.setUsername(rs.getString(4));
userinfo.setPapertype(rs.getString(5));
userinfo.setPaperid(rs.getString(6));
userinfo.setServetype(rs.getString(7));
userinfo.setArea(rs.getString(8));
userinfo.setCity(rs.getString(9));
userinfo.setBusinessroom(rs.getString(10));
userinfo.setPostaddress(rs.getString(11));
userinfo.setTel(rs.getString(12));
userinfo.setPostalcode(rs.getLong(13));
userinfo.setOptiontype(rs.getString(14));
userinfo.setMainoption(rs.getString(15));
userinfo.setRegtime(rs.getString(16));
userinfo.setOldoption(rs.getString(17));
userinfo.setIsgroupclient(rs.getLong(18));
userinfo.setUsergrade(rs.getString(19));
userinfo.setBootstrap(rs.getString(20));
userinfo.setIsmember(rs.getLong(21));
userinfo.setGetmembertime(rs.getString(22));
userinfo.setClientmanagerid(rs.getLong(23));
userinfo.setAddintegral(rs.getLong(24));
userinfo.setIntegrallosttime(rs.getString(25));
userinfo.setIslock(rs.getLong(26));
list.add(userinfo);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(conn!=null)
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return list;
}
/**
*
* 删除客户资料
*
*
* @param id
* 客户编号
* @return boolean
*/
public boolean deletemeet(int id) {
boolean tag = false;
Connection conn = DBConnection.getConnection();
Statement stmt = null;
String sql = "delete from userinfo where userid=" + id;
try {
conn.setAutoCommit(false);
stmt = conn.createStatement();
stmt.execute(sql);
conn.commit();
tag = true;
} catch (SQLException e) {
try {
conn.rollback();
} catch (SQLException e1) {
// TODO 自动生成 catch 块
e1.printStackTrace();
}
e.printStackTrace();
} finally {
try {
conn.setAutoCommit(true);
conn.close();
stmt.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
return tag;
}
/**
*
* 删除客户资料
*
*
* @param id
* 客户编号
* @return boolean
*/
public boolean deletemeetrow(int id) {
boolean tag = false;
Connection conn = DBConnection.getConnection();
Statement stmt = null;
String sql = "update userinfo set islock = 0 where userid" + id;
try {
conn.setAutoCommit(false);
stmt = conn.createStatement();
stmt.execute(sql);
conn.commit();
tag = true;
} catch (SQLException e) {
try {
conn.rollback();
} catch (SQLException e1) {
// TODO 自动生成 catch 块
e1.printStackTrace();
}
e.printStackTrace();
} finally {
try {
conn.setAutoCommit(true);
conn.close();
stmt.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
return tag;
}
/**
*
* 查询客户资料
*
*
* @param phone
* 电话号码
* @param area
* 地区
* @param city
* 城市
* @return 客户的集合
*/
public List<UserInfo> listGradeRule2(String phone, String area,String city,HttpServletRequest request) {
List<UserInfo> list = new ArrayList<UserInfo>();
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
int rscount=0;
PageDAO pagedao = new PageDAO(request);
pagedao.setPagesize(20);
int pagesize = pagedao.getPagesize();
String sql1 = "select count(userid) from userinfo where 1=1 ";
if(phone!=null && !phone.equals(""))
sql1 = sql1 + " and phone = '" + phone + "'";
if(area!=null && !area.equals(""))
sql1 = sql1 + " and area like '%" + area + "%'";
if(city!=null)
sql1 = sql1 + " and city like '%" + city + "%'";
System.out.println("总记录叔："+sql1);
conn = DBConnection.getConnection();
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql1);
if(rs.next())
{
rscount=rs.getInt(1);
}
} catch (SQLException e1) {
// TODO 自动生成 catch 块
e1.printStackTrace();
}
System.out.println("总记录数"+rscount);
// 获取总记录数
pagedao.setRscount(rscount);
// 获取总页数
int pagecount = pagedao.getPageCount();
// 获取当前页
int currentpage = pagedao.getCurrentPage();
// 构建工具栏
String pagetool = pagedao.pagetool(PageDAO.BbsText);
request.setAttribute("pagetool", pagetool);
int prend=0;
int prstart=0;
prend=currentpage*pagesize;
prstart=(currentpage - 1) * pagesize+1;
String sql = "select * from(select t.* ,rownum as myrow from userinfo t where 1=1 ";
if(phone!=null && !phone.equals(""))
sql = sql + " and phone = '" + phone + "'";
if(area!=null && !area.equals(""))
sql = sql + " and area like '%" + area + "%'";
if(city!=null)
sql = sql + " and city like '%" + city + "%'";
if(prend!=-1)
{
sql = sql + " and rownum<="+prend+" order by t.userid desc"+")";
}
if(prstart!=-1)
{
sql = sql + " where myrow>="+prstart;
}
System.out.println(sql);
try {
conn = DBConnection.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()){
UserInfo userinfo = new UserInfo();
userinfo.setUserid(rs.getLong(1));
userinfo.setPhone(rs.getString(2));
userinfo.setIntegralsign(rs.getString(3));
userinfo.setUsername(rs.getString(4));
userinfo.setPapertype(rs.getString(5));
userinfo.setPaperid(rs.getString(6));
userinfo.setServetype(rs.getString(7));
userinfo.setArea(rs.getString(8));
userinfo.setCity(rs.getString(9));
userinfo.setBusinessroom(rs.getString(10));
userinfo.setPostaddress(rs.getString(11));
userinfo.setTel(rs.getString(12));
userinfo.setPostalcode(rs.getLong(13));
userinfo.setOptiontype(rs.getString(14));
userinfo.setMainoption(rs.getString(15));
userinfo.setRegtime(rs.getString(16));
userinfo.setOldoption(rs.getString(17));
userinfo.setIsgroupclient(rs.getLong(18));
userinfo.setUsergrade(rs.getString(19));
userinfo.setBootstrap(rs.getString(20));
userinfo.setIsmember(rs.getLong(21));
userinfo.setGetmembertime(rs.getString(22));
userinfo.setClientmanagerid(rs.getLong(23));
userinfo.setAddintegral(rs.getLong(24));
userinfo.setIntegrallosttime(rs.getString(25));
userinfo.setIslock(rs.getLong(26));
list.add(userinfo);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(conn!=null)
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return list;
}
/**
*
* 查询客户资料
*
*
* @param phone
* 电话号码
* @param area
* 地区
* @param city
* 城市
* @param start
* 开始时间
* @param end
* 结束时间
* @return 客户的集合
*/
public List<UserInfo> listGradeRule3(String phone, String area,String city,String start,String end,HttpServletRequest request) {
List<UserInfo> list = new ArrayList<UserInfo>();
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
int rscount=0;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -