ha.java

一个简单的C/S模式考试系统

import java.math.*;
import java.sql.*;
public class  ha {
Connection con;
        Statement stm;
        ResultSet res1; 
String buff="";
String dbname="test";
String user="";
String pass="";

String id="13";
String time;
public void print(){

try {
	         String eq="select * from user1 where id='"+this.id+"'";
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                con = DriverManager.getConnection("jdbc:odbc:"+dbname,user,pass);
       stm=con.createStatement();              
       res1=stm.executeQuery(eq);
    while (res1.next())      {
         buff="考号:"+res1.getString(1)+"\n";//从第1行开始 
         buff=buff+"姓名:"+res1.getString(2)+"\n";
         buff=buff+"性别:"+res1.getString(3)+"\n"; 
         this.time=res1.getString(4).trim(); 
         buff=buff+"考试时间:"+this.time+"分钟\n";
               
                              
            }
                       
              
              con.close();
        }    
        catch(Exception ex)        { System.out.println(ex.toString()); 
        buff=ex.toString();}
        System.out.println(buff); }
        
  public static void main(String args[]){
 	ha j=new ha();j.print();
 	
 	}
}