import java.sql.*;

public class CleanTestData {
    public static void main(String[] args) {
        try {
            Class.forName("dm.jdbc.driver.DmDriver");
            Connection conn = DriverManager.getConnection("jdbc:dm://192.168.0.145:30236?charset=utf8", "WATERSHED", "WaterShed./1224");
            Statement stmt = conn.createStatement();
            
            // ???6??????????7??ID=11?
            System.out.println("???6?????...");
            stmt.executeUpdate("DELETE FROM WATERSHED_MODEL WHERE MODEL_ID <= 10");
            
            // ??????
            ResultSet rs = stmt.executeQuery("SELECT COUNT(*) FROM WATERSHED_MODEL");
            if (rs.next()) {
                System.out.println(" ??????????: " + rs.getInt(1));
            }
            
            // ????????
            System.out.println("\n??????:");
            rs = stmt.executeQuery("SELECT * FROM WATERSHED_MODEL");
            while (rs.next()) {
                System.out.println("  - ID: " + rs.getLong("MODEL_ID") + 
                                  ", NAME: " + rs.getString("MODEL_NAME") + 
                                  ", TYPE: " + rs.getString("MODEL_TYPE"));
            }
            
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}