Statemen接口对象

利用Statement接口实现数据表的更新和查询操作

-取得Statement接口对象：Statement createStatement(int resultSetType, int resultSetConcurrency) throws SQLException

　　一个Connection 可以打开多个Statement

-数据更新操作：int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException

　　返回int更新行数

-数据查询操作：ResultSet executeQuery(String sql) throws SQLException

　　返回ResultSet

编写数据库创建脚本，创建一个表格脚本

DROP TABLE member PURGE ;
DROP SEQUENCE myseq;
CREATE SEQUENCE myseq ;
CREATE TABLE member (
    mid        NUMBER,
    name        VARCHAR2(20),
    birthday    DATE    DEFAULT    (SYSDATE) ,
    age        NUMBER(3),
    note         CLOB,
    CONSTRAINT pk_mid PRIMARY KEY(mid)
);

以上有序列，mid通过序列生产

数据更新操作：

每次更新之后都会返回影响的数据行数

数据增加的Oracle命令

　　INSERTINTO 表名称 （列，列，、、） VALUSES (值，值。。。) ;

package cn;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

public class Test {

    private static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";

    private static final String DBURL = "jdbc:oracle:thin:@localhost:1521:mldn";

    private static final String USER = "scott" ;

    private static final String PASSWORLD = "tiger" ;

    public static void main(String[] args)  throws Exception{

        //第一步 加载数据库驱动程序，此时不需要实例化，会有容器自己负责管理

        Class.forName(DBDRIVER) ;

        //第二步 连接数据库 每一个Connection都代表一个数据库连接

        Connection conn = DriverManager.getConnection(DBURL,USER,PASSWORLD) ;

        //第三步，进行数据库的数据操作

        Statement stmt = conn.createStatement();

        String sql = "INSERT INTO member (mid,name,birthday,age,note) VALUES(myseq.nextval,'张三',TO_DATE('1999-10-10','yyyy-mm-dd'),17,'人')";

        int len = stmt.executeUpdate(sql);

        System.out.println(conn) ;

        System.out.println(len);

        //关闭连接

        stmt.close();

        conn.close();

    }

}

这个时候就会更新了数据库中的列表信息

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAlwAAABnCAIAAABaXAugAAAHf0lEQVR4nO3d347cthUHYL5pGrRAmzZoiyZpavjl5lWaIheBESAFYsDozkUvllmMRfLoSPNPmvm+qxHnDEWREn8Y27sux+Px/fv3BQAQigBQCUUAqIQiAFRvoXg4Malp22eL8wPodnXoCc47qh+dIii+iMz4g6uYtIwOR+dtD+PxZOrPuS6A3XgNxXbjeyuY3UBb+W0xc963w7jzTP3ptbSHlzW6tNnXbePh8+CZPWm3vjs/yfrZfuIagN2IQ7HdAZMbX3JbTJ4r03O3Pe5z0d69dNNfFB6jgR16Zk/arQ/mZ7Y+c+1L5+f07LOVADfShuKp0WbdvjX72aU1k3PNfqRbH49h6Y7cJsds8WQ8bfvhHqE4aczUx/0ENZnRzlYC3Ej7d4qn74426/atrnxNW9bdqYM+Z3f2dcPrdp7ZzePxx+N8Ozx9kRlwUB+fN1m/oh1gTyb/+nS0O5cmvdrKSc+LNse2eHKuYIRBfTyGpdv3ok1/dvzxZLY1mQHPLt9kPPn6uJ9gzAB7kvw7xTYPgj2929KVCYbkR7r1cZ+Ltu/Zc8WnjvsZDWzpgIP6pfOzaJ6TNd2P5JcA4OqS//q03b9mP5I5e76TpZt1suZ6O/LS8Hh7fc6AF61Rvv7MeY5He70lAFgs83OKr9pdb6Ity+ied9T/0vbkKfKjPeeiShMDoyFNWkaHo/O2h/G8Zerb62r7GV1XfsAAd5b8jTbt/ghncjsBm+PXvAFA9XI8vhOKAFBK+XQ8fi8UAaCU8vF4/FYoAkAp5b/H49+FIgCUUn7+dPz6e6EIAKX89Ovxj/8QigBQyo+/vPz+r+/uPQoA2ID//Pzpy798d+9RAMAG/PDh4xdffXvvUQDABvz7w8cvvvrm3qMAgA344cPH3/3ZN0UAeP07xa//ee9RAMAG/PjLyx/+5l+fAkApP/16/NM3fk4RAF5/o82/hCIA+N2nAPDG/5IBAJX/TxEAqv8dj++EIgCUUl6Ox/dCEQBKKUehCACv9hWKh8PhcDh0Dw8nJgVt+4r+28Og4NCTvMYtCAafmefuorTto9ejGYvnf3eTvDujGc6se7w03dup7b97xnPOCx17DMXD58Ezebf7kdG7o+L2sPuYBeNpK3OXuBXxtQTzXD6f8/Yw2floquMFWn6hpHTnv4yXYNH9n1nWSWPp3VdLzwsdOw3F2S2y2zi7b076HD2Qk9fd8cyea+OCa1k6z219sjg5/8GouIjknK9ejtGzE99Is/chrCEUR/2X9KbcHc/k9Zqrvatg3pbOc1ufLE7OfzAqLmLFnC+6/yePT3fdZw9XnBc69hiKpfnzk8m73Y+MCtriiaCTYDxtJ/sSjD+Y52R9d5Lb4tn5L81+yjXM3v+jjySXpr0f2nWfPVxxXujYaShmDtvG2edk8jR2D4MOR2/t8eFMXmbb2L4bt2TmcDT/wXi4oMz9H7+V6b8Mnru2rHu44rzQIRTj4vbhDDpcdK6NS17muvqlcxhP7N6nevuuff9nnrvZwxXnhY7nCcXM0zLq8PxNYXcPavIy19VnipNzPhoPF7Tinl90/2f6TK773p877u/l5eUxQvFwYlLQti/tP//kn9YvPft2BIOPG08PZ+vj4kz9qH8uK5j/0lu19v6JVydY7tLcXe1JRyNxV7DGvkIRAK5IKAJAJRQBoBKKAFAJRQCohCIAVEIRACqhCACVUASASigCQCUUAaB6DcXR7wx81PaRrY3z2u3m4Tbt5vlgHrTvpN03RQD4jVAEgEooAkAlFAGgEooAUAlFAKiEIgBUQhEAKqEIAJVQBIBKKAJAJRQBoBKKAFAJRQCohCIAVM/5/ylq1659O+2wIb4pAkAlFAGgEooAUAlFAKiEIgBUQhEAKqEIAJVQnOVHqeD2PHfch1A81f2x4snD6Vm9ge5Peftx76diobkPoTiSDMV4+7aPrxPMmMl8Ehaa+xCKI91Q9KDehlDEQnMfDx+Kq7+utaH4hE9pe8nrvgEv7ef8UBx17uv7NQSTvHq2LRD38dihePo0Jp/M9jE+/Pa7jK8yxA0bJUpQcKl+urtqfnsdrfuK+4FZl7pP2m7PHBisIRTbj8y2PLxRArXzGU/O6n6CboXidmTWtz1M9lye8tHj/h47FE+tCMVDKFm23wc72OwWXd2KfoJul54x85pzzM7kiqk+CEXu5UlCMf9YtmVP+3zGYVYG2daGXL6f04JgVJN+uueNB9O2s1o8kyvmebJe60YFKz1DKC56LLvb6+TFkxiF2WmkZeZkRT/dtFuRZKN6iXhBwWSum2ehyD09fCiu3v6EYpBVo4JL9RN0KxS35rKT3H7ESnFTjx2KK3bw089OXpQnez5HYRYUXKqfi4SiRLwNochDeYZQPLXos5MX3cOHFMzbovlc10/cbXL+RyNccScwEj9fK+Z5VG+9uJ3HDsVzTEJxsqG/vci76ej37CKhyO5YdzZBKE50I7D7heNmQ3oqwcS2S8PDyCyrpecWhGKr/VOg+4zj+cxOtbV4SPlldQNwdUIRACqhCACVUASASigCQCUUAaASigBQCUUAePV/l26l4Z1FPqYAAAAASUVORK5CYII=" alt="" />

范例：数据修改

　　命令格式 UPDATE 表名称 SET 字段=值，WHERE 更新条件

String sql = "UPDATE member SET name='李四' ,birthday=SYSDATE ,age=30 WHERE mid IN(2,3)";

结果：

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdoAAACACAIAAAAj5D/dAAAHr0lEQVR4nO3c24Krtg4AUP7s/Dp/ts9D2ynFlrDNZbis9UTAEY4sq0n2pNMEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAL/lT+C35wXwMdoxwC1oxwC3oB3DY8zzPM9z9eG8sBpQnh+IXz5MBsw1ja/xDpLJt+S5uijl+fL4f/+1asd5/h+X5MeJMtyy7vnSVMupjF+94577sssyxdEiVZ8SXY0Glw+rC5zMpxzZ9hLvIn8tSZ6n/+a8fJgE//Pnz08jXnbkKc1/MiuOUs3/FC9BV/23LOvq5FSrq977sstcs7pafUoyoBp/NT6vuep8Nu91c8lr6c1zOT4avOrCP8d5/pNZcYjGnA8vR7R38kLarEPONdesrlafkgyI4k/HteMn1keSt948l+OjwdrxPQ3kvKv+V9unPKjerqUO8/uyy3Kdpt1tIoq/kgRJ5lMGeZZk/kmeG8dXkzz1t+Op2MmcYbP+o6c0Lk1ZD/O+dqwkrjC8PMmA6uBqWZTLnExgddz8Eu+i8WWWJ8ur+Znlcd6Oy/wn8+FALfWfX2qJPwX7rhxWfThwX3bZvzz5CkXllZfg2L1urvFljo2PBg+8O47mw4HOrv+Wfbf5cOC+7LJneVrWKQq4vxwfVyKNL3NsfDQ4+suKJHg0Hw40UPNd9d8Ss3Hdn77vnmRz2aoDyvO98dtrbjm+9+73kUw+P7l8uDm+PI7+7ngz54/L8LMk+Z9qu6y3/pPymIrqKm8azURVwDi/ygO4Be0Y4Ba0YwAAAAAAAAAAAAAAuFL1N+PRb8l/63z75H93nmefl4drzsvzLA+/cT7JOQAAAAAAAAAAAAAAAAAAAAAAAAAAPMA9/7+fzjvv/G3PAwAAAAAAAAAAALyCP42E69l3VCiL81R/F+AHAkz2HdNWgyg7Re94lpLMSNrHKQDWNvvpqjVvHrOkHRNRAC+05y3q/M8P7ae4ON7djsuZ977rzwef3Y6jm/rIcpRoffd/OrRAb7Mshd6yWD5xdVAd1nj8INEeSwYkEaqD59Th82+ZM+2i9e2tkyj43vlxW+01URZTEuSV7TjqieWW29+Ok+d2zbm8bz5/jpW35t60z+lHUh6vpSYaW8aq2qojH92O/5K0s6jfdUWbTv6yQju+UrUdD9TJT4TpsRuHzHBBlKrDVgflw4dWVd6Op2DXVXO1mb2uS6uw0X2jaYzVA5Ek86s6aQ9YPeY9du7A6LlRO552vDW4ibydVQc0xqkGTBrrsfPfnBUDytz21skyVPWY99iz/ZInzot3AQNPv7OkHUcDWoKsrg5caqQdX6najstLLXE2z/BIY72jUVfYXS/jl+TtrDogiVAdrB0/WpTP3jpZxdw8w1OVDXQgwvDV9jG3Ev23p7w0HGc68yNF4/yH4/MjWdyBVEcjLRZ/2+waLS6a66Oc1455IvVAZj7oe2GVVEpy0pJ2XsY+YpsKOMNmVqX9U/Z/m8FXqAC4nn1HhbI4jy/ciSgAuv9prnc8S0lmJO3jFABrm/101Zo3j1nSjokogBfa8xZ1/u/v7pMx7cfPUs68911/Pvjsdhzd1EeWo0Tru//ToQV6m2Up9JbF8omrg+qwxuMHifZYMiCJUB08pw6ff8ucaRetb2+dRMH3zo9bGWvHZTFFl8qrm8ePEPXEMp/723Hy3K45l/fN58+x8tbcm/bZ356/W0tNNLaMVbVVRz66Hf8laWdRv+uKNp38ZYV2fKVqOx6ok58I02M3DhvGCqJUHbY6KB8+tKrydjwFu66aq83sdV1ahY3uG01jrEEQSTK/qpP2gNVj3uCQvRdFiNrxtOOtwU3k7aw6oDFONWDSWI+d/+asGFDmtrdOlqGqxzzeqb14Wvz3f+zpd5a042hAS5DV1YFLjbTjK1XbcXmpJc7mGR5prHc06gq762X8krydVQckEaqDteNHi/LZWyermJtneKSoh/YGGb7aPuZWkrx15TPP//7EDtx3ZzGwkizuQKqjkRaLv212jRYXzfVRzmvHPJF6IDMf9L2wSiolOWlJOy9jH7FNBZxhM6vS/in7v83gK1QAXM+++7rqF77lv1FcPq/P8UU8Fpp/Nbbj7X/F00H6bX6zzOtZaP5VbcdK5BraMRb6zXrfpZbt+IP1Ub7ksXf9vXH2t+MouI8sZ2j5yLgzJu/RXhNlAc1f/burqJclA46KU93PvYvYfsweR9VJGXbnxLij3p28eeb1ooyV7SxPznCcJKx2fB8t61s+bIw8fXLrvdxPKQy04znVOOy5JZVss65XNxAnCdt7x5Zj9tjM5ECqZ+34fQa2Xznms5WRt9Ep6Kple22PsxyQzGoVp3rffDLleYblmRzI82q9xmbF7eRtYvMpP2dWBx8RtdFlM23JyUCc6sIN9NBo/ECPIJIkcyzPs3b8egM7OTr4iKRLRgOOipOE1Y7v5tgkl0+xUi+0vx1PH6uMqI0mA46Kc0g71ouvoR3TZ15of8rqoPrwleZCdOmMOHnYxvxHM+wtAxLJ+k5D7Tgab72+btWOV63k56DdpbN/skPaMY9j3VmrNt/qm6zLpvQpSWLLpeE1WpbV0n9R+Znrd+bxPZupthav1L6sCgAAAAAAAAAAAAAAAAAAAAAAAAAAAADgUv8Hj9Rqx8Hn/FQAAAAASUVORK5CYII=" alt="" />

范例：数据删除

　　命令：　　DELETEFROM 表名称　WHRER 删除条件（） ；

String sql = "DELETE FROM member WHERE name = '张三'";

数据查询

数据查询的结果返回程序，由用户处理

在数据库中虽然有几百张数据表，但是数据表的数据组成的类型是固定的。

next

boolean next()

             throws SQLException

Moves the cursor froward one row from its current position

getInt

int getInt(String columnLabel)

           throws SQLException

等等。。。

    //开发标准，不写 *

        String sql = "SELECT mid,name,age,birthday,note FROM member";

        ResultSet rs = stmt.executeQuery(sql);

        while(rs.next()){

            int mid = rs.getInt("mid") ;

            String name = rs.getString("name") ;

            int age = rs.getInt("age") ;

            Date birthday = rs.getDate("birthday");

            String note = rs.getString("note");

            System.out.println(mid + ", " + name +", " + age + ", " + birthday +", " +note);

        }