import java.sql.*;public class JdbcTest {    public static void main(String args[]) {        String url = "jdbc:odbc:stu";        Connection con;        String sql;        Statement stmt;		String num,name,sex;		int age,math,eng,spec;		        try {           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");        } catch(java.lang.ClassNotFoundException e) {            System.err.print("ClassNotFoundException: ");            System.err.println(e.getMessage());        }        try {	                  con = DriverManager.getConnection(url, "java", "java");            stmt = con.createStatement();                        //向student表中插入一行記錄。        	sql = "INSERT INTO STUDENT " +                            "VALUES('200108','趙小龍','男',20,71,62,76)";        	stmt.executeUpdate(sql);                    	//檢索student表中的所有記錄并獲取數(shù)據(jù)輸出。        	sql = " SELECT * FROM STUDENT";        	ResultSet rs = stmt.executeQuery(sql);        	System.out.println("學號        姓名        性別   年齡"+	        								"   高等數(shù)學  英語  專業(yè)課");        	while(rs.next()){        		num = rs.getString(1);        		name = rs.getString(2);        		sex = rs.getString(3);        		age = rs.getInt(4);        		math = rs.getInt(5);        		eng = rs.getInt("英語");        		spec = rs.getInt("專業(yè)課");        		System.out.println(num+name+"	"+sex+"	"+age+"	"+math        								+"	"+eng+"	"+spec);        	}	                 	//檢索高等數(shù)學成績80分以上的學生信息。         	rs = stmt.executeQuery("SELECT 學號,姓名,高等數(shù)學,英語,專業(yè)課 "+        							"FROM STUDENT  "+        							"WHERE 高等數(shù)學>=80" );			System.out.println();			        	System.out.println("The students whose math mark is beyond 80 are:");        	while(rs.next()){        		num = rs.getString(1);        		name = rs.getString(2);        		math = rs.getInt(3);        		eng = rs.getInt("英語");        		spec = rs.getInt("專業(yè)課");        		System.out.println("學號="+num+"	"+"姓名="+name+"	"+"高等數(shù)學="+        							math+"    "+"英語="+eng+"	"+"專業(yè)課="+spec);        	}                	//關(guān)閉連接。        	stmt.close();        	con.close();     	} catch(SQLException ex) {            System.err.println("SQLException: " + ex.getMessage());        }              }}