package com.company;
import java.sql.*;
public class Main {
public static void main(String[] args) throws ClassNotFoundException, SQLException
{
InsertDept();
}
public static void InsertDept() throws SQLException, ClassNotFoundException
{
// write your code here
// System.out.println("holle neusoft");
//1.加载jdbc驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//Class.forName("com.mysql.jdbc.Driver");
//2.定义链接url
String strUrl = "jdbc:oracle:thin:@localhost:1521:orcl";
//String strUrl = "jdbc:mysql://localhost:3306/newy";
//3.获取数据库连接
Connection con = DriverManager.getConnection(strUrl, "scott", "lsy15841013394");
//4.获得statement对象 (用来执行sql语句,并返回结果)
Statement st = con.createStatement();
//5.执行查询或更新
String strSql = "insert into dept values(99,'第三方','沈阳')";
//6.处理结果(遍历获得查询出来的所有数据)
//ResultSet rs = st.executeQuery(strSql);//查询
st.executeUpdate(strSql);
/*
*
*
* 6.
*st.executeUpdate(strSql); 增删改
*
* */
// while (rs.next())
// {
// Integer nEmpNo = rs.getInt("empno");
// String strName = rs.getString("ename");
// String strJob = rs.getString("job");
// String strDate = rs.getString("hiredate");
// //System.out.println(nEmpNo.toString()+":"+strName+":"+strJob);
// System.out.println(strDate);
// }
//7.关闭连接(释放资源)
//rs.close();
st.close();
con.close();
}
}
链接Oracle数据库