Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package testmysql;
- import com.mysql.jdbc.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class UpdateMySQL {
- private Connection conn;
- public void testConnectMySQL() {
- String db = "TestMySQL"; //Tên database
- String user = "root"; //Mặc định là root
- String pass = "admin"; //Mật khẩu quản trị MySQL
- try {
- String url = "jdbc:mysql://localhost/" + db + "?user=" + user + "&password=" + pass;
- Class.forName("com.mysql.jdbc.Driver");
- conn = (Connection) DriverManager.getConnection(url);
- System.out.println("Kết nối thành công.");
- Statement stmt = conn.createStatement();
- String sql = "UPDATE user SET username='ThieuMao', password='LeoLinhTinh' WHERE id='1'";
- stmt.executeUpdate(sql);
- stmt.close();
- } catch (Exception e) {
- System.out.println("Lỗi: " + e.getMessage());
- }
- }
- public static void main(String[] args) {
- UpdateMySQL tm = new UpdateMySQL();
- tm.testConnectMySQL();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment