Powered
by Ofer Dor
jMighty is a simple
and powerful database framework and connection pool management library
Manage
all your database
activities with jMighty.
|
Manage connections using jMighty library
Add imports to project
import jmighty.JFunDB.JFunDBPool;
import jmighty.JFunDB.JFunDBTool;
1) Connection pool
// create connection pool
JFunDBPool pool = new JFunDBPool();
pool.open("jdbc:mysql://localhost/mytestdb","root","",5,10,100);
or
// create MySQL connection pool
JFunDBPool pool = new JFunDBPool();
pool.openMySQLConnPool("localhost","mytestdb","root","",5,10,100);
...
// close connection pool
pool.close(); 2) Get and return connection from and to the pool
// get database connection from the pool
JFunDBTool db = new JFunDBTool();
db.open();
...
// return
database connection to the pool
db.close();
Manage
all database operations/activities using jMighty library1) Insert row/s with transaction
// insert two rows with transaction
try
{
db.beginTransaction();
HashMap fieldValues = new HashMap();
fieldValues.put("A",1);
fieldValues.put("B","stam123");
fieldValues.put("C",new Date());
db.insert("tests",fieldValues);
fieldValues.put("A","2");
db.insert("tests",fieldValues);
db.commitTransaction();
}
catch(Exception e)
{
db.rollbackTransaction();
}
2)
Update row/s // update row/s - put "stam666" in
field B for all rows where A=2
try
{
db.beginTransaction();
HashMap fieldValues = new HashMap();
HashMap filterValues = new HashMap();
fieldValues.put("B","stam666");
filterValues.put("a",2);
db.update("tests",fieldValues,"A=#a#",filterValues);
db.commitTransaction();
}
catch(Exception e)
{
db.rollbackTransaction();
}
3)
Delete row/s
// delete all rows in
table=tests where A=1
n = db.delete("tests", "A=1");
4)
Query and Select
// simple
query
List list = db.query("select * from tests
where A=2");
// query tests table
try
{
System.out.println("Enter query");
String sql = "select A,B from tests where A=#a# and B=#b# and A>#c#";
HashMap atts = new HashMap();
atts.put("a",2);
atts.put("b","stam666");
atts.put("c",0);
List list = db.query(sql,atts);
for (int i=0; i<list.size(); i++)
{
Map map = (Map) list.get(i);
int a = (Integer) map.get("A");
String b = (String) map.get("B");
System.out.println("a="+String.valueOf(a)+",b="+b);
}
}
catch(Exception e)
{
}
// select tests table
try
{
System.out.println("Enter select");
String fields = "A,B";
String tables = "tests";
String filter = "A=#a# and B=#b# and A>#c#";
HashMap filterValues = new HashMap();
filterValues.put("a",2);
filterValues.put("b","stam666");
filterValues.put("c",0);
List list = db.select(fields,tables,filter,filterValues);
for (int i=0; i<list.size(); i++)
{
Map map = (Map) list.get(i);
int a = (Integer) map.get("A");
String b = (String) map.get("B");
System.out.println("a="+String.valueOf(a)+",b="+b);
}
}
catch(Exception e)
{
}
5)
Count rows // count rows in result
try
{
String sql = "select * from tests";
int count = db.count(sql);
System.out.println("count="+String.valueOf(count));
}
catch(Exception e)
{
}
6)
Paging (get a specific page) // paging (sql)
String sql = "select A,B from tests where A=#a# and B=#b# and A>#c#";
sql = db.getSqlPaging(sql,3,10);
System.out.println("paging: page-num=3,rows-per-page=10,sql="+sql);
System.out.println("page1:0..9, page2:10..19, page3:20..29, page4:30..30, ...");
// paging (filter)
HashMap filterValues = new HashMap();
filterValues.put("a",2);
filterValues.put("b","stam666");
filterValues.put("c",0);
String fields = "*";
String tables = "tests";
String filter = "A=#a# and B=#b# and A>#c#";
filter = db.getSqlPaging(filter,3,10);
List list = db.select(fields,tables,filter,filterValues);
The table used in the examples above:
|
Please find more simple features by downloading and using jMighty.