该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class JdbcBasicTwo {
private static String driver = "oracle.jdbc.driver.OracleDriver";
private static String url = "jdbc:oracle:thin:@localhost:1521:XE";
private static String user = "wang";
private static String password = "wang";
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
//1.注册驱动
System.setProperty("jdbc.drivers", driver);
//2.获取连接
conn = DriverManager.getConnection(url, user, password);
//3.获取statement
stmt = conn.createStatement();
String sql = "select * from t_clazz";
//4.执行
rs = stmt.executeQuery(sql);
//5.处理结果集
while(rs.next()){
Long id = rs.getLong("id");
String name = rs.getString(1);
System.out.println(id+"--"+name);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
//6.释放资源
try {
if(rs!=null){
rs.close();
}
if(stmt!=null){
stmt.close();
}
if(conn!=null){
conn.close();
}
} catch (Exception e2) {
}
}
}
}