JDBC数据库连接

import java.sql.*;


public class DBCon {
	public static void main(String[] args) throws Exception {
		// TODO Auto-generated method stub
		Statement sql=null;
		ResultSet res=null;
		String url="jdbc:oracle:thin:localhost:1521:orcl";       
		Class.forName("oracle.jdbc.driver.OracleDriver");                  //加载驱动
		Connection con=DriverManager.getConnection(url,"apple","990310");  //建立连接
		if(con!=null)
			System.out.println("连接成功");
		//首先要做的是，创建语句对象                                                                                                                                             //数据库操作
		sql=con.createStatement();
		//更新、删除的套路；
		boolean ok=sql.execute("update sc set grade=82 where cno='141'and sno='101200'");
		System.out.println("更新成功");
		//查询的套路：声明结果集存放对象，进行输出操作
		res=sql.executeQuery("select s.sno,sname, avg from s,(select sno,trunc(avg(grade),2) avg from sc group by sno ) b where s.sno=b.sno");
		while(res.next()){
			System.out.print(res.getString(1)+ "    ");
			System.out.print(res.getString(2)+ "    ");
			System.out.print(res.getString(3));
			System.out.println();
		}
		con.close();
	}
}