jdbc,第一次上课，基本知识点

<span style="font-size:24px;"><span style="background-color: rgb(255, 255, 255);">package com.briup.day01;import java.sql.Connection;import java.sql.Driver;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;import oracle.jdbc.OracleDriver;public class FirstJDBC {public static void main(String args[]) throws Exception{try {//1注册驱动,第一方式</span><span style="background-color: rgb(0, 153, 0);">Class.forName("oracle.jdbc.driver.OracleDriver");</span></span><span style="font-size:24px;"><span style="background-color: rgb(255, 255, 255);">//2,第二种方式</span><span style="color:#cc0000;background-color: rgb(0, 153, 0);">Driver driver = new oracle.jdbc.driver.OracleDriver();</span><span style="background-color: rgb(255, 255, 255);"></span><span style="background-color: rgb(51, 204, 0);">DriverManager.registerDriver(driver);</span><span style="background-color: rgb(255, 255, 255);">//3，第三中方式//通过系统的属性进行操作</span><span style="background-color: rgb(0, 153, 0);">System.setProperty("jdbc.drivers","oracle.jdbc.driver.OracelDriver")；</span><span style="background-color: rgb(255, 255, 255);">try {//2获取连接Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","maoaixing","maoaixing");//3,sql对象,运输sql语句的载体,选择statmentStatement stat=conn.createStatement();//4，执行sql语句//String sql="create table jdbc_test(id number(10))";String sql="select id,last_name from s_emp where last_name='chang'";stat.execute(sql);//布尔值，返回值是否有结果产生stat.executeQuery(sql);//返回结果集，ResultSet//5,如果有结果集处理结果集（可选）////6,关闭资源stat.close();conn.close();System.out.println(conn);} catch (SQLException e) {e.printStackTrace();}} catch (ClassNotFoundException e) {e.printStackTrace();}}}</span></span>