?? database.java
字號:
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("無法建立查詢"); }
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -