import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/*
-
使用纯Java驱动方式进行直连
1、下载数据库厂商提供的驱动程序包
2、将驱动程序包引入工程中
3、编程,通过纯Java驱动方式与数据库建立连接使用localhost连接
String url = “jdbc:oracle:thin:@localhost:1521:orcl”;
String url = “jdbc:oracle:thin://localhost/1521/orcl”;使用本机地址:(127.0.0.1),(192.168.42.1)
String url = “jdbc:oracle:thin:192.168.42.1:1521:orcl”;//(使用本机地址连接)
String url = “jdbc:oracle:thin:127.0.0.1:1521:orcl”;// (使用本机地址连接)@:标识本地地址: localhost
本机ip地址:(127.0.0.1),(192.168.42.1)
端口号:1521
thin:驱动的模式
驱动:oracle.jdbc.driver.OracleDriverJDBC连接数据库的步骤:
1.找到对应的驱动器(jar)库,从数据库对应的网站下载
2.驱动库添加到项目中,右键jar包—build path ----> Add to Build path
3.加载驱动类
Class.forName(“oracle.jdbc.driver.OracleDriver”);
4.获取连接(通过jdbcline节数据库url,用户名和密码)
String url = “jdbc:oracle:thin:@localhost:1521:orcl”;
String url = “jdbc:oracle:thin://localhost/1521/orcl”;、
String url = “jdbc:oracle:thin:192.168.42.1:1521:orcl”;//(使用本机地址连接)
String url = “jdbc:oracle:thin:127.0.0.1:1521:orcl”;// (使用本机地址连接)Connection conn = DriverManager.getConnection(url, "scott", "tiger");
5.通过连接创建语句对象(Statement)
Statement mStatement = conn.createStatement();- 通过语句对象执行sql语句,返回结果集对象
String sql = “select * from emp where empno = 7788”;
ResultSet mResultSet = mStatement.executeQuery(sql);
7.处理结果集
8.关闭所有连接
- 通过语句对象执行sql语句,返回结果集对象
-
*/
public class JDBCDemo1 {
public static void main(String[] args) {
// 1.加载驱动类
try {
Class.forName(“oracle.jdbc.driver.OracleDriver”);System.out.println("驱动加载成功!"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("找不到驱动类!"); } // 2.建立连接 try { // 使用localhost连接 // String url = "jdbc:oracle:thin:@localhost:1521:orcl"; // String url = "jdbc:oracle:thin://localhost/1521/orcl"; // 使用 // String url = "jdbc:oracle:thin:192.168.42.1:1521:orcl";//(使用本机地址连接) String url = "jdbc:oracle:thin:127.0.0.1:1521:orcl";// (使用本机地址连接) Connection conn = DriverManager.getConnection(url, "scott", "tiger"); System.out.println("连接成功:" + conn); // 3.产生Statement对象 Statement mStatement = conn.createStatement(); // 4.执行sql语句,并产生结果集 String sql = "select * from emp where empno = 7788"; ResultSet mResultSet = mStatement.executeQuery(sql); // 5.处理结果集 while (mResultSet.next()) { // int empno = mResultSet.getInt(1); 根据索引获取每一列的值,索引从1开始 // String name = mResultSet.getString(2); // 根据列名获取每一列的值(推荐) int empno = mResultSet.getInt("empno"); String name = mResultSet.getString("ename"); String job = mResultSet.getString("job"); int mgr = mResultSet.getInt("mgr"); float sal = mResultSet.getFloat("sal"); float comm = mResultSet.getFloat("comm"); int deptno = mResultSet.getInt("deptno"); Date hiredate = mResultSet.getDate("hiredate"); System.out.println(hiredate); System.out.println(empno + "," + name + "," + job + "," + mgr + "," + sal + "," + comm + "," + deptno); } // 6.关闭数据库连接,释放资源 mResultSet.close(); mStatement.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }
}
}