deletedata.java

来自「远程电子考试系统」· Java 代码 · 共 53 行

package dbconnect;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;

import java.sql.PreparedStatement;
import java.sql.SQLException;

public class DeleteData {

	/**
	 * @param args
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws SQLException {
		// TODO 自动生成方法存根
		PreparedStatement ps;

		String sqlString;
		String name;
        int k;
		DbConnect dbcon=new DbConnect();
		dbcon.connect();
		name = getInput("请输入待删除的用户名：");
		sqlString = "delete from result where name='"+name+"'";
		ps = (dbcon.getConnction()).prepareStatement(sqlString);
		k=ps.executeUpdate(sqlString); 
        System.out.println("删除了"+k+"条记录");

		//ps.executeUpdate();
		System.out.println("删除成功!");
		if (dbcon.getConnction() == null) {
			System.out.println("数据库连接失败");
		} else
			System.out.println("数据库连接成功");
	  dbcon.disconnect();
	}
	public static String getInput(String msg) {
		String result = null;
		try {
			// 创建用户输入流
			BufferedReader in = new BufferedReader(new InputStreamReader(
					System.in));
			System.out.print(msg);
			result = in.readLine();
		} catch (IOException e) {
			e.printStackTrace();
		}
		return result;
	}
}