复习java5

package com.company; /** * Created by henson on 17-8-31. */ import java.sql.*; public class JdbcTest{ public static void main(String[] args){ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con= DriverManager.getConnection("jdbc:odbc:studs","",""); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select * from stutable"); while(rs.next()){ System.out.println(rs.getString("sname")); } rs.close(); con.close(); } catch(Exception e) { System.out.println(e.getMessage()+" 666"); } } } package com.company; /** * Created by henson on 17-8-31. */ import java.sql.*; public class JDBCDemo { public static void main(String[] args){ try { Statement stm; PreparedStatement pstm; ResultSet rs; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //加载 jdbc-odbc桥驱动 String url="jdbc:odbc:JDBCDemo"; //定义JDBC URL Connection con=DriverManager.getConnection(url); //得到与数据库的连接 System.out.println("URL:"+url); System.out.println("Connection:"+con); stm=con.createStatement(); //得到一个statement对象 System.out.println("DROPTABLE demoTable,if it exists.");//如果table存在则删除，否则【抛出异常 try { stm.executeUpdate("CREATE TABLE demoTable(" +"test_id int,tesr_val char(15) not null)"); }catch (Exception e){ System.out.print(e); System.out.println("No existing table to delete"); } System.out.println("table demoTable created!"); stm.executeUpdate("INSERT INTO demoTable("+"test_id,test_val)VALUES(1,'One')"); stm.executeUpdate("INSERT INTO demoTable("+"test_id,test_val)VALUES（2，'Two')"); stm.executeUpdate("INSERT INTO demoTable("+"test_id,test_val)VALUES（3，'Three')"); stm.executeUpdate("INSERT INTO demoTable("+"test_id,test_val)VALUES（4，'Four')"); stm.executeUpdate("INSERT INTO demoTable("+"test_id,test_val)VALUES（5，'Five')"); stm=con.createStatement(); //得到一个新的对象 rs=stm.executeQuery("SELECT * from demoTable ORDER BY test_id"); System.out.println("Display all results:"); while (rs.next()){ int theInt=rs.getInt("test_id"); String str=rs.getString("test_val"); System.out.println("\ttest_id="+theInt+"\tstr="+str); } pstm=con.prepareStatement("UPDATE demoTable SET test_val=? WHERE test_id=?"); pstm.setString(1,"Hello!"); pstm.setInt(2,2); pstm.executeUpdate(); System.out.println("Update row number 2:ok."); stm=con.createStatement(); //得到一个新的对象 rs=stm.executeQuery("SELECT * from demoTable ORDER BY test_id"); System.out.println("Display row 2:"); if (rs.next() && rs.next()){ int theInt=rs.getInt("test_id"); String str=rs.getString("test_val"); System.out.println("\ttest_id="+theInt+"\tstr="+str); } con.close(); }catch (Exception e){ e.printStackTrace(); } } } package com.company; /** * Created by henson on 17-8-31. */ public class EvenNum { public static void main(String[] args){ Runner6 r=new Runner6(); Timer1 time=new Timer1(); Thread t1=new Thread(r); Thread t2=new Thread(time); t1.start(); t2.start(); } } class Runner6 implements Runnable { public void run(){ int i=1; while (i<2000){ if (i%2==0) System.out.println(i); i++; } } } class Timer1 implements Runnable{ public void run(){ while (true) { System.out.println("Hello"); try { Thread.sleep(500); } catch (InterruptedException e) { System.out.println(e); } } } } package com.company; import java.io.*; /** * Created by henson on 17-8-31. */ public class email { public static void main(String[] args){ try { FileReader reader=new FileReader("/home/henson/Desktop/110.txt"); BufferedReader br=new BufferedReader(reader); FileWriter writer=new FileWriter("email.txt"); BufferedWriter bw=new BufferedWriter(writer); String s=br.readLine(); while (s!=null){ int post=s.indexOf("email"); if (post<0) return ; else s=s.replaceAll("email","email:"); //s=s.replaceAll("email","email:"); System.out.println(s); bw.write(s); bw.newLine(); s=br.readLine(); } br.close(); bw.close(); }catch (IOException e){ System.out.println(e); } } }

突然觉得java越来越有意思了，开心。 只能下载的java1.7怎么还找不到jdbc-odbc桥接驱动。