JDBC 链接

ORACLE与MYSQL查询链接


package com.company;


import javax.xml.crypto.Data;
import java.sql.*;


public class Main
{


    public static void main(String[] args) throws ClassNotFoundException, SQLException
    {
        // write your code here
        //加载JDBC驱动
        //Class.forName("oracle.jdbc.driver.OracleDriver");
        Class.forName("com.mysql.jdbc.Driver");
        //定义链接URL
        //String strUrl = "jdbc:oracle:thin:@localhost:1521:orcl";
        String strUrl= "jdbc:mysql://localhost:3306/scott";
        //获取数据库连接
        //Connection con = DriverManager.getConnection(strUrl, "scott", "cj85515887");
        Connection con = DriverManager.getConnection(strUrl,"root","root");
        //获得statement对象（用来执行sql语句，并返回结果，建立查询窗口）
        Statement st = con.createStatement();
        //执行查询或更新
        String strSql = "select * from emp";
        //处理结果（遍历获取查询出的数据）
        ResultSet rs = st.executeQuery(strSql);
        while (rs.next())
        {
            Integer empnum = rs.getInt("empno");
            String strName = rs.getString("ename");
            String strjob = rs.getString("job");
            Date date = rs.getDate("hiredate");
            System.out.println(empnum.toString() + ":" + strName + ":" + strjob+":"+date);
        }
        //关闭链接（释放资源）
        rs.close();
        st.close();
        con.close();
    }
}








ORACLE插入
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;


/**
 * Created by ttc on 16-10-27.
 */
public class aaa
{
    public static void Insertdept(int deptno,String strDeptName,String strLoc) throws ClassNotFoundException, SQLException
    {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        String strUrl = "jdbc:oracle:thin:@localhost:1521:orcl";
        Connection con = DriverManager.getConnection(strUrl, "scott", "cj85515887");
        Statement st = con.createStatement();
        String strSql = "insert into dept values("+deptno+",'"+strDeptName+"','"+strLoc+"')";
        st.executeUpdate(strSql);


        st.close();
        con.close();
    }




    public static void main(String[] args) throws SQLException, ClassNotFoundException
    {
        Insertdept(90,"销售部","大连");
    }
}




ORACLE 修改
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;


/**
 * Created by ttc on 16-10-27.
 */
public class aaa
{
    public static void Insertdept(int deptno,String loc) throws ClassNotFoundException, SQLException
    {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        String strUrl = "jdbc:oracle:thin:@localhost:1521:orcl";
        Connection con = DriverManager.getConnection(strUrl, "scott", "cj85515887");
        Statement st = con.createStatement();
        String strSql = "UPDATE dept set loc='"+loc+"' where deptno="+deptno;
        st.executeUpdate(strSql);


        st.close();
        con.close();
    }




    public static void main(String[] args) throws SQLException, ClassNotFoundException
    {
        Insertdept(90,"瓦房店");
    }
}