Java使用JDBC连接Oracle数据库

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;

/**
 * @author liuwenlong
 * @create 2020-08-11 14:36:20
 */
@SuppressWarnings("all")
public class LwlSql {
    public static void main(String[] args) {
        Connection conn = null;
        try {
            //第一步，测试是否已经添加了操作oracle的jar包
            Class.forName("oracle.jdbc.driver.OracleDriver");
            //第二步：和数据库连接
            conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.3:1521:xe", "hr", "123456");

            //第三步，创建执行sql语句的对象
            java.sql.Statement st = conn.createStatement();
            st.executeUpdate("create table lwl(id number(2),sex varchar(2),brith date)");//可以执行ddl+增删改 ,不能执行select
            st.executeUpdate("insert into lwl(id,sex,brith) values(1,'a',to_date('2009-06-08','YYYY-DD-MM'))");

            System.out.println("end！");
        } catch (Exception e) {
            System.err.println(e.getMessage());
        }
    }
}