一个jdbc 测试程序代码

import java.sql.Date; 
import java.sql.Connection; 
import java.sql.PreparedStatement; 
import java.sql.ResultSetMetaData; 
import java.sql.Statement; 
import java.sql.ResultSet; 
import java.sql.DriverManager; 
import java.sql.SQLException; 
public class FirstOracleJdbc { 
public static void main(String[] args) throws SQLException { 
insert(new int[]{5},new String[]{"iGoder"}, new Date[]{Date.valueOf("1980-01-01")}); 
select(); 
} 
public static void select() { 
Connection con = null; 
Statement st = null; 
ResultSet rs = null; 
try { 
Class.forName("oracle.jdbc.driver.OracleDriver"); 
con = DriverManager.getConnection( 
"jdbc:oracle:thin:@localhost:1521:xe", "test", "test"); 
st = con.createStatement(); 
String sql = "select * from student"; 
rs = st.executeQuery(sql); 
while (rs.next()) { 
System.out.print("id="   rs.getInt("id")); 
System.out.print(",name="   rs.getString("name")); 
System.out.print(",birthday="   rs.getDate("birthday") "\n"); 
} 
System.out.print("                                   "); 
//printRS(rs); 
} catch (Exception e) { 
e.printStackTrace(); 
} finally { 
try { 
rs.close(); 
} catch (Exception e) { 
} 
try { 
st.close(); 
} catch (Exception e) { 
} 
try { 
con.close(); 
} catch (Exception e) { 
} 
} 
} 
public static void insert(int[] ids, String[] names, Date[] dates) 
throws SQLException { 
Connection con = null; 
PreparedStatement ps = null; 
try { 
Class.forName("oracle.jdbc.driver.OracleDriver"); 
con = DriverManager.getConnection( 
"jdbc:oracle:thin:@localhost:1521:xe", "test", "test"); 
con.setAutoCommit(false); 
String sql = "insert into student(id, name, birthday) values(?,?,?)"; 
ps = con.prepareStatement(sql); 
for (int i = 0; i  1) 
{ 
System.out.print(","); 
} 
String name = rsmd.getColumnName(i); 
String value = rs.getString(i); 
System.out.print(name   "="   value); 
} 
System.out.println(); 
} 
} 
}