记得先导入ORACLE的JDBC包
ORACLE9G的话,在/oracle/ora92/jdbc/lib里,是
odbc14.jar那个文件
图形界面配置ORACLE的用户数据库的话,用EnterpriseManageConsole那个工具。
可以给用户配置权限什么的
(刚接触ORACLE,建个表都费了老大的劲……)
package com.miao.launch;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class Launch {
public static void main(String[] args) {
System.out.println("test");
Connection conn = null;
Statement st = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:MIAODB";
try {
conn=DriverManager.getConnection(url, "yonghuming", "mima");
st = conn.createStatement();
String sql = "insert into tb_user values(7)";
int num = st.executeUpdate(sql);
System.out.println("成功插入" + num + "条数据");
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
if (conn != null) {// 关闭连接
conn.close();
}
if (st != null) {
st.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}