dbmanage.java

本系统的设计模拟一般学校特别是高校的图书借阅管理内容

/*
 * Copyright (c) 2006 guodongping. All  Rights Reserved.
 * 
 * E-mail: [e-mail]
 * QQ:     445938759
 */
//package library;

import java.sql.*;
import javax.swing.JOptionPane;
/**
 * @author guodongping
 * 创建日期 2006-1-13
 *
 * 数据库操作
 */
public class DbManage {
	
	private Statement sta;
	
	public void setStatement(Connection con)
	{
		try{
			this.sta=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
		}
		catch(Exception e)
		{
			JOptionPane.showMessageDialog(null,e.toString(),"错误",JOptionPane.WARNING_MESSAGE);
			e.printStackTrace();
		}
	}
	
	public void closeStatement()
	{
		try{
			sta.close();
		}
		catch(Exception e)
		{
			JOptionPane.showMessageDialog(null,e.toString(),"错误",JOptionPane.WARNING_MESSAGE);
			e.printStackTrace();
		}
	}
	
	public ResultSet executeQuery(String sqlCommand)
	{
		try{
			return sta.executeQuery(sqlCommand);
		}
		catch(Exception e)
		{
			e.printStackTrace();
			JOptionPane.showMessageDialog(null,e.toString(),"错误",JOptionPane.WARNING_MESSAGE);
		}
		return null;
	}
	
	public void executeUpdate(String sqlCommand)
	{
		try{
			sta.executeUpdate(sqlCommand);
		}
		catch(Exception e)
		{
			e.printStackTrace();
			JOptionPane.showMessageDialog(null,e.toString(),"错误",JOptionPane.WARNING_MESSAGE);
		}
	}
	
	public void executeInsert(String sqlCommand)
	{
		try{
			sta.executeUpdate(sqlCommand);
		}
		catch(Exception e)
		{
			e.printStackTrace();
			JOptionPane.showMessageDialog(null,e.toString(),"错误",JOptionPane.WARNING_MESSAGE);
		}
	}
	
	public void executeDelete(String sqlCommand)
	{
		try{
			sta.executeUpdate(sqlCommand);
		}
		catch(Exception e)
		{
			e.printStackTrace();
			JOptionPane.showMessageDialog(null,e.toString(),"错误",JOptionPane.WARNING_MESSAGE);
		}
	}

}