import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class UserDao1 {
public static void main(String[] args) {
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
//重点记忆格式jdbc:oracle:thin:@地址:端口号:服务名
String username = "scott";//账户名
String password = "tiger";//密码
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
//2.加载数据库驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//3.连接数据库
conn = DriverManager.getConnection(url, username, password);
//4.创建statement对象
stmt = conn.createStatement();
String sql = "select id,username from t_user";
//5.查询并且填充结果集
rs = stmt.executeQuery(sql);
//6.遍历结果集
while (rs.next()) {
System.out.println(rs.getInt("id") + "\t" + rs.getString("username"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
//7.关闭数据源
try {
if (rs != null) {
rs.close();
}
if(stmt != null) {
stmt.close();
}
if(conn != null) {
conn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
jdbc连接数据库面试必考代码
最新推荐文章于 2021-06-04 18:01:48 发布