register.java

statelessproxy

package db.entity;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import db.MySQL;

public class Register {
	   private int skey = 0;
	   private String namealias = null;
	   private String nameoriginal = null;
	   private String urlalias = null;
	   private String urloriginal = null;
	   private String acceptpattern = null;
	   private String requester = null;
	   private int expires = 0;
	   private int priority = 0;
	   private long timeupdate = 0;
	   private long expirestime = 0;
	   private String mappedport = null;
	   private int awake = 0;
	public Register(){
		
	}
	public Register(Register register){
		this.namealias = register.namealias;
		this.nameoriginal = register.nameoriginal;
		this.urlalias = register.urlalias;
		this.urloriginal = register.urloriginal;
		this.acceptpattern = register.acceptpattern;
		this.requester = register.requester;
		this.expires = register.expires;
		this.priority = register.priority;
		this.timeupdate = register.timeupdate;
		this.expirestime = register.expirestime;
		this.mappedport = register.mappedport;
		this.awake = register.awake;
	}
	public Register(String namealias, String nameoriginal, String urlalias, String urloriginal, String acceptpattern, String requester, int expires, int priority, int timeupdate, int expirestime, String mappedport, int awake) {
		super();
		this.namealias = namealias;
		this.nameoriginal = nameoriginal;
		this.urlalias = urlalias;
		this.urloriginal = urloriginal;
		this.acceptpattern = acceptpattern;
		this.requester = requester;
		this.expires = expires;
		this.priority = priority;
		this.timeupdate = timeupdate;
		this.expirestime = expirestime;
		this.mappedport = mappedport;
		this.awake = awake;
	}
	public List<Register> select(String requester){
		String sql="select * from t_registered where requester = " + requester;
		try {
			ResultSet resultset = MySQL.executeQuery(sql);
			List<Register> list = new ArrayList<Register>();
			boolean doNext = true;
			do{
				doNext = resultset.next();
				if(doNext){
					Register register= new Register();
					register.setSkey(resultset.getInt("id"));
					register.setNamealias(resultset.getString("namealias"));
					register.setUrlalias(resultset.getString("urlalias"));
					register.setUrloriginal(resultset.getString("urloriginal"));
					register.setAcceptpattern(resultset.getString("acceptpattern"));
					register.setRequester(resultset.getString("requester"));
					register.setExpires(resultset.getInt("expires"));
					register.setPriority(resultset.getInt("priority"));
					register.setTimeupdate(resultset.getInt("timeupdate"));
					register.setExpirestime(resultset.getInt("expirestime"));
					register.setMappedport(resultset.getString("mappedport"));
					register.setAwake(resultset.getInt("awake"));
					list.add(register);
;				}
			}while(doNext);
			return list;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}
	public boolean delete(){
		return _deleteRegister(this);
	}
	public boolean _deleteRegister(Register register){
		String sql ="delete FROM t_registered where id = \"" + register.getSkey() + "\"";
		System.out.println("Remove from database:" + register.getUrloriginal());
		boolean result = false;
		try {
			result = MySQL.execute(sql);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return result;
	}
	public int update(){
		return _updateRegister(this);
	}
	private int _updateRegister(Register register){
		String sql = "update t_registered set " +
		"namealias= \"" + register.getNamealias()+
		"\",nameoriginal= \"" + register.getNameoriginal() +
		"\",urlalias = \""+ register.getUrlalias()+
		"\",urloriginal = \"" + register.getUrloriginal() +
		"\",acceptpattern = \"" + register.getAcceptpattern() +
		"\",requester = \"" + register.getRequester() +
		"\",expires = \""+ register.getExpires() +
		"\",priority = \"" + register.getPriority() +
		"\",timeupdate = \"" + register.getPriority() +
		"\",expirestime = \"" + register.getExpirestime() +
		"\",mappedport = \"" + register.getMappedport() +
		"\",awake = \"" + register.getAwake() + "\" where id = \"" + register.getSkey()+"\"";
		System.out.println("Update database:" + register.getUrloriginal());
		int result = 0;
		try {
			result = MySQL.executeUpdate(sql);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return result;
	}
	public boolean insert(){
		return _insertRegister(this);
	}
	private boolean _insertRegister(Register register){
		String sql = "insert into t_registered set " +
					"id = \"" + register.getSkey() +
					"\",namealias= \"" + register.getNamealias()+
					"\",nameoriginal= \"" + register.getNameoriginal() +
					"\",urlalias = \""+ register.getUrlalias()+
					"\",urloriginal = \"" + register.getUrloriginal() +
					"\",acceptpattern = \"" + register.getAcceptpattern() +
					"\",requester = \"" + register.getRequester() +
					"\",expires = \""+ register.getExpires() +
					"\",priority = \"" + register.getPriority() +
					"\",timeupdate = \"" + register.getTimeupdate() +
					"\",expirestime = \"" + register.getExpirestime() +
					"\",mappedport = \"" + register.getMappedport() +
					"\",awake = \"" + register.getAwake() + "\";";
		System.out.println("Add to database:" + register.getUrloriginal());
		boolean result = false;
		try {
			result = MySQL.execute(sql);
		} catch (Exception e) {
			e.printStackTrace();
			if(e.getMessage().contains("Duplicate entry")){
				register.setSkey();
				return _insertRegister(register);
			}
		}
		return result;
	}
	public static List<Register> getRegister(){
		String sql="select * from t_registered";
		try {
			ResultSet resultset = MySQL.executeQuery(sql);
			List<Register> list = new ArrayList<Register>();
			boolean doNext = true;
			do{
				doNext = resultset.next();
				if(doNext){
					Register register= new Register();
					register.setSkey(resultset.getInt("id"));
					register.setNamealias(resultset.getString("namealias"));
					register.setUrlalias(resultset.getString("urlalias"));
					register.setUrloriginal(resultset.getString("urloriginal"));
					register.setAcceptpattern(resultset.getString("acceptpattern"));
					register.setRequester(resultset.getString("requester"));
					register.setExpires(resultset.getInt("expires"));
					register.setPriority(resultset.getInt("priority"));
					register.setTimeupdate(resultset.getLong("timeupdate"));
					register.setExpirestime(resultset.getLong("expirestime"));
					register.setMappedport(resultset.getString("mappedport"));
					register.setAwake(resultset.getInt("awake"));
					list.add(register);
;				}
			}while(doNext);
			return list;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}
	public String getAcceptpattern() {
		return acceptpattern;
	}
	public void setAcceptpattern(String acceptpattern) {
		this.acceptpattern = acceptpattern;
	}
	public int getAwake() {
		return awake;
	}
	public void setAwake(int awake) {
		this.awake = awake;
	}
	public int getExpires() {
		return expires;
	}
	public void setExpires(int expires) {
		this.expires = expires;
	}
	public long getExpirestime() {
		return expirestime;
	}
	public void setExpirestime(long expirestime) {
		this.expirestime = expirestime;
	}
	public String getMappedport() {
		return mappedport;
	}
	public void setMappedport(String mappedport) {
		this.mappedport = mappedport;
	}
	public String getNamealias() {
		return namealias;
	}
	public void setNamealias(String namealias) {
		this.namealias = namealias;
	}
	public String getNameoriginal() {
		return nameoriginal;
	}
	public void setNameoriginal(String nameoriginal) {
		this.nameoriginal = nameoriginal;
	}
	public int getPriority() {
		return priority;
	}
	public void setPriority(int priority) {
		this.priority = priority;
	}
	public String getRequester() {
		return requester;
	}
	public void setRequester(String requester) {
		this.requester = requester;
	}
	public int getSkey() {
		return skey;
	}
	public void setSkey(){
		double number = Math.random()*10000;
		setSkey((int)number);
	}
	public void setSkey(int skey) {
		this.skey = skey;
	}
	public long getTimeupdate() {
		return timeupdate;
	}
	public void setTimeupdate(long timeupdate) {
		this.timeupdate = timeupdate;
	}
	public String getUrlalias() {
		return urlalias;
	}
	public void setUrlalias(String urlalias) {
		this.urlalias = urlalias;
	}
	public String getUrloriginal() {
		return urloriginal;
	}
	public void setUrloriginal(String urloriginal) {
		this.urloriginal = urloriginal;
	}
	public String toString() {
		return "skey = " + skey +
		"\nnamealias= " + namealias+
		"\nnameoriginal= " + nameoriginal +
		"\nurlalias = "+ urlalias+
		"\nurloriginal = " + urloriginal +
		"\nacceptpattern = " + acceptpattern +
		"\nrequester = " + requester +
		"\nexpires = "+ expires +
		"\npriority = " + priority +
		"\ntimeupdate = " + timeupdate +
		"\nexpirestime = " + expirestime +
		"\nmappedport = "+ mappedport +
		"\nawake = " + awake;
	}
}