7：JDBC -1

package com.qc.db1;

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

public class DbConnection1 {

    public static void main(String[] args) {
        //1：加载驱动
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    
        //2：建立连接
        Connection conn = null;
        Statement stmt = null;
        ResultSet res = null;
        try {
            //连接数据库
            conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");
            //编写sql语句
            String sql = "insert into dept values (70,'开发三部'，'去去去')";
            //发送sql语句，并执行
            stmt = conn.createStatement();
            //说明  insert update delete 用 excuteUpdate
            //select 用 excuteQuery 
            int ret = stmt.executeUpdate(sql);
            //增删改判断结果集即可，查询需遍历结果集
            if(ret > 0)
                System.out.println("执行成功");
            else
                System.out.println("执行失败");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}