delete.java

来自「B/S架构的软件项目实训；包括全部详细文档合源程序」· Java 代码 · 共 19 行

import java.sql.*;
import java.io.*;
class Delete 
{
	public static void main(String[] args) 
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection conn=DriverManager.getConnection("jdbc:odbc:test");
			Statement stmt=conn.createStatement();
			String strUpdate="DELETE accountInfo WHERE accountNo='A00001'";
			int rows=stmt.executeUpdate(strUpdate);
			System.out.println(rows+" row(s) affected");
			conn.close();
		}catch(Exception e){System.out.print(e);}
	}
}