基于Java语言的 MySql&Oracle 的连接代码

MySql连接代码

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

/**
 * @author ：wawa
 * @date ：Created in 2020/7/14 13:44
 * @description:程序的耦合
 */
public class JDBC {
    public static void main(String[] args) throws Exception {
        //1.注册驱动
           Class.forName("com.mysql.jdbc.Driver");
        //2.获取连接，getConnection（路径，数据库账户，数据库密码）
        //路径localhost代指本机；3306为数据库端口号;test为指定的数据表名称
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test"
                    ,"root","root");
        //3.获取操作数据库的预处理对象
        PreparedStatement pstm = conn.prepareStatement("select * from account ");
        //4.执行sql语句，得到结果集
        ResultSet resultSet = pstm.executeQuery();
        //5.遍历结果集
        while (resultSet.next()){
            int ID = resultSet.getInt(1);
            int UID = resultSet.getInt(2);
            double MONEY = resultSet.getDouble(3);
            System.out.println(ID+" : "+UID+" : "+MONEY);
        }
        //6.释放资源
        resultSet.close();
        pstm.close();
        conn.close();
    }
}

Oracle连接代码

import java.sql.*;

/**
 * @author ：wawa
 * @date ：Created in 2020/6/30 0:43
 * @description：
 */
public class OraclConn {
    static {
        try {
            //1.注册驱动
            Class.forName("oracle.jdbc.driver.OracleDriver");

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    //select sys_context('userenv','ip_address') from dual; 查询ip
    //cmd --》lsnrctl status   查询端口号
  	//访问oracle的url地址
   //格式：jdbc:oracle:thin:@数据库服务器的ip:1521:实例名
    private static final String URL ="jdbc:oracle:thin:@169.254.20.27:1521:orcl";
    private static final String USER="scott";
    private static final String PASSWORD="a123456";

    public static void main(String[] args)  {

        Connection connection = null;
        try {
            //2.获取连接
            connection = DriverManager.getConnection(URL,USER,PASSWORD);
            //3.获取操作数据库的预处理对象
            Statement statement = connection.createStatement();
            //4.执行sql语句，得到结果集
            ResultSet resultSet = statement.executeQuery("select * from t_product_type ");
            //5.遍历结果集
            while (resultSet.next()){
                int id = resultSet.getInt(1);
                String productTypeName = resultSet.getString(2);
                int status = resultSet.getInt(3);
                System.out.println("id :"+id+" productTypeName :"+productTypeName+" status :"+status);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }  finally {
            try {
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

    }
}