Skip to content

An Open-source Library for replacement of native JDBC protocol , DBJ.jar can easily connect to database with some Method, So user have to give the credentials and the parameter into the function ,DBJ will handle the rest part(Connection, Driver Manager, Prepared Statement, Resultset etc)

License

Notifications You must be signed in to change notification settings

soumyadip007/DBJ.jar

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 

Repository files navigation

DBJ.jar

A JAR file for replacement of native JDBC protocol ,which can connect to database by just calling some Methods, So user just have to give the credentials and the parameter into the function ,DBJ will handle the rest part(Connection, Driver Manager, Prepared Statement, Resultset etc. )

Requirements

For building and running the application you need:

  • JDK 1.8 or above
  • Database (MySql/Oracle/DB2/MySql Server) [MySql is preferable]

Call the following methods (Static) and pass appropriate parameters

  • Connection class (Set Universal Connection, Get Connection Object) @Overloading
  • Insert Class (Save method with Connection object, Save method without Connection object) @Overloading
  • Select Class (GetAll with Connection object,GetAll without Connection object,Get specific field with/without Connection object) @Overloading
  • Update Class (Yet to implement)
  • Delete Class (Yet to implement)
  • Trigger Class (Yet to implement)
  • Cascading Rollback for Transaction (Yet to implement)

Connection Class (package com.dbj.connection)

  • Set the connection object
	public static  void  Connect(String Driver,String Path,String Username,String Password) {
     	    ........
	}
  • Get the connection object
	public static  Connection  Connect(String Driver,String Username,String Password {
      	   ........
    	  return connection;
	}

Insert Class (package com.dbj.query)

  • Save the attributes (Don't pass connection object)
	public static void Save(String table_name, String[] parameters, String[] value) {
      	   ........
    	 }
  • Save the attributes (Pass connection object)
	public static void Save(Connection con, String table_name, String[] parameters, String[] value) {
      	   ........
    	 }

Select Class (package com.dbj.query)

  • Get all attributes from the table (Don't pass connection object)
	public static ResultSet GetAll(String table){
      	   ........
	   return resultSet;
    	 }
  • Get all attributes from the table (Pass connection object)
	public static ResultSet GetAll(Connection con,String table){
      	    ........
	   return resultSet;
    	 }
  • Get some specific attribute from the table (Don't pass connection object)
	public static ResultSet Get(String table,String index,String value){
      	    ........
	   return resultSet;
    	 }
  • Get some specific attribute from the table (Pass connection object)
	public static ResultSet Get(Connection con,String table,String index,String value){
      	    ........
	   return resultSet;
    	 }

Released

Yet to release (Maven Central Deployment)

  • Maven (POM.XML)
  • Gradle
  • SBT
  • Ivy
  • Grape
  • Leiningen
  • Buildr

Copyright @soumyadip007

Released under the Apache License 2.0. See the LICENSE file.

About

An Open-source Library for replacement of native JDBC protocol , DBJ.jar can easily connect to database with some Method, So user have to give the credentials and the parameter into the function ,DBJ will handle the rest part(Connection, Driver Manager, Prepared Statement, Resultset etc)

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published