package bean;

public class sqlBean {
	public sqlBean() {
	}
    
	public int getPT(String username, String passwd) {
		String sql = "insert into putong(username,passwd) values('" + username
				+ "','" + passwd + "')";
		database.MySQL db = new database.MySQL();
		return db.Update(sql);
	}
	

	public String[] checkUser(String username) {
		StringBuffer sql = new StringBuffer(
				"select username,passwd from putong where username='"
						+ username + "'");
		database.MySQL db = new database.MySQL();
		return db.selectToArray(sql.toString());
	}

	public String[] checkAdm(String username) {
		String sql = "select username,passwd from admini where username='"
				+ username + "'";
		database.MySQL db = new database.MySQL();
		return db.selectToArray(sql);
	}

	public String[][] getNormal(String mobiletype, String local, String result) {
		StringBuffer sql = new StringBuffer(
				"select time,mobiletype,ctype,local,result,problem,typeno,tid from normal where 1=1");
		if (mobiletype != null && !mobiletype.equals("")) {
			sql.append(" and mobiletype like '%").append(mobiletype).append(
					"%'");
		}
		if (local != null && !local.equals("")) {
			sql.append(" and local like '%").append(local).append("%'");
		}
		if (result != null && !result.equals("")) {
			sql.append(" and result like '%").append(result).append("%'");
		}
		database.MySQL db = new database.MySQL();
		return db.select(sql.toString());
	}

	public int getAddStar(String time, String mobiletype, String ctype,
			String local, String result, String problem, String typeno) {
		String sql = "insert into normal(time,mobiletype,ctype,local,result,problem,typeno) "
				+ "values('"
				+ time
				+ "','"
				+ mobiletype
				+ "','"
				+ ctype
				+ "','"
				+ local
				+ "','"
				+ result
				+ "','"
				+ problem
				+ "','"
				+ typeno + "')";
		database.MySQL db = new database.MySQL();
		return db.Update(sql);
	}

	public String[][] getStar(String tid) {
		String sql = "select time,mobiletype,ctype,local,result,problem,typeno from normal where tid='"
				+ tid + "'";
		database.MySQL db = new database.MySQL();
		return db.select(sql);
	}

	public int getEditStar(String time, String mobiletype, String ctype,
			String local, String result, String problem, String typeno,
			String tid) {
		StringBuffer sql = new StringBuffer("update normal set time='").append(
				time).append("',").append("mobiletype='").append(mobiletype)
				.append("',").append("ctype='").append(ctype).append("',")
				.append("local='").append(local).append("',")
				.append("result='").append(result).append("',").append(
						"problem='").append(problem).append("',").append(
						"typeno='").append(typeno).append("'").append(
						" where tid='").append(tid).append("'");
		database.MySQL db = new database.MySQL();
		return db.Update(sql.toString());
	}

	public int getDelStar(String tid) {
		String sql = "delete from normal where tid='" + tid + "'";
		database.MySQL db = new database.MySQL();
		return db.Update(sql);
	}
	
	public String[][] getAdm() {
		String sql = "select username,query,tianjia,edit,del from putong ";
			database.MySQL db = new database.MySQL();
		   return db.select(sql);
	}
	public String[][] getAdm(String no,String query,String tianjia,String edit,String del){
		String sql="select username,query,tianjia,edit,del from putong where username='"+no+"'";
		if(query!=null&&!query.equals("")){
			sql=sql+" and query like '"+query+"'";
			}
	   if(tianjia!=null&&!tianjia.equals("")){
		   sql=sql+" and tianjia like '"+tianjia+"'";
	   }
	   if(edit!=null&&!edit.equals("")){
		   sql=sql+" and edit like '"+edit+"'";
	   }
	   if(del!=null&&!del.equals("")){
		   sql=sql+" and del like '"+del+"'";
	   }
		database.MySQL db = new database.MySQL();
		return db.select(sql);
    }
}