mark.java

班级管理查询系统

package huazheng;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.*;
public class Mark {
   public Mark(){
	     }
   public void mark(){
	   Object selectedValue =JOptionPane.showInputDialog(null, "请输入你的学号","输入学号",JOptionPane.INFORMATION_MESSAGE);
	   String name = null, studynumber = null;
		String sex = null, address= null, major = null;
	 Connection con;
	 Statement sql;
	 ResultSet res;
	 try{
		 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	 }catch(ClassNotFoundException ee){
		 ee.toString();
	 }
	 
	 try{
		 con=DriverManager.getConnection("jdbc:odbc:hua","huazheng","huazheng");
		 sql=con.createStatement();
		 res=sql.executeQuery("SELECT * FROM huazheng3");
		 while(res.next()){
			 studynumber=res.getString(1);
			 name=res.getString(2);
			 sex=res.getString(3);
			 address=res.getString(4);
			 major=res.getString(5);
			 if(selectedValue.equals(studynumber))
			 Run.area.setText(studynumber+"   "+name+"   "+sex+"   "+address+"   "+major+"   "+"\n");
		 }
	 }catch(SQLException ee){
		 }
	 finally{
	 }
   }
	
	public static void main(String[] args) {
	
	}

}