练习学习与收集（JDBC）

package jdbcTest;
import java.sql.*;
public class Util {
static{
String s = "oracle.jdbc.driver.OracleDriver";
try {
Class.forName(s);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection(){
String url = "jdbc:oracle:thin:@localhost:1521:ORCL";
String name = "System";
String password = "tarena";
Connection con = null;
try{
con = DriverManager.getConnection(url,name,password);
}catch(Exception e){
e.printStackTrace();
}
return con;
}
}
package jdbcTest;
import java.sql.*;
public class Testjdbc {
public static void main(String[] ages){
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try{
con = Util.getConnection();
String sqlone = "create table ss(id number,name varchar2(20))";
ps = con.prepareStatement(sqlone);
ps.executeUpdate();
String sqltwo = "insert into ss values(?,?)";
ps = con.prepareStatement(sqltwo);
ps.setInt(1, 1);
ps.setString(2, "liaojianguo");
ps.executeUpdate();
}catch(Exception e){
e.printStackTrace();
}finally{
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
try {
String sql = "select * from ss";
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
StringBuffer sb = new StringBuffer();
while(rs.next()){
sb.append(rs.getInt(1));
sb.append(rs.getString(2));
}
System.out.println(sb.toString());
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
if(rs!=null)
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(ps!=null)
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(con!=null)
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}