testdml.java~6~

梅花雪树的经典制作

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");
            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 student");
            while (rs.next()) {
                System.out.print("学号: " + rs.getString(1));
                System.out.print("\t姓名: " + rs.getString(2));
                System.out.println("\t年龄: " + rs.getInt(3));
            }
            rs.close();
            stmt.executeUpdate("update student set age=age+10");
            stmt.executeUpdate("delete from student where sid='J002'");
            System.out.println("--------------更新/删除数据后---------------");
            rs = stmt.executeQuery("select * from student");
            while (rs.next()) {
                System.out.print("学号: " + rs.getString("sid"));
                System.out.print("\t姓名: " + rs.getString("name"));
                System.out.println("\t年龄: " + rs.getInt("age"));
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}