杭州外服人才在线－

<%/** * Company:pdfesc * @author:dengfeng * @date:2001-12-4 * @Modify:wangyun * @Date :2002-04-16 */%> <%@ page errorPage ="/system_f.jsp"%> <%@ page import="fs_com.info.*,fs_com.fesc.*,java.lang.System"%> <%@ page import="fs_com.utils.*,java.sql.*,java.util.*,fs_com.resume.*,fs_com.china_bank.*"%> <%@ page session="true" %> <% if ((String)session.getValue("e_fesc")==null) response.sendRedirect("/program/msg.jsp?path=/default_bank.jsp&msg_type=failure&msg=您的身份标志消失，请重新登录后再试"); %> <%@ include file="/notice/getNotice.jsp"%> <%@ page import="fs_com.utils.*,java.util.*,java.sql.*,fs_com.resume.*,fs_com.info.*" %> <%@ page contentType="text/html;charset=ISO8859_1"%> <%@ page session="true" %> <%! String user_name,sql_str,if_qn,bank_id,bank_name; ResultSet sql_result=null; int login_time; String tcolor="",scolor="",mcolor=""; int pos1=0,pos2=0,pos3=0; %> <% bank_id=(String)session.getValue("bank_id"); String bank_id_s=CTools.null2Blank(request.getParameter("bank_id")); Vector v_bank; int i_size; Common obj = new Common(); if (!bank_id_s.equals("")){ v_bank=dengfeng_SQL.getBank(bank_id_s); i_size = v_bank.size(); if (i_size==1) { bank_name=CTools.null2Blank(obj.Vector2String(v_bank,0,0)); bank_id=bank_id_s; } session.putValue("bank_id",bank_id); session.putValue("bank_name",bank_name); } bank_id=CTools.null2Blank(bank_id); bank_name=(String)session.getValue("bank_name"); bank_name=CTools.null2Blank(bank_name); //CSQL login_sql=new CSQL(); //CSQL objSQL=new CSQL(); Connection cnn=CSQL.getConnection(); Statement stmt=cnn.createStatement(); Statement stmt1=cnn.createStatement(); Statement stmt2=cnn.createStatement(); ResultSet rst,zhiwei_rst; String sqlStr = "select tcolor,scolor,mcolor,pos1,pos2,pos3 from bank where id = "+bank_id; rst = stmt.executeQuery(sqlStr); if(rst.next()){ tcolor = CTools.null2Blank(rst.getString("tcolor")); scolor= CTools.null2Blank(rst.getString("scolor")); mcolor = CTools.null2Blank(rst.getString("mcolor")); pos1 = Integer.parseInt(CTools.null2Blank(rst.getString("pos1"))); pos2 = Integer.parseInt(CTools.null2Blank(rst.getString("pos2"))); pos3 = Integer.parseInt(CTools.null2Blank(rst.getString("pos3"))); } CResume objResume=new CResume(); int count; user_name=(String)session.getValue("e_fesc"); user_name=CTools.null2Blank(user_name); sql_str="select login_time from p_users where userid='"+user_name+"'"; sql_result=stmt.executeQuery(sql_str); if (sql_result.next()) { login_time=sql_result.getInt("login_time"); } //简历被浏览次数 int viewtimes=objResume.getResumeviewTimes(user_name); //简历被浏览公司 String viewComp=CTools.null2Blank(objResume.getResumeviewComp(user_name)); String temp; if(viewtimes==0) { temp="您的简历已经被浏览过"+viewtimes+"次"; } else{ temp="您的简历最后一次被"+viewComp+"浏览，已被浏览过"+viewtimes+"次"; } String sql_str,strSql; strSql="select zhiwei,zhiweivalue from fesc.zhiwei"; zhiwei_rst=null; zhiwei_rst=stmt.executeQuery(strSql); //职位 String strZhiwei=""; while(zhiwei_rst.next()) { strZhiwei+=zhiwei_rst.getString("zhiwei")+","+zhiwei_rst.getString("zhiweivalue")+","; } if(strZhiwei.lastIndexOf(",")>0) { strZhiwei=strZhiwei.substring(0,strZhiwei.length()-1); } String[] array_zhiwei=CTools.getArray(strZhiwei); %> 杭州外服人才在线－－杭州