thieumao

Delete - MySQL - Java

Oct 31st, 2013
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.12 KB | None | 0 0
  1. package testmysql;
  2.  
  3. import com.mysql.jdbc.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.SQLException;
  6. import java.sql.Statement;
  7.  
  8. public class DeleteMySQL {
  9.  
  10.     private Connection conn;
  11.  
  12.     public void testConnectMySQL() {
  13.         String db = "TestMySQL"; //Tên database
  14.         String user = "root"; //Mặc định là root
  15.         String pass = "admin"; //Mật khẩu quản trị MySQL
  16.         try {
  17.             String url = "jdbc:mysql://localhost/" + db + "?user=" + user + "&password=" + pass;
  18.             Class.forName("com.mysql.jdbc.Driver");
  19.             conn = (Connection) DriverManager.getConnection(url);
  20.             System.out.println("Kết nối thành công.");
  21.  
  22.             Statement stmt = conn.createStatement();
  23.             String sql = "DELETE FROM user where id>5";
  24.             stmt.executeUpdate(sql);
  25.             stmt.close();
  26.  
  27.         } catch (Exception e) {
  28.             System.out.println("Lỗi: " + e.getMessage());
  29.         }
  30.     }
  31.  
  32.     public static void main(String[] args) {
  33.         DeleteMySQL tm = new DeleteMySQL();
  34.         tm.testConnectMySQL();
  35.     }
  36. }
Advertisement
Add Comment
Please, Sign In to add comment