写一段JDBC连接oracle数据库的代码

package bi.shi.demo;

/**
 * @program: bi_shi_test
 * @description: 写一段JDBC连接oracle数据库的代码
 * @author: xin yi
 * @create: 2021-09-11 11:13
 */
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class Demo01 {
    public class MydbDao {
        Connection con=null;
        Statement st=null;
        public Statement mydbOpen() {
            try {
                Class.forName("oracle.jdbc.driver.OracleDriver");//加载数据库驱动
                con= DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","用户名","密码");
                st=con.createStatement();
                System.out.println("连接成功！");
            }catch(Exception e) {
                e.printStackTrace();
            }
            return st;
        }

        public void mydbClose() {
            try {
                st.close();
                con.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

    }
}