package hm23;
import java.sql.*;
public class BirthJdbc
{
	int flag=0;
	int number=0;
	int pagenumber=1;
	int total=0;
	String pagestr="1";
	String id="";
	String password="";
	String rpassword="";
	String name="";
	String sex="";
	int nian=0;
	int yue=0;
	int ri=0;
	int qq=0;
	String email="";
	String sheng="";
	String shi="";
	String message="";
	Connection con;
	Statement sql;
	ResultSet rs;
	StringBuffer news=new StringBuffer();
	String sexs="";
	public BirthJdbc()
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:birth","","");
			sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
		}
		catch(ClassNotFoundException e)
		{
		}
		catch(SQLException e)
		{
		}
	}
	public void clean()
	{
		id="";
		password="";
		rpassword="";
		name="";
		sex="";
		nian=0;
		yue=0;
		ri=0;
		qq=0;
		email="";
		sheng="";
		shi="";
		message="";
	}
	
	
	public void setNumber(int x)
	{
		number=x;
	}
	public int getNumber()
	{
		return number;
	}
	public void setTotal(int x)
	{
		total=x;
	}
	public int getTotal()
	{
		return total;
	}
	public void setPagenumber(int x)
	{
		pagenumber=x;
	}
	public int getPagenumber()
	{
		return pagenumber;
	}
	public void setPagestr(String x)
	{
		try
		{
			byte b[]=x.getBytes("ISO-8859-1");
			pagestr=new String(b);
		}
		catch(Exception e)
		{
		}
	}
	public String getPagestr()
	{
		return pagestr;
	}
	public void setId(String x)
	{
		try
		{
			byte b[]=x.getBytes("ISO-8859-1");
			id=new String(b);
		}
		catch(Exception e)
		{
		}	
	}
	public String getId()
	{
		return id;
	}
	public void setPassword(String x)
	{
		try
		{
			byte b[]=x.getBytes("ISO-8859-1");
			password=new String(b);
		}
		catch(Exception e)
		{
		}	
	}
	public String getPassword()
	{
		return password;
	}
	public void setRpassword(String x)
	{
		try
		{
			byte b[]=x.getBytes("ISO-8859-1");
			rpassword=new String(b);
		}
		catch(Exception e)
		{
		}	
	}
	public String getRpassword()
	{
		return rpassword;
	}
	public void setName(String x)
	{
		try
		{
			byte b[]=x.getBytes("ISO-8859-1");
			name=new String(b);
		}
		catch(Exception e)
		{
		}	
	}
	public String getName()
	{
		return name;
	}
	public void setSex(String x)
	{
		try
		{
			byte b[]=x.getBytes("ISO-8859-1");
			sex=new String(b);
		}
		catch(Exception e)
		{
		}	
	}
	public String getSex()
	{
		return sex;
	}
	public void setNian(int x)
	{
		nian=x;
	}
	public int getNian()
	{
		return nian;
	}
	public void setYue(int x)
	{
		yue=x;
	}
	public int getYue()
	{
		return yue;
	}
	public void setRi(int x)
	{
		ri=x;
	}
	public int getRi()
	{
		return ri;
	}
	public void setQq(int x)
	{
		qq=x;
	}
	public int getQq()
	{
		return qq;
	}
	public void setEmail(String x)
	{
		try
		{
			byte b[]=x.getBytes("ISO-8859-1");
			email=new String(b);
		}
		catch(Exception e)
		{
		}	
	}
	public String getEmail()
	{
		return email;
	}
	public void setSheng(String x)
	{
		try
		{
			byte b[]=x.getBytes("ISO-8859-1");
			sheng=new String(b);
		}
		catch(Exception e)
		{
		}	
	}
	public String getSheng()
	{
		return sheng;
	}
	public void setShi(String x)
	{
		try
		{
			byte b[]=x.getBytes("ISO-8859-1");
			shi=new String(b);
		}
		catch(Exception e)
		{
		}	
	}
	public String getShi()
	{
		return shi;
	}
	public void setMessage(String x)
	{
		try
		{
			byte b[]=x.getBytes("ISO-8859-1");
			message=new String(b);
		}
		catch(Exception e)
		{
		}	
	}
	public String getMessage()
	{
		return message;
	}
	public void setFlag(int x)
	{
		flag=x;
	}
	public int getFlag()
	{
		return flag;
	}
	public void setNews(StringBuffer x)
	{
		news=x;
	}
	public StringBuffer getNews()
	{
		return news;
	}
		public void setSexs(String x)
	{
		sexs=x;
	}
	public String getSexs()
	{
		return sexs;
	}
		
	
	public int checkIn()
	{
		flag=0;
		String condition="select * from member where id="+"'"+id+"'"+"and password="+"'"+password+"'";
		try
		{
			con=DriverManager.getConnection("jdbc:odbc:birth","","");
			if(id.length()==0||password.length()==0)
			{
				flag=1;
				id="";
				password="";
			}
			else 
			{
				try
				{
					rs=sql.executeQuery(condition);
				}
				catch(SQLException e)
				{
					System.out.println(e);
				}
				if(rs.next()==false)
				{
					flag=2;
					id="";
					password="";
					con.close();
				}
				nian=rs.getInt("nian");
				yue=rs.getInt("yue");
				ri=rs.getInt("ri");
			}
		}
		catch(SQLException e)
		{
			System.out.println(e);
		}
		return flag;
	}
	public int regCheck()
	{
		flag=0;
		String s="'"+id+"'"+","+"'"+password+"'"+","+"'"+name+"'"+","+"'"+sex+"'"+","+"'"+nian+"'"+","+"'"+yue+"'"+","+"'"+ri+"'"+","+"'"+qq+"'"+","+"'"+email+"'"+","+"'"+sheng+"'"+","+"'"+shi+"'"+","+"'"+message+"'";
		String condition="select * from member where id="+"'"+id+"'";
		try
		{
			if(!password.equals(rpassword))
			{
				flag=3;
				this.clean();
			}
			else if(id.length()==0||password.length()==0||name.length()==0||sex.length()==0||nian==0||yue==0||ri==0||qq==0||email.length()==0||sheng.length()==0||shi.length()==0||message.length()==0)
			{
				flag=1;
				this.clean();
			}
			else
			{
				try
				{
					rs=sql.executeQuery(condition);
				}
				catch(SQLException e)
				{
				}
				if(rs.next()==true)
				{
					flag=2;
				}
				else
				{
					condition="insert into member(id,password,name,sex,nian,yue,ri,qq,email,sheng,shi,message) values"+"("+s+")";
					sql.executeUpdate(condition);
				}
			}
		}
		catch(SQLException e)
		{
		}
		return flag;
	}
	public void showNew()
	{
		news=new StringBuffer();
		String condition="select * from member order by number desc";
		if(pagestr==null)
		{
			pagestr="1";
		}
		try
		{
			rs=sql.executeQuery(condition);
			int pagesize=15;
			rs.last();
			int max=rs.getRow();
			total=rs.getRow()%pagesize==0?(rs.getRow()/pagesize):(rs.getRow()/pagesize+1);
			if(pagestr.equals("上一頁"))
			{
				if(pagenumber==1)
				{
					pagenumber=1;
				}
				else
				{
					pagenumber--;
				}
			}
			else if(pagestr.equals("下一頁"))
			{
				if(pagenumber==total)
				{
					pagenumber=total;
				}
				else
				{
					pagenumber++;
				}
			}
			else
			{
				pagenumber=Integer.parseInt(pagestr);
			}
			rs.beforeFirst();
			if(pagenumber!=1)
			{
				rs.absolute((pagenumber-1)*pagesize);
			}
			for(int i=1;(i<=pagesize)&&(rs.next());i++)
			{
				news.append("<tr>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("name")+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("nian")+"年"+rs.getString("yue")+"月"+rs.getString("ri")+"日"+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("sex")+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("sheng")+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("shi")+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("qq")+"</div></td>");
				news.append("<td>"+"<div align=\"center\"><a href=\"member.jsp?number="+rs.getString("number")+"\"><img src=\"wzh.gif\" width=\"18\" height=\"13\" align=\"middle\"></a></div>"+"</div></td>");
				news.append("</tr>");
			}
		}
		catch(SQLException e)
		{
			System.out.println(e);
		}
	}
	public void showNyr()
	{
		news=new StringBuffer();
		String condition="";
		if(sexs==null)
		{
			sexs="";
		}
		if(sexs.length()==0)
		{
			condition="select * from member where nian="+nian+" and "+"yue="+yue+" and "+"ri="+ri+" order by number desc";
		}
		else if(sexs.length()==3)
		{
			condition="select * from member where nian="+nian+" and "+"yue="+yue+" and "+"ri="+ri+" and "+"sex="+"'"+"男"+"'"+" order by number desc";
		}
		else if(sexs.length()==2)
		{
			condition="select * from member where nian="+nian+" and "+"yue="+yue+" and "+"ri="+ri+" and "+"sex="+"'"+"女"+"'"+" order by number desc";
		}
		try
		{
			rs=sql.executeQuery(condition);
			while(rs.next())
			{
				news.append("<tr>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("name")+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("nian")+"年"+rs.getString("yue")+"月"+rs.getString("ri")+"日"+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("sex")+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("sheng")+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("shi")+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("qq")+"</div></td>");
				news.append("<td>"+"<div align=\"center\"><a href=\"member.jsp?number="+rs.getString("number")+"\"><img src=\"wzh.gif\" width=\"18\" height=\"13\" align=\"middle\"></a></div>"+"</div></td>");
				news.append("</tr>");
			}
		}
		catch(SQLException e)
		{
			System.out.println(e);
		}		
	}
	public void showYr()
	{
		news=new StringBuffer();
		String condition="";
		if(sexs==null)
		{
			sexs="";
		}
		if(sexs.length()==0)
		{
			condition="select * from member where yue="+yue+" and "+"ri="+ri+" order by number desc";
		}
		else if(sexs.length()==3)
		{
			condition="select * from member where yue="+yue+" and "+"ri="+ri+" and "+"sex="+"'"+"男"+"'"+" order by number desc";
		}
		else if(sexs.length()==2)
		{
			condition="select * from member where yue="+yue+" and "+"ri="+ri+" and "+"sex="+"'"+"女"+"'"+" order by number desc";
		}
		try
		{
			rs=sql.executeQuery(condition);
			while(rs.next())
			{
				news.append("<tr>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("name")+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("nian")+"年"+rs.getString("yue")+"月"+rs.getString("ri")+"日"+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("sex")+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("sheng")+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("shi")+"</div></td>");
				news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("qq")+"</div></td>");
				news.append("<td>"+"<div align=\"center\"><a href=\"member.jsp?number="+rs.getString("number")+"\"><img src=\"wzh.gif\" width=\"18\" height=\"13\" align=\"middle\"></a></div>"+"</div></td>");
				news.append("</tr>");
			}
		}
		catch(SQLException e)
		{
			System.out.println(e);
		}		
	}
	public void getMember()
	{
		String condition="select * from member where number="+number+" order by number desc";
		news=new StringBuffer();
		try
		{
			rs=sql.executeQuery(condition);
			while(rs.next())
			{
				news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">姓名：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("name")+"</div></td></tr>");
				news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">性別：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("sex")+"</div></td></tr>");
				news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">出生日期：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("nian")+"年"+rs.getString("yue")+"月"+rs.getString("ri")+"日"+"</div></td></tr>");
				news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">QQ：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("qq")+"</div></td></tr>");
				news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">E-MAIL：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("email")+"</div></td></tr>");
				news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">所在省：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("sheng")+"</div></td></tr>");
				news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">所在市：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("shi")+"</div></td></tr>");
				news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">簽名：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("message")+"</div></td></tr>");
			}
		}
		catch(SQLException e)
		{
			System.out.println(e);
		}
	}
}