本文共 2333 字，大约阅读时间需要 7 分钟。

版本可以自己选择

       
    
     mysql
        
    
     mysql-connector-java
        
    
     5.1.9
    
   

或者oracle的【ojdbc6-11g.jar】

       
    
     com.oracle
        
    
     ojdbc6
        
    
     11g
    
   

import java.sql.*;public class Test {    public static void main(String[] args) {        Connection conn = null;        PreparedStatement pstmt = null;        ResultSet res = null;        try {            //Class.forName("oracle.jdbc.driver.OracleDriver");            //String url="jdbc:oracle:thin:@ip:orcl";            Class.forName("com.mysql.jdbc.Driver");            String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF8";            String user = "";            String pwd = "";            conn = DriverManager.getConnection(url, user, pwd);            //query            String sql = "select * from student where age = ?";            pstmt = conn.prepareCall(sql);            pstmt.setInt(1, 18);            res = pstmt.executeQuery();            //getColumnLabel            ResultSetMetaData rsmd = res.getMetaData();            for (int i = 0, n = rsmd.getColumnCount(); i < n; i++) {
                   System.out.print("i:" + i + " n:" + n + " ");                System.out.print(rsmd.getColumnLabel(i + 1) + "  ");            }            System.out.println("");            //get res            while (res.next()) {                //one row                System.out.print(res.getString("id"));                System.out.print(res.getString("name"));            }            //insert            String sql = "insert into student (name,gender,age,stunum) values (?,?,?,?)";            pstmt = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);            pstmt.setString(1, "abc");            pstmt.setString(2, "f");            pstmt.setInt(3, 2);            pstmt.setString(4, "1999091223");            int r = pstmt.executeUpdate();            //影响的行数            System.out.println("insert res:" + r);            res = pstmt.getResultSet();            //null            System.out.println(res);            res = pstmt.getGeneratedKeys();            if (res.next()) {                //获取主键                System.out.println(res.getObject(1));            }        } catch (Exception e) {            e.printStackTrace();        }    }}

转载地址：http://wgxlf.baihongyu.com/