dbmanager.java

使用Java和sql开发的固定资产管理系统!

package model;
import java.sql.*;
public class DBManager{
	public DBManager()
	{
		try{
			//注册SQL2000数据库的纯JAVA JDBC连接
				Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			}
			catch(ClassNotFoundException e1)
			{
				System.out.println(e1);
			}
			try
			{
				 rul="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=EquipManager;";
				 conn=DriverManager.getConnection(rul,"Accp","Accp");
				 stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			}
			catch(SQLException e2)
			{
				System.out.println(e2);
			}			
	}
	//查操作
	public ResultSet getResult(String sql){
		
		try{
			
			re=stmt.executeQuery(sql);
			
			return re;
		}
		catch(Exception e3){
			System.out.println("getResult------"+e3.toString());
			return null;
		}
	}
	//增,删,改操作
	public boolean executeSql(String sql){
		try
		{
			stmt.executeUpdate(sql);
			conn.commit();
			return true;
		}
		catch(Exception e4){
			System.out.println("executeSql----"+e4.toString());
			return false;
		}
	}
	//关闭所有连接
	public boolean closeResultSet()
	{
		try
		{
			re.close();
			stmt.close();
			conn.close();
			
			return true;
		}catch(SQLException e5)
		{
			System.out.println(e5);
			return false;
		}
	}
	ResultSet re;
	String rul;
	Connection conn;
	Statement stmt;
	
}