java与oracle的链接

package com.company;

import java.sql.*;

public class Main {

    public static void main(String[] args) throws ClassNotFoundException, SQLException
    {

        InsertDept();
    }

    public static void InsertDept() throws SQLException, ClassNotFoundException
    {


        // write your code here
//        System.out.println("holle neusoft");
        //1.加载jdbc驱动
        Class.forName("oracle.jdbc.driver.OracleDriver");

        //Class.forName("com.mysql.jdbc.Driver");
        //2.定义链接url
        String strUrl = "jdbc:oracle:thin:@localhost:1521:orcl";

        //String strUrl = "jdbc:mysql://localhost:3306/newy";
        //3.获取数据库连接
        Connection con = DriverManager.getConnection(strUrl, "scott", "lsy15841013394");
        //4.获得statement对象 (用来执行sql语句，并返回结果)
        Statement st = con.createStatement();
        //5.执行查询或更新
        String strSql = "insert into dept values(99,'第三方','沈阳')";
        //6.处理结果（遍历获得查询出来的所有数据）
        //ResultSet rs = st.executeQuery(strSql);//查询
        st.executeUpdate(strSql);


        /*
        *
        *
        * 6.
        *st.executeUpdate(strSql); 增删改
        *
        * */


//        while (rs.next())
//        {
//            Integer nEmpNo = rs.getInt("empno");
//            String strName = rs.getString("ename");
//            String strJob = rs.getString("job");
//            String strDate = rs.getString("hiredate");
//            //System.out.println(nEmpNo.toString()+":"+strName+":"+strJob);
//            System.out.println(strDate);
//        }

        //7.关闭连接(释放资源)
        //rs.close();
        st.close();
        con.close();

    }


}

链接Oracle数据库