yd1236
2001-09-27, 10:47 PM
這一個程式是將資料庫裡面的欄位拿出來比對....然後累加.....我只會比對一個...
怎麼才能比對兩個以上的資料....類似投票系統!!
import java.lang.*;
import java.awt.*;
import java.sql.*;
public class data extends Frame{
public static void main(String args[]) {
data test=new data();
Label aa;
String JDriver = "sun.jdbc.odbc.JdbcOdbcDriver";//ODBC資料庫驅動程式
String connectionURL="jdbc:odbc:TestDB";
int i=0,h=0;
int d=0;
String x="2",q="1";
try {
Class.forName(JDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.out.println("ForName :" + e.getMessage());
}
try {
Connection con = DriverManager.getConnection(connectionURL);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from student where id='"+x+"'");
test.setLayout(new GridLayout(10,1));
while(rs.next()) {
i=i+1;}
test.add(new Label(""+i));
stmt.close();
con.close();
}
catch(SQLException e) {
}
test.setSize(400,400);
test.setVisible(true);
}
}
贊助商連結
怎麼才能比對兩個以上的資料....類似投票系統!!
import java.lang.*;
import java.awt.*;
import java.sql.*;
public class data extends Frame{
public static void main(String args[]) {
data test=new data();
Label aa;
String JDriver = "sun.jdbc.odbc.JdbcOdbcDriver";//ODBC資料庫驅動程式
String connectionURL="jdbc:odbc:TestDB";
int i=0,h=0;
int d=0;
String x="2",q="1";
try {
Class.forName(JDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.out.println("ForName :" + e.getMessage());
}
try {
Connection con = DriverManager.getConnection(connectionURL);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from student where id='"+x+"'");
test.setLayout(new GridLayout(10,1));
while(rs.next()) {
i=i+1;}
test.add(new Label(""+i));
stmt.close();
con.close();
}
catch(SQLException e) {
}
test.setSize(400,400);
test.setVisible(true);
}
}
贊助商連結