jobbean.java
来自「就业管理系统 源代码 可以运行 没有错误」· Java 代码 · 共 837 行 · 第 1/2 页
JAVA
837 行
package com.bean;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;
import com.util.Constant;
import com.util.DBO;
/**
* 会员中心求职招聘信息发布 修改 删除
* 管理员分页查询 锁定 删除
*/
public class JobBean {
private List list;
private ResultSet rs;
private String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
private int EVERYPAGENUM = 0;
private int count = -1;
private int qq = 0;
//招聘显示分页sql
private String sql="select count(*) from fz_job where ifhide!='0' ";
private String sql2="select id,need,num,danwei,linkman,tel,pay,ifhide,member,type,addtime from fz_job where ifhide!='0' order by id desc ";
//招聘锁定分页sql
private String sql3="select count(*) from fz_job where ifhide='0' ";
private String sql4="select id,need,num,danwei,linkman,tel,pay,ifhide,member,type,addtime from fz_job where ifhide='0' order by id desc ";
// 求职显示分页sql
private String qsql="select count(*) from fz_job2 where ifhide!='0' ";
private String qsql2="select id,job,school,sex,linkman,tel,sex,ifhide,member,type,addtime from fz_job2 where ifhide!='0' order by id desc ";
//求职锁定分页sql
private String qsql3="select count(*) from fz_job2 where ifhide='0' ";
private String qsql4="select id,job,school,sex,linkman,tel,sex,ifhide,member,type,addtime from fz_job2 where ifhide='0' order by id desc ";
public void setEVERYPAGENUM(int EVERYPAGENUM){
this.EVERYPAGENUM=EVERYPAGENUM;
}
public int getPageCount() { //得到共多少页（根据每页要显示几条信息）
if (count % EVERYPAGENUM == 0) {
return count / EVERYPAGENUM;
} else {
return count / EVERYPAGENUM + 1;
}
}
/***************************************************
*
* 管理员后台招聘正常分页 删除 锁定 解锁
********************************************************/
// //////////////////////////////////////////////////////////////////////////普通正常显示招聘分页
public int getMessageCount() {//招聘分页 //得到信息总数
DBO dbo=new DBO();
dbo.open();
try {
rs = dbo.executeQuery(sql);
rs.next();
count = rs.getInt(1);
return count;
} catch (SQLException ex) {
ex.printStackTrace();
return 0;
} finally {
dbo.close();
}
}
public List getMessage(int page) {//招聘分页 //得到每页要显示的信息
DBO dbo=new DBO();
dbo.open();
List list = new ArrayList();
try {
rs = dbo.executeQuery(sql2);
for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
rs.next();
}
for (int t = 0; t < EVERYPAGENUM; t++) {
if (rs.next()) {
qq++;
List list2=new ArrayList();
list2.add(rs.getInt(1));
list2.add(rs.getString(2));
list2.add(rs.getString(3));
list2.add(rs.getString(4));
list2.add(rs.getString(5));
list2.add(rs.getString(6));
list2.add(rs.getString(7));
list2.add(rs.getString(8));
list2.add(rs.getString(9));
list2.add(rs.getString(10));
list2.add(rs.getString(11));
list.add(list2);
} else {
break; //减少空循环的时间
}
}
return list;
} catch (SQLException ex) {
ex.printStackTrace();
return list;
} finally {
dbo.close();
}
}
// //////////////////////////////////////////////////////////////////////////普通正常显示招聘分页
public int getMessageCountCloseJob1() {//招聘分页 //得到信息总数
DBO dbo=new DBO();
dbo.open();
try {
rs = dbo.executeQuery(sql3);
rs.next();
count = rs.getInt(1);
return count;
} catch (SQLException ex) {
ex.printStackTrace();
return 0;
} finally {
dbo.close();
}
}
public List getMessageCloseJob1(int page) {//招聘分页 //得到每页要显示的信息
DBO dbo=new DBO();
dbo.open();
List list = new ArrayList();
try {
rs = dbo.executeQuery(sql4);
for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
rs.next();
}
for (int t = 0; t < EVERYPAGENUM; t++) {
if (rs.next()) {
qq++;
List list2=new ArrayList();
list2.add(rs.getInt(1));
list2.add(rs.getString(2));
list2.add(rs.getString(3));
list2.add(rs.getString(4));
list2.add(rs.getString(5));
list2.add(rs.getString(6));
list2.add(rs.getString(7));
list2.add(rs.getString(8));
list2.add(rs.getString(9));
list2.add(rs.getString(10));
list2.add(rs.getString(11));
list.add(list2);
} else {
break; //减少空循环的时间
}
}
return list;
} catch (SQLException ex) {
ex.printStackTrace();
return list;
} finally {
dbo.close();
}
}
///删除
public int delJob1(int id[]){
DBO dbo=new DBO();
dbo.open();
try{
for(int i = 0;i<id.length;i++){
dbo.executeUpdate("delete from fz_job where id = '"+id[i]+"'");
}
return Constant.SUCCESS;
}catch(Exception e){
e.printStackTrace();
return Constant.SYSTEM_ERROR;
}finally{
dbo.close();
}
}
//锁定
public int closeJob1(int id){
String sql = "update fz_job set ifhide='0' where id='"+id+"'";
DBO dbo=new DBO();
dbo.open();
try{
int i = dbo.executeUpdate(sql);
if(i == 1)
return Constant.SUCCESS;
else
return Constant.SYSTEM_ERROR;
}catch(Exception e){
e.printStackTrace();
return Constant.SYSTEM_ERROR;
}finally{
dbo.close();
}
}
//解锁
public int openJob1(int id){
String sql = "update fz_job set ifhide='1' where id='"+id+"'";
DBO dbo=new DBO();
dbo.open();
try{
int i = dbo.executeUpdate(sql);
if(i == 1)
return Constant.SUCCESS;
else
return Constant.SYSTEM_ERROR;
}catch(Exception e){
e.printStackTrace();
return Constant.SYSTEM_ERROR;
}finally{
dbo.close();
}
}
/***************************************************
*
* 管理员后台求职分页 删除 锁定 解锁
********************************************************/
// //////////////////////////////////////////////////////////////////////////普通正常显示招聘分页
public int getMessageCountJob2() {//招聘分页 //得到信息总数
DBO dbo=new DBO();
dbo.open();
try {
rs = dbo.executeQuery(qsql);
rs.next();
count = rs.getInt(1);
return count;
} catch (SQLException ex) {
ex.printStackTrace();
return 0;
} finally {
dbo.close();
}
}
public List getMessageJob2(int page) {//招聘分页 //得到每页要显示的信息
DBO dbo=new DBO();
dbo.open();
List list = new ArrayList();
try {
rs = dbo.executeQuery(qsql2);
for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
rs.next();
}
for (int t = 0; t < EVERYPAGENUM; t++) {
if (rs.next()) {
qq++;
List list2=new ArrayList();
list2.add(rs.getInt(1));
list2.add(rs.getString(2));
list2.add(rs.getString(3));
list2.add(rs.getString(4));
list2.add(rs.getString(5));
list2.add(rs.getString(6));
list2.add(rs.getString(7));
list2.add(rs.getString(8));
list2.add(rs.getString(9));
list2.add(rs.getString(10));
list2.add(rs.getString(11));
list.add(list2);
} else {
break; //减少空循环的时间
}
}
return list;
} catch (SQLException ex) {
ex.printStackTrace();
return list;
} finally {
dbo.close();
}
}
// //////////////////////////////////////////////////////////////////////////普通正常显示招聘分页
public int getMessageCountCloseJob2() {//招聘分页 //得到信息总数
DBO dbo=new DBO();
dbo.open();
try {
rs = dbo.executeQuery(qsql3);
rs.next();
count = rs.getInt(1);
return count;
} catch (SQLException ex) {
ex.printStackTrace();
return 0;
} finally {
dbo.close();
}
}
public List getMessageCloseJob2(int page) {//招聘分页 //得到每页要显示的信息
DBO dbo=new DBO();
dbo.open();
List list = new ArrayList();
try {
rs = dbo.executeQuery(qsql4);
for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
rs.next();
}
for (int t = 0; t < EVERYPAGENUM; t++) {
if (rs.next()) {
qq++;
List list2=new ArrayList();
list2.add(rs.getInt(1));
list2.add(rs.getString(2));
list2.add(rs.getString(3));
list2.add(rs.getString(4));
list2.add(rs.getString(5));
list2.add(rs.getString(6));
list2.add(rs.getString(7));
list2.add(rs.getString(8));
list2.add(rs.getString(9));
list2.add(rs.getString(10));
list2.add(rs.getString(11));
list.add(list2);
} else {
break; //减少空循环的时间
}
}
return list;
} catch (SQLException ex) {
ex.printStackTrace();
return list;
} finally {
dbo.close();
}
}
///删除
public int delJob2(int id[]){
DBO dbo=new DBO();
dbo.open();
try{
for(int i = 0;i<id.length;i++){
dbo.executeUpdate("delete from fz_job2 where id = '"+id[i]+"'");
}
return Constant.SUCCESS;
}catch(Exception e){
e.printStackTrace();
return Constant.SYSTEM_ERROR;
}finally{
dbo.close();
}
}
//锁定
public int closeJob2(int id){
String sql = "update fz_job2 set ifhide='0' where id='"+id+"'";
DBO dbo=new DBO();
dbo.open();
try{
int i = dbo.executeUpdate(sql);
if(i == 1)
return Constant.SUCCESS;
else
return Constant.SYSTEM_ERROR;
}catch(Exception e){
e.printStackTrace();
return Constant.SYSTEM_ERROR;
}finally{
dbo.close();
}
}
//解锁
public int openJob2(int id){
String sql = "update fz_job2 set ifhide='1' where id='"+id+"'";
DBO dbo=new DBO();
dbo.open();
try{
int i = dbo.executeUpdate(sql);
if(i == 1)
return Constant.SUCCESS;
else
return Constant.SYSTEM_ERROR;
}catch(Exception e){
e.printStackTrace();
return Constant.SYSTEM_ERROR;
}finally{
dbo.close();
}
}
/***************************************************
*
* 招聘
********************************************************/
//发布招聘信息
public int addJOB1(String need,String num,String danwei,String linkman,String tel,String place,String pay,String yxq,
String otherneed,String member,String type,int ifhide){
String sql = "insert fz_job(need,num,danwei,linkman,tel,place,pay,yxq,otherneed,member,type,addtime,ifhide,visit) " +
"values('"+need+"','"+num+"','"+danwei+"','"+linkman+"','"+tel+"','"+place+"','"+pay+"','"+yxq+"'," +
"'"+otherneed+"','"+member+"','"+type+"','"+date+"','"+ifhide+"','0')";
DBO dbo = new DBO();
dbo.open();
try{
int i = dbo.executeUpdate(sql);
if(i == 1)
return Constant.SUCCESS;
else
return Constant.SYSTEM_ERROR;
}catch(Exception e){
e.printStackTrace();
return Constant.SYSTEM_ERROR;
}finally{
dbo.close();
}
}
//修改招聘信息
public int upJOB1(int id,String need,String num,String danwei,String linkman,String tel,String place,String pay,String yxq,
String otherneed,int ifhide){
String sql = "update fz_job set need='"+need+"',num='"+num+"',danwei='"+danwei+"',linkman='"+linkman+"',tel='"+tel+"'," +
"place='"+place+"',pay='"+pay+"',yxq='"+yxq+"',otherneed='"+otherneed+"',ifhide='"+ifhide+"' where id='"+id+"'";
DBO dbo = new DBO();
dbo.open();
try{
int i = dbo.executeUpdate(sql);
if(i == 1)
return Constant.SUCCESS;
else
return Constant.SYSTEM_ERROR;
}catch(Exception e){
e.printStackTrace();
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?