java与oracle的链接

来源：互联网发布：微策略软件编辑：程序博客网时间：2024/06/06 19:22
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数据库
0 0