JDBC实现基本的CRUD示例

private static void insertTest() throws SQLException

{

    String dbURL = "jdbc:mysql://localhost/test";

    Connection con = DriverManager.getConnection(dbURL, "root", "123");

    Statement st = con.createStatement();

    st.execute("insert into user(ID,NAME) values(1, 'Zhang San')");

    st.execute("insert into user(ID,NAME) values(2, 'Li Si')");

    st.execute("insert into user(ID,NAME) values(3, 'Wang Wu')");

    System.out.println("=====insert test=====");

    showUser(st);

    st.close();

    con.close();

}

private static void deleteTest() throws SQLException

{

    String dbURL = "jdbc:mysql://localhost/test";

    Connection con = DriverManager.getConnection(dbURL, "root", "123");

    Statement st = con.createStatement();

    st.execute("delete from user where ID=3");

    System.out.println("=====delete test=====");

    showUser(st);

    st.close();

    con.close();

}

private static void updateTest() throws SQLException

{

    String dbURL = "jdbc:mysql://localhost/test";

    Connection con = DriverManager.getConnection(dbURL, "root", "123");

    Statement st = con.createStatement();

    st.executeUpdate("update user set NAME='TEST' where ID=2");

    System.out.println("=====update test=====");

    showUser(st);

    st.close();

    con.close();

}

private static void showUser(Statement st) throws SQLException

{

    ResultSet rs = st.executeQuery("select ID, NAME from user");

    while(rs.next())

    {

        int id = rs.getInt("ID");

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

        System.out.println("ID:" + id + "; NAME=" + name);

    }

    rs.close();

}