String query = null;
			PreparedStatement ps = null;
			ResultSet res = null;		
			try
			{
				query = "select * from RESUME where user_id="+info[2]+" and job_id="+info[0];
			    ps = this.conn.prepareStatement(query);
				res = ps.executeQuery();
					if(res.next())
					{
						ps = null;												
						if(intro == null || intro.equals(""))
			    			query = "update RESUME set intro='' where id="+String.valueOf(res.getInt("id"));
						else
			    			query = "update RESUME set intro='"+intro+"' where id="+String.valueOf(res.getInt("id"));						
					    
					    ps = this.conn.prepareStatement(query);
					    ps.executeUpdate();
					    ps.close();
					    res.close();
						return true;
					}
					else
					{
						ps = null;
						res = null;
						String [] name = new String[3];
						name = this.sendGetInfo(info[2],info[0]);
						query = "select MAX(id) from RESUME";
						int idd = 0;
						ps = this.conn.prepareStatement(query);
						res = ps.executeQuery();
						if(res.next())
						{
							idd = res.getInt(1) + 1;
						}
						ps = null;
						res = null;
			    		query = "insert into RESUME(id,user_id,job_id,cop_name,job_name,intro) values(?,?,?,?,?,?)";
					    ps = this.conn.prepareStatement(query);
					    ps.setInt(1,idd);
					    ps.setInt(2,Integer.parseInt(info[2]));
					    ps.setInt(3,Integer.parseInt(info[0]));
					    ps.setString(4,name[0]);
					    ps.setString(5,name[1]);
					    ps.setString(6,intro);
					    
					    ps.executeUpdate();    
						return true;
					}
			}
			catch(Exception e)
			{
			    this.error = e.toString();
			    e.printStackTrace();
			    return false;
			}
			finally
			{
				try
				{
					ps.close();
					res.close();
				}
				catch(Exception ee)
				{
					
				}
			}
	}
	
	public String[] reGetInfo(String id)
	{
	    String query = "select b.cop_name,b.job_name,a.intro from Reply a,Resume b where a.id="+id+" and b.id = a.resume_id";
			String[] info = new String[3];
			try
			{
			    PreparedStatement ps = this.conn.prepareStatement(query);
					ResultSet res = ps.executeQuery();
					//int i = 0;
					if(res.next())
					{
						info[0] = res.getString("cop_name");
						info[1] = res.getString("job_name");
						info[2] = res.getString(3);
						ps.close();
						return info;
					}
					else
					{
					    return null;
					}
			}
			catch(Exception e)
			{
			    this.error = e.toString();
					return null;
			}
	}
	
	public boolean reing(String[] info)
	{
	    String id = info[0];
			String re_cont = this.HtmlSpecialChars(info[1]);
			if(id == null || id.equals("") || this.username == null || this.username.equals(""))
			{
			    return false;
			}
			
			String query = null;
			if(re_cont == null || re_cont.equals(""))
			    query = "update JOBS set re_cont='',re=0 where id="+id+" and belongto='"+this.username+"'";			
			else
			    query = "update JOBS set re_cont='"+re_cont+"',re=1 where id="+id+" and belongto='"+this.username+"'";
					
			try
			{
			    PreparedStatement ps = this.conn.prepareStatement(query);
					int res = ps.executeUpdate();
					if(res == 1)
					{
					    ps.close();
							return true;
					}
					else
					{
					    ps.close();
							return false;
					}
			}
			catch(Exception e)
			{
			    this.error = e.toString();
			    return false;
			}
	}
	
	public ResultSet getAllInfo(String id)
	{
	    String query = "select * from JOBS where id="+id;
			try
			{
			    PreparedStatement ps = this.conn.prepareStatement(query);
					ResultSet res = ps.executeQuery();
					return res;
			}
			catch(Exception e)
			{
			    this.error = e.toString();
					return null;
			}
	}
	
	public boolean editJob(String id,String job_name,String job_mann,String job_addr,String job_num,String job_get,String job_sta,String job_end,String job_age1,String job_age2,String job_grad,String job_lang,String job_expe,String job_oget,String job_odem)
	{
	    try
			{
			    PreparedStatement ps = this.conn.prepareStatement("UPDATE JOBS set job_name=?,jop_mann=?,job_addr=?,job_num=?,job_get=?,job_sta=?,job_end=?,job_grad=?,job_age1=?,job_age2=?,job_lang=?,job_expe=?,job_odem=?,job_oget=? where id=?");
					ps.setString(1,job_name);
					ps.setInt(2,Integer.parseInt(job_mann));
					ps.setString(3,job_addr);
					ps.setInt(4,Integer.parseInt(job_num));
					ps.setString(5,job_get);
					ps.setInt(6,Integer.parseInt(job_sta));
					ps.setInt(7,Integer.parseInt(job_end));
					ps.setInt(8,Integer.parseInt(job_grad));
          			ps.setInt(9,Integer.parseInt(job_age1));
					ps.setInt(10,Integer.parseInt(job_age2));
					ps.setInt(11,Integer.parseInt(job_lang));
					ps.setInt(12,Integer.parseInt(job_expe));
					ps.setString(13,job_odem);
					ps.setString(14,job_oget);
					ps.setInt(15,Integer.parseInt(id));
			
    	    int ok = ps.executeUpdate();
		      if(ok == 1)
    	    {
    	        ps.close();
    	    		this.conn.close();
    	    		return true;
    	    }
		      else
    	    {
    	        ps.close();
    	    		this.conn.close();
    	        return false;
    	    }
			}
			catch(Exception e)
			{
			    this.error = e.toString();
					return false;
			}
	}

	public int ifSend(String job_id,String user_id)
	{
		ResultSet rs = null;
		Statement st = null;
		try
		{
			String sql = "select * from RESUME a where a.job_id = "+job_id+" and a.user_id = "+user_id;
			st = this.conn.createStatement();
			rs = st.executeQuery(sql);
			if(rs.next())
			{
				st.close();
				rs.close();
				return 1;
			}
			else
			{
				st.close();
				rs.close();
				return 0;
			}
		}
		catch(Exception e)
		{			
			return 0;
		}
	}
	
	public int ifReply(String job_id,String user_id)
	{
		ResultSet rs = null;
		Statement st = null;
		try
		{
			String sql = "select * from REPLY a where a.job_id = "+job_id+" and a.user_id = "+user_id;
			st = this.conn.createStatement();
			rs = st.executeQuery(sql);
			if(rs.next())
			{

				st.close();
				rs.close();
				return 1;
			}
			else
			{

				st.close();
				rs.close();
				return 0;
			}
		}
		catch(Exception e)
		{
			return 0;
		}
	}
	
	public int addUser(userTable utable)
	{
		if(utable == null)
		{
			return 0;
		}
		else
		{
			ResultSet rs =null;
			try
			{
				String sql = "select MAX(id) from USERS";
				PreparedStatement st = this.conn.prepareStatement(sql);
				rs = st.executeQuery();
				int id = 0;
				if(rs.next())
				{
					id = rs.getInt(1) + 1;
				}
				st = null;
				rs.close();
				sql = "insert into USERS(id,username,password,name,age,telphone,address,email,role) values(?,?,?,?,?,?,?,?,?)";
				st = this.conn.prepareStatement(sql);
				st.setString(1,String.valueOf(id));
				st.setString(2,utable.getUsername());
				st.setString(3,utable.getPassword());
				st.setString(4,utable.getName());
				st.setString(5,utable.getAge());
				st.setString(6,utable.getTelephone());
				st.setString(7,utable.getAddress());
				st.setString(8,utable.getEmail());
				st.setString(9,utable.getRole());
				st.executeUpdate();
				st.close();
				return 1;				
			}
			catch(Exception e)
			{
				e.printStackTrace();
				return 0;
			}
		}
	}
	
	public userTable getUserInfo(String id)
	{
		userTable utable = new userTable();
		ResultSet rs = null;
		Statement st = null;
		try
		{
			String sql = "select * from USERS where id="+id;
			//System.out.println(sql);
			st = this.conn.createStatement();
			rs = st.executeQuery(sql);
			if(rs.next())
			{
				utable.setId(id);
				utable.setUsername(rs.getString("username"));
				utable.setPassword(rs.getString("password"));
				utable.setRole(rs.getString("role"));
				
				String temp = rs.getString("name");
				utable.setName(temp == null ? "" : temp);
				
				temp = rs.getString("age");
				utable.setAge(temp == null ? "" : temp);
				
				temp = rs.getString("address");
				utable.setAddress(temp == null ? "" : temp);
				
				temp = rs.getString("email");				
				utable.setEmail(temp == null ? "" : temp);
				
				temp = rs.getString("telphone");				
				utable.setTelephone(temp == null ? "" : temp);
			}	
			return utable;
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
	}
	
	public int updateUser(userTable utable)
	{
		if(utable == null)
		{
			return 0;
		}
		else
		{
			//ResultSet rs =null;
			try
			{
				String sql = "update USERS set username=?,password=?,name=?,age=?,telphone=?,address=?,email=?,role=? where id =?";
				PreparedStatement st = this.conn.prepareStatement(sql);
				st.setString(1,utable.getUsername());
				st.setString(2,utable.getPassword());
				st.setString(3,utable.getName());
				st.setString(4,utable.getAge());
				st.setString(5,utable.getTelephone());
				st.setString(6,utable.getAddress());
				st.setString(7,utable.getEmail());
				st.setString(8,utable.getRole());
				st.setString(9,utable.getId());
				st.executeUpdate();
				st.close();
				return 1;				
			}
			catch(Exception e)
			{
				e.printStackTrace();
				return 0;
			}
		}
	}
}