java连接数据库，执行oracle操作

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

import java.sql.Connection;<br>//属于java api中提供的一个接口，用于与数据库的链接<br>import java.sql.DriverManager; import java.sql.Statement;   public class HelloWorld01 {     public static void main(String[] ages){         try {             //1、申明数据库的驱动程序             Class.forName("oracle.jdbc.driver.OracleDriver");             //2、使用连接地址，用户名，密码等登陆数据库，得到Connection对象             String url="jdbc:oracle:thin:@localhost:1521:orcl";             String uName="scott";             String uPwd="tiger";             Connection conn=DriverManager.getConnection(url,uName,uPwd);             //3、使用Connection对象创建Statement对象  写代码的窗口             Statement sta=conn.createStatement();             //4、执行sql语句             String sql="insert into emp values(6666,'李泞羽','经理',7777,to_date('1990-01-01','yyyy-mm-dd'),8888,1111,10)";             //String sql="delete from emp where ENAME='李泞羽'";             //String sql="update emp set ENAME='li'where ENAME='李'";             //String sql="select * from emp where ENAME='li'";             int i = sta.executeUpdate(sql);             System.out.println(i+"行被执行");             //5、关闭连接，释放资源             sta.close();             conn.close();         } catch (Exception e) {             // TODO: handle exception             e.printStackTrace();//捕捉异常信息         }     } }