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