dbaccess.java

java编写的database录入软件 支持exl格式

package database;

import java.sql.*; 

public class DBAccess 
{ 
	String sDBDriver = "oracle.jdbc.driver.OracleDriver"; 
	String url = "jdbc:oracle:thin:@localhost:1521:oradb"; 
	String sHint = ""; 
	ResultSet rs = null; 
	Connection conn = null; 
	Statement stmt = null; 
	String user = "system"; 
	String pwd = "lily"; 
	public DBAccess()
	{
		
	}
	public String getSHint()
	{ 
		return sHint; 
	} 

	public void setSDBDriver(String dbDriver)
	{ 
		sDBDriver = dbDriver; 
	} 

	public String getSDBDriver()
	{ 
		return sDBDriver; 
	} 

	public String getUrl()
	{ 
		return url; 
	} 

	public void setUrl(String s)
	{ 
		url = s; 
	} 

	public ResultSet getResultSet()
	{ 
		return rs; 
	} 

//	初始化 
	public boolean initialize(String dbDrive,String dbConn,String user,String pwd)
	{ 
		sDBDriver = dbDrive; 
		this.url = dbConn; 
		this.user = user; 
		this.pwd = pwd; 
		return initialize(); 
	} 

//	初始化 
	public boolean initialize()
	{ 
		try
		{ 
			Class.forName(sDBDriver); 
			sHint = "Initialization sucessfully"; 
			return true; 
		}
		catch(ClassNotFoundException e)
		{ 
			sHint = "Initialization Exception:" + e.getMessage(); 
			return false; 
		} 
	} 
//	执行查询语句 
	public ResultSet executeQuery(String sql)
	{ 
		rs = null; 
		try
		{ 
			conn = DriverManager.getConnection(url,user,pwd); 
			stmt = conn.createStatement(); 
			rs = stmt.executeQuery(sql); 
		}
		catch(SQLException ex)
		{ 
			sHint = "Query Exception:" + ex.getMessage(); 
		} 
		return rs; 
	} 

//	执行创建语句 
	public boolean executeCreat(String sql)
	{ 
		try
		{ 
			conn = DriverManager.getConnection(url,user,pwd); 
			stmt = conn.createStatement(); 
			stmt.executeUpdate(sql); 
			return true;
		}
		catch(SQLException ex)
		{ 
			sHint = "Creat Exception:" + ex.getMessage(); 
			return false;
		} 
	} 

//	执行更新语句 
	public boolean executeUpdate(String sql)
	{ 
		try
		{ 
			conn = DriverManager.getConnection(url,user,pwd); 
			stmt = conn.createStatement(); 
			stmt.executeUpdate(sql); 
			return true; 
		}
		catch(SQLException ex)
		{ 
			sHint = "Update Exception :" + ex.getMessage(); 
			return false; 
		} 
	} 

//	关闭连接、结果集、statemernt,释放资源 
	public boolean close()
	{ 
		try
		{ 
			if(rs != null) rs.close(); 
			if(stmt != null) stmt.close(); 
			if(conn != null) conn.close(); 
			return true; 
		}
		catch(SQLException ex)
		{ 
			sHint = "Close Exception:" + ex.getMessage(); 
			return false; 
		} 
	} 
	}