Java jdbc

接口
Connection连接数据库,集合上级接口

Statement 是prepareStatement,CallableStatement的父接口,执行静态SQL
prepareStatement 表示预编译的SQL语句对象
CallableStatement 执行SQL储存过程的接口
ResultSe t数据库结果集

1.导入jdbc驱动包
https://www.oracle.com/database/technologies/jdbcdriver-ucp-downloads.html

2.加载数据库驱动

// 加载数据库驱动
Class.forName("oracle.jdbc.driver.OracleDriver");

Class.forName(“oracle.jdbc.driver.OracleDriver”);

3.创建数据库连接对象

String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String user = "scott";
String password = "tiger";
// 创建数据库连接
conn = DriverManager.getConnection(url, user, password);

String url=“jdbc:oracle:thin:@主机名(localhost或ip地址):数据库的端口号;数据库的服务名”;
String user=用户名;
String password=密码;
Connection conn=DriverManager().getConnection(url,usr,password);

4.创建statement,PreparedStatement对象

// 创建statement对象
Statement stmt=conn.createStatement();//Statement容易被SQL注入式攻击
// 创建statement对象
PreparedStatement psmt =conn.prepareStatement(sql);//Statement容易被SQL注入式攻击

5.填充结果集

ResultSet rs=psmt.executeQuery();

6.遍历结果集

7.关闭连接

package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class BaseDao {

	public static void main(String[] args) {
//	String url="jdbc:oracle:thin:@192.168.90.20:1521:orcl";
		String url = "jdbc:oracle:thin:localhost:1521:orcl";
		String user = "scott";
		String password = "tiger";
		Connection conn = null;
		PreparedStatement psmt = null;
//		Statement stmt=null;
		ResultSet rs = null;
		try {
			String sql = "select empno,ename,sal from emp";
			// 加载数据库驱动
			Class.forName("oracle.jdbc.driver.OracleDriver");
			// 创建数据库连接
			conn = DriverManager.getConnection(url, user, password);
//		System.out.println(conn);
			// 创建statement对象
//		stmt=conn.createStatement();会有SQL注入是攻击
			psmt = conn.prepareStatement(sql);
			// 填充结果集
			rs = psmt.executeQuery();
//		rs=psmt.executeQuery(sql);
			// 遍历结果集
			while (rs.next()) {
				System.out.println(rs.getInt("empno") + "\t" + rs.getString("ename") + "\t" + rs.getDouble("sal"));
			}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if (rs != null) {
					rs.close();
					rs = null;
				}
				if (psmt != null) {
					psmt.close();
					psmt = null;
				}
				if (conn != null) {
					conn.close();
					conn = null;
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}