数据结构中之JDBC技能

在java开发过程中，不可避免的就是使用数据库，在数据库的关联中，需要使用到jdcb关联（Java DataBase Connectivity,java数据库连接）。下面通过一个案例来作为本次的使用来讲解一下。

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;/** * 描述: * 连接access数据库 * * @outhor 71948 * @create 2017-12-07 0:04 */public class ConnectionAccess {    private static final String Driver = "oracle.jdbc.driver.OracleDriver";    private static final String Url = "jdbc:oracle:thin:@localhost:1521:zsd";    private static final String User = "scott";    private static final String Pwd = "tiger";    public static void main(String[] args) throws Exception {        Class.forName(Driver);        Connection conn = DriverManager.getConnection(Url,User,Pwd);        Statement stat = null;        String sql = "SELECT * FROM Emp";        ResultSet resu = stat.executeQuery(sql);        while (resu.next()){            System.out.print("Empno    Ename   Job    Mag      Sal      Comm  ");            int id = resu.getInt("Empno");            String name = resu.getString("Ename");            int job = resu.getInt("Job");            String mag = resu.getString("Mag");            double sal = resu.getDouble("Sal");            String comm = resu.getString("Comm");            System.out.println();            System.out.println(id + "    "+ name + "    " +                    job + "       "+ mag + "   " + sal                    + "   " + comm);        }        conn.close();        stat.close();        resu.close();    }}