?? personaljob.java
字號:
/*********************************************************
* *
* TiandiNet Personal Job Management *
* *
* by Tiandi 2004.1 *
* E-mail:webmaster@tiandinet.com *
*********************************************************/
package td;
import java.sql.*;
import java.util.*;
import java.security.*;
public class personaljob
{
private Connection conn = null;
public String error = null; //錯誤信息
private String username = null; //登錄用戶名
private String password = null; //登錄密碼
//初始化，進行數據庫驅動的加載和數據庫的連接
public boolean init(String mysqlDriver,String mysqlUrl,String mysqlUser,String mysqlPsw)
{
try
{
Class.forName(mysqlDriver);
this.conn = DriverManager.getConnection(mysqlUrl,mysqlUser,mysqlPsw);
return true;
}
catch(Exception e)
{
this.error = e.toString();
return false;
}
}
//返回中文字符
public String getStr(String str)
{
try
{
String temp_p = str;
byte[] temp_t = temp_p.getBytes("ISO8859-1");
String temp = new String(temp_t);
return temp;
}
catch(Exception e)
{
return null;
}
}
//HTML特殊字符轉換
public String HtmlSpecialChars(String str)
{
if(str == null||str.equals(""))
{
return str;
}
StringBuffer temp = new StringBuffer();
int i = 0;
while(i < str.length())
{
//將\n轉換成<br>
if(str.charAt(i) == '\n')
{
temp = temp.append("<br>");
}
//將空格轉換成
else if(str.charAt(i) == ' ')
{
temp = temp.append(" ");
}
//將<轉換成<
else if(str.charAt(i) == '<')
{
temp = temp.append("<");
}
//將>轉換成>
else if(str.charAt(i) == '>')
{
temp = temp.append(">");
}
else
{
temp = temp.append(str.substring(i,i+1));
}
i++;
}
String okstring = temp.toString();
return okstring;
}
//MD5加密
public String md5(String x)
{
try
{
MessageDigest m = MessageDigest.getInstance("MD5");
m.update(x.getBytes("UTF8"));
byte s[] = m.digest();
String result = "";
for(int i = 0; i < s.length; i ++ )
{
result += Integer.toHexString((0x000000FF & s[i]) | 0xFFFFFF00).substring(6);
}
return result;
}
catch(Exception e)
{
this.error = e.toString();
return null;
}
}
//設置登錄用戶名
public void setUsername(String user)
{
this.username = user;
}
//設置密碼 已經加密
public void setPasswrod(String psw)
{
this.password = psw;
}
public boolean logcheck()
{
if(this.username == null || this.password == null)
{
return false;
}
else
{
int i = 0;
try
{
String query = "select * from `td_pjm_user` where `username`='"+this.username+"' and `password`='"+this.password+"'";
PreparedStatement ps = this.conn.prepareStatement(query);
ResultSet res = ps.executeQuery();
while(res.next())
i++;
res.close();
ps.close();
if(i!=1)
return false;
else
return true;
}
catch(Exception e)
{
this.error = e.toString();
return false;
}
}
}
public ResultSet getJobsSimply()
{
String belongto = this.username;
if(belongto == null || belongto.equals(""))
return null;
String query = "select `id`,`cop_name`,`job_name`,`job_addr`,`job_get`,`job_sta`,`job_end`,`job_grad`,`job_lang`,`send`,`re` from `td_pjm_jobs` where `belongto`='"+belongto+"' order by `id` desc";
ResultSet res = null;
try
{
PreparedStatement ps = this.conn.prepareStatement(query);
res = ps.executeQuery();
return res;
}
catch(Exception e)
{
this.error = e.toString();
return null;
}
}
public ResultSet getCopInfo(String id)
{
if(id == null || this.username == null || id == "" || this.username == "")
return null;
String query = "select `cop_name`,`cop_mann`,`cop_cont`,`cop_tel`,`cop_mail`,`cop_fax`,`cop_addr`,`cop_zip`,`cop_www`,`cop_desc` from `td_pjm_jobs` where `id`="+id+" and `belongto`='"+this.username+"'";
ResultSet res = null;
try
{
PreparedStatement ps = this.conn.prepareStatement(query);
res = ps.executeQuery();
return res;
}
catch(Exception e)
{
this.error = e.toString();
return null;
}
}
public ResultSet getJobInfo(String id)
{
if(id == null || this.username == null || id == "" || this.username == "")
return null;
String query = "select `job_name`,`job_mann`,`job_addr`,`job_num`,`job_get`,`job_sta`,`job_end`,`job_grad`,`job_age1`,`job_age2`,`job_expe`,`job_lang`,`job_odem`,`job_oget` from `td_pjm_jobs` where `id`="+id+" and `belongto`='"+this.username+"'";
ResultSet res = null;
try
{
PreparedStatement ps = this.conn.prepareStatement(query);
res = ps.executeQuery();
return res;
}
catch(Exception e)
{
this.error = e.toString();
return null;
}
}
public boolean addJob(String cop_name,String cop_mann,String cop_cont,String cop_tel,String cop_mail,String cop_fax,String cop_addr,String cop_zip,String cop_www,String cop_desc,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("INSERT INTO `td_pjm_jobs` VALUES ('',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,0,'',0,'')");
ps.setString(1,this.username);
ps.setString(2,cop_name);
ps.setInt(3,Integer.parseInt(cop_mann));
ps.setString(4,cop_cont);
ps.setString(5,cop_tel);
ps.setString(6,cop_mail);
ps.setString(7,cop_fax);
ps.setString(8,cop_addr);
ps.setString(9,cop_zip);
ps.setString(10,cop_www);
ps.setString(11,cop_desc);
ps.setString(12,job_name);
ps.setInt(13,Integer.parseInt(job_mann));
ps.setString(14,job_addr);
ps.setInt(15,Integer.parseInt(job_num));
ps.setString(16,job_get);
ps.setInt(17,Integer.parseInt(job_sta));
ps.setInt(18,Integer.parseInt(job_end));
ps.setInt(19,Integer.parseInt(job_grad));
ps.setInt(20,Integer.parseInt(job_age1));
ps.setInt(21,Integer.parseInt(job_age2));
ps.setInt(22,Integer.parseInt(job_lang));
ps.setInt(23,Integer.parseInt(job_expe));
ps.setString(24,job_odem);
ps.setString(25,job_oget);
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 boolean deleteJob(String id)
{
if(id == null || this.username == null || id == "" || this.username == "")
return false;
String query = "delete from `td_pjm_jobs` 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 String[] sendGetInfo(String id)
{
String query = "select `cop_name`,`job_name`,`intro` from `td_pjm_jobs` where `id`="+id+" and `belongto`='"+this.username+"'";
String[] info = new String[3];
try
{
PreparedStatement ps = this.conn.prepareStatement(query);
ResultSet res = ps.executeQuery();
int i = 0;
while(res.next())
{
i++;
}
if(i == 1)
{
info[0] = res.getString("cop_name");
info[1] = res.getString("job_name");
info[2] = res.getString("intro");
ps.close();
return info;
}
else
{
return null;
}
}
catch(Exception e)
{
this.error = e.toString();
return null;
}
}
public boolean sending(String[] info)
{
String id = info[0];
String intro = this.HtmlSpecialChars(info[1]);
if(id == null || id.equals("") || this.username == null || this.username.equals(""))
{
return false;
}
String query = null;
if(intro == null || intro.equals(""))
query = "update `td_pjm_jobs` set `intro`='',`send`=0 where `id`="+id+" and `belongto`='"+this.username+"'";
else
query = "update `td_pjm_jobs` set `intro`='"+intro+"',`send`=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 String[] reGetInfo(String id)
{
String query = "select `cop_name`,`job_name`,`re_cont` from `td_pjm_jobs` where `id`="+id+" and `belongto`='"+this.username+"'";
String[] info = new String[3];
try
{
PreparedStatement ps = this.conn.prepareStatement(query);
ResultSet res = ps.executeQuery();
int i = 0;
while(res.next())
{
i++;
}
if(i == 1)
{
info[0] = res.getString("cop_name");
info[1] = res.getString("job_name");
info[2] = res.getString("re_cont");
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 `td_pjm_jobs` set `re_cont`='',`re`=0 where `id`="+id+" and `belongto`='"+this.username+"'";
else
query = "update `td_pjm_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 `td_pjm_jobs` where `id`="+id+" and `belongto`='"+this.username+"'";
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 cop_name,String cop_mann,String cop_cont,String cop_tel,String cop_mail,String cop_fax,String cop_addr,String cop_zip,String cop_www,String cop_desc,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 `td_pjm_jobs` set `cop_name`=?,`cop_mann`=?,`cop_cont`=?,`cop_tel`=?,`cop_mail`=?,`cop_fax`=?,`cop_addr`=?,`cop_zip`=?,`cop_www`=?,`cop_desc`=?,`job_name`=?,`job_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`=? and `belongto`='"+this.username+"'");
ps.setString(1,cop_name);
ps.setInt(2,Integer.parseInt(cop_mann));
ps.setString(3,cop_cont);
ps.setString(4,cop_tel);
ps.setString(5,cop_mail);
ps.setString(6,cop_fax);
ps.setString(7,cop_addr);
ps.setString(8,cop_zip);
ps.setString(9,cop_www);
ps.setString(10,cop_desc);
ps.setString(11,job_name);
ps.setInt(12,Integer.parseInt(job_mann));
ps.setString(13,job_addr);
ps.setInt(14,Integer.parseInt(job_num));
ps.setString(15,job_get);
ps.setInt(16,Integer.parseInt(job_sta));
ps.setInt(17,Integer.parseInt(job_end));
ps.setInt(18,Integer.parseInt(job_grad));
ps.setInt(19,Integer.parseInt(job_age1));
ps.setInt(20,Integer.parseInt(job_age2));
ps.setInt(21,Integer.parseInt(job_lang));
ps.setInt(22,Integer.parseInt(job_expe));
ps.setString(23,job_odem);
ps.setString(24,job_oget);
ps.setInt(25,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;
}
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -