java连接oracle以及Mysql

java连接oracle

import java.sql.*;
public class Conn {

    public static void main(String[] args) {

        Statement stem = null;
        ResultSet  st = null;
        Connection ct = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            String url="jdbc:oracle:thin:@localhost:1521:ORCL";
            String UserName="scott";
            String passWord="m1234";
            try {
                ct=DriverManager.getConnection(url,UserName,passWord);
                stem=ct.createStatement();
                st=stem.executeQuery("select empno,ename from emp");
                while(st.next()){
                    System.out.println(st.getString("empno")+","+st.getString("ename"));
                }

            } catch (SQLException e) {
                
                e.printStackTrace();
            }
                
            
        } catch (ClassNotFoundException e) {
            
            e.printStackTrace();
        }
    
    }
}

java连接mysql

        Connection conn = null;
        Statement stem = null;
        ResultSet rs = null;
        try{
        String url = "jdbc:mysql://127.0.0.1:3306/users";
        String user = "root";
        String uPwd = "123456";
        try{
            //加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            //连接数据库
            conn = DriverManager.getConnection(url,user,uPwd);
            stem = conn.createStatement();
            rs = stem.executeQuery("select * from users");
                
                while(rs.next()){
                    
                    System.out.println(rs.getString("uName") + rs.getString("pwd") + rs.getString("id"));
            
                }
        }catch (Exception e) {
            e.printStackTrace();
        }
        }catch(Exception ex){
            ex.printStackTrace();
        }
    }
}