databasemanager.java

图书馆系统＿毕业设计数据库是access的做得还可以的有需要的下载下来

//连接数据库
import java.sql.*;
public class DataBaseManager
{
	Connection con;
	ResultSet rs;
	Statement stmt;
	public DataBaseManager()
	{
       try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	   	        }
	   	   catch(ClassNotFoundException e)
	   	        { System.out.println(""+e);
		    }




		try{
		//DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
		con=DriverManager.getConnection("jdbc:odbc:redsun","11","11");
		stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
	}
	catch(SQLException sqle)
	{
		System.out.println(sqle.toString());
	}
	}
	public ResultSet getResult(String strSQL)
	{
		try{
		rs=stmt.executeQuery(strSQL);
		return rs;
	}
	catch(SQLException sqle)
	{
		System.out.println(sqle.toString());
		return null;
	}

   }
     public boolean updateSql(String strSQL)
        {
        	try{

			//con=DriverManager.getConnection("jdbc:odbc:redsun","maimihui","maimihui");
        	stmt.executeUpdate(strSQL);
        	//con.commit();
        	//con.close();

                return true;

        }
        catch(SQLException sqle)
        {
        	System.out.println(sqle.toString());
        	return false;
        }

        }
        public void closeConnection()
        {
        	try
        	{
        		con.close();
        	}
        	catch(SQLException sqle)
        	{
        		System.out.println(sqle.toString());
        	}
        }

}