sqlbean.java

来自「基于UML的书店采购管理系统设计主要是供书店管理员使用。系统提供了管理员登陆」· Java 代码 · 共 123 行

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package book_booking;
import java.sql.*;
/**
 *
 * @author Administrator
 */
public class SqlBean 
{
        private Connection conn=null;
	private ResultSet rs=null;
	   //Database driver
	private String DatabaseDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	   //Database sourse 
	private String DatabaseConnStr="jdbc:odbc:star";
	   //ID to login
	private String LogId="wsw";
	   //Password to login
	private String LogPass="232425";
	
	   //Constructor method
	public SqlBean()
	{
		try
		{
			Class.forName(DatabaseDriver);
		}
		catch(ClassNotFoundException ex)
		{
            System.err.println(ex);
		}
	}
	   
	   //select
	public ResultSet executeQuery(String sql)
	{
		rs=null;
		try
		{
			conn = DriverManager.getConnection(DatabaseConnStr,LogId,LogPass);
			Statement stmt=conn.createStatement();
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException ex)
		{
            System.err.println(ex);
		}
	
		return rs;
	}
	   
	   //insert
	public int executeInsert(String sql)
	{
		int num=0;
		try
		{
			conn = DriverManager.getConnection(DatabaseConnStr,LogId,LogPass);
			Statement stmt=conn.createStatement();
			num=stmt.executeUpdate(sql);
		}
		catch(SQLException ex)
		{
            System.err.println(ex);
		}
		
		return num;
	} 
	   
	   //delete
	public int executeDelete(String sql)
	{
		int num=0;
		try
		{
			conn = DriverManager.getConnection(DatabaseConnStr,LogId,LogPass);
			Statement stmt=conn.createStatement();
			num=stmt.executeUpdate(sql);
		}
		catch(SQLException ex)
		{
            System.err.println(ex);
		}
	
		return num;
	}
	
	   //update
	public int executeUpdate(String sql)
	{
		int num=0;
		try
		{
			conn = DriverManager.getConnection(DatabaseConnStr,LogId,LogPass);
			Statement stmt=conn.createStatement();
			num=stmt.executeUpdate(sql);
		}
		catch(SQLException ex)
		{
            System.err.println(ex);
		}
	
		return num;
	}
	   
	   //close
	public void CloseDataBase()
	{
		try
		{
			conn.close();
		}
		catch(Exception ex)
		{
            System.err.println(ex);
		}
	}
}