testdml.java~13~

梅花雪树的经典制作

package com.test;
import java.sql.*;

public class TestDML {
    public static void main(String args[]) {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            String url = "jdbc:oracle:thin:@127.0.0.1:1521:lanhai";
            Connection conn = DriverManager.getConnection(url, "wygb", "wygb");
            conn.setAutoCommit(false);
            Statement stmt = conn.createStatement();
            stmt.executeUpdate("insert into mydept values(3,'wyg003','wyg003')");
            stmt.executeUpdate("insert into mydept values(4,'wyg004','wyg004')");

            ResultSet rs = stmt.executeQuery("select * from mydept");
            while (rs.next()) {
                System.out.print("学号: " + rs.getString(1));
                System.out.print("\t姓名: " + rs.getString(2));
                System.out.println("\t描述: " + rs.getString(3));
            }
            rs.close();
            stmt.executeUpdate("update mydept set descp='mydescp' ");
            stmt.executeUpdate("delete from mydept where mydeptid='2'");
            System.out.println("--------------更新/删除数据后---------------");
            rs = stmt.executeQuery("select * from mydept");
            while (rs.next()) {
                System.out.print("学号: " + rs.getString(1));
                System.out.print("\t姓名: " + rs.getString(2));
                System.out.println("\t描述: " + rs.getString(3));
            }

            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}