Java数据库编程(执行数据库删除操作)

来源:互联网 发布:淘宝企业开店店铺名称 编辑:程序博客网 时间:2024/06/05 20:00
package org.dml;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;


public class DeleteDemo {
public static final String DBDRIVER = "org.gjt.mm.mysql.Driver";
public static final String url = "jdbc:mysql://localhost:3306/mldn";
public static final String user = "root";
public static final String password = "root";
public static void main(String[] args) throws Exception{
Connection conn = null;
Statement stmt = null;
String sql = "delete from user where id = 3";
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
}
0 0
原创粉丝点击