JDBC连接Oracle数据库
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//1.连接数据库(数据库的地址(url),登录数据库的用户名、密码、数据库驱动)
//数据库驱动
String driverClass = “oracle.jdbc.driver.OracleDriver”;
//连接的数据库的地址
String url = “jdbc:oracle:thin:@localhost:1521:orcl”;
//用户名
String userName = “scott”;
//密码
String userPassword = “tiger”;
//加载驱动
Class.forName(driverClass);
//获取连接
Connection conn = DriverManager.getConnection(url, userName, userPassword);
//设置事务手动提交
conn.setAutoCommit(false);
//提交
conn.commit();
//回滚
conn.rollback();
//System.out.println(conn);
//2.将需要执行的SQL语句发送的数据库并获取结果集
String sql = “select * from t_user”;
//发送SQL语句,进行SQL语句验证
PreparedStatement pst = conn.prepareStatement(sql);
//发送SQL语句,但是存在SQL注入
Statement st = conn.createStatement();
//获取结果集
ResultSet rs = pst.executeQuery();
while(rs.next()) {
//获取当前指向行中的第一列
/* int id = rs.getInt(1);
String userName2 = rs.getString(2);
System.out.println(id);
System.out.println(userName2);*/
//根据列名取数据
int id = rs.getInt("id");
String userName2 = rs.getString("username");
System.out.println(id);
System.out.println(userName2);
}
//关闭数据库连接
conn.close();
}