需要引入oracle jar 可以 在安装oracle 的安装目录 jdbc/lib 下面寻找;
package jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class add {
public static void main(String[] args) throws SQLException {
Connection conn = null;
Statement stam = null;
//加载驱动
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//获取链接
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
String user = "scott";
String password = "tiger";
conn = DriverManager.getConnection(url, user, password);
//创建sql
String sql = "INSERT INTO student1 (name,sex,age,birth,score)values('红太狼','女','8','25-3月 -20','89')";
//创建statement(相当于运输数据的)对象执行sql 语句
stam = conn.createStatement();
int execut = stam.executeUpdate(sql);//返回1行受影响;
if(execut>0){
System.out.println("添加数据成功");
}else {
System.out.println("添加数据失败");
}
}
}