oracle基础操作

• JDBC:
  *1. 导入对应数据库驱动包
  2.注册数据库驱动
  3.获得数据库连接
  ip +端口 +用户名+密码

DriverManager.getConnection(url, user, password)方法建立在JDBC URL中定义的数据库Connection连接上。
连接MySql数据库：
Connection conn = DriverManager.getConnection(“jdbc:mysql://host:port/database”, “user”, “password”);
连接Oracle数据库：
Connection conn = DriverManager.getConnection(“jdbc:oracle:thin:@host:port:database”, “user”, “password”);
连接SqlServer数据库：
Connection conn = DriverManager.getConnection(“jdbc:microsoft:sqlserver://host:port; DatabaseName=database”, “user”, “password”);
4.获取数据库操作对象
statement
5.执行SQL语句 SQL注入
excuteUpdate
excuteQuery–查询------ResultSet

6.关闭资源

//如果所找列没找到，会出sql异常

insert：
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Test01_insert{

 public static void main(String[] args) throws ClassNotFoundException, SQLException {
	Class.forName("oracle.jdbc.OracleDriver");//加载类到jvm
	Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL", "scott", "123456");//获取数据库连接
	Statement smt = conn.createStatement();//获取数据库操作对象
	ResultSet rs=smt.executeQuery("select * from emp");  
    //System.out.println(rs);		
	//遍历
	while(rs.next())//判断是否有下一条记录
	{//获得记录对应的列
		    //整型取列值，代表第几列
		int empno = rs.getInt("empno");
		String ename = rs.getString(2);
		String job = rs.getString("job");
		System.out.println(empno  + "\t" + ename + "\t" + job);
		System.out.println("============");
	}
	System.out.println("OK!!"+conn);
	//关闭资源
	rs.close();
	smt.close();
	conn.close();//必须关
}

}

delete：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class Test02_delete{

public static void main(String[] args) throws ClassNotFoundException, SQLException {
	Class.forName("oracle.jdbc.OracleDriver");
	Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL", "scott", "123456");
	Statement sta = conn.createStatement();
	int x = sta.executeUpdate("delete from myemp where sal=4543 ");
	System.out.println("ok!!" + conn);
	conn.close();
	sta.close();
}

}

update：
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class Test03_update {

public static void main(String[] args) throws ClassNotFoundException, SQLException {
	Class.forName("oracle.jdbc.OracleDriver");
	Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL", "scott", "123456");
	Statement stm = conn.createStatement();
	int x = stm.executeUpdate("update myemp set sal=5433 where empno=2");
	System.out.println("x=" + x);
	System.out.println("ok!!");
	conn.close();
	stm.close();

}

}