deletebookdb.java

来自「本系统完成简单的图书管理系统」· Java 代码 · 共 53 行

/***********************************************************************
*                          湖南大学图书管理系统
* @author Administrator                                                         
* @since 2008.06                                                  
* @version 1.0                                                           															  
* @category 删除图书数据库操作
*************************************************************************/

package library.DBaccess;


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

import library.DBBase.JDBC;

public class DeleteBookDB {

	public DeleteBookDB() {
		// TODO Auto-generated constructor stub
		super();
	}

	
	public void DeleteBook(String isbn){
		JDBC jdbc = new JDBC();
		Connection con = jdbc.getConnection();
		
		String sql = "delete from book where ISBN = '"+isbn+"'";
		
		try{
			PreparedStatement ps =con.prepareStatement(sql);
			ps.executeUpdate();
			System.out.println("删除成功");
		}catch(SQLException e)
		{
			e.printStackTrace();
		}
	}
	
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

		DeleteBookDB dbdb = new DeleteBookDB();
		dbdb.DeleteBook("546973134");
	}

}