package abc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;

public class MySQL1 {

	public static void main(String[] args) throws SQLException {
		// TODO Auto-generated method stub
				Scanner input = new Scanner(System.in);
				DBHelper db = new DBHelper();
				System.out.println("删除用户");
				System.out.println("输入要删除用户的编号:");
				int id = input.nextInt();
				String sql = "delete from admin where id=?;";
				int rows = db.exeCommand(sql, new Object[] {id});
					if(rows>0) {
						System.out.println("删除成功");
					}else {
						System.out.println("删除失败");
					}
				
				}
}

//这个是和DBHelper连用的