import java.sql.*;

public class DataBase
{
	String keyword;
	
	public DataBase()
	{
		keyword="";
		try
		{	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e1){}
	}

	public void setKeyword(String s)
	{
		keyword=s;
		try
		{
			byte a[]=keyword.getBytes("ISO-8859-1");
			keyword =new String(a);
		}catch(Exception e){}
	}

	public StringBuffer byKeywordInquire()
	{
		String name,number;

		Connection con=null;
		Statement sql=null;
		ResultSet rs=null;

		StringBuffer buffer=new StringBuffer();
		int count;

		try
		{
			con=DriverManager.getConnection("jdbc:odbc:shuiguo","","");
			sql=con.createStatement();
			String condition="SELECT * FROM form WHERE id="+keyword;
			rs=sql.executeQuery(condition);
			buffer.append("<Table Border>");
			buffer.append("<TR>");
				buffer.append("<TH width=100><FONT size=6>"+"序號");
				buffer.append("<TH width=100><FONT size=6>"+"名稱");
				buffer.append("<TH width=100><FONT size=6>" +"得票數");
			buffer.append("</TR>");
			while(rs.next())
			{	number=rs.getString(1);
				name= rs.getString(2);
				buffer.append("<TR>");
					buffer.append("<TD><FONT size=6>"+number+"</TD>");
					buffer.append("<TD><FONT size=6>"+name+"</TD>");
					count=rs.getInt("count");
					buffer.append("<TD><FONT size=6>"+count+"</TD>");
				buffer.append("</TR>");
			}
			buffer.append("</Table>");
			con.close();
			return buffer;
		}catch(SQLException e1)
		{return new StringBuffer("無法建立查詢"); }
	}
}