A common approach to crud for JDBC

Package Com.platform_db.dao.impl;

Import java.sql.Connection;
Import java.sql.PreparedStatement;
Import Java.sql.ResultSet;
Import Java.sql.ResultSetMetaData;
Import java.util.ArrayList;
Import Java.util.HashMap;
Import java.util.List;
Import Java.util.Map;

Import Com.platform_db.dao.IObjectDao;
Import Com.platform_db.db.DBUtil;

public class Objectdaoimpl implements iobjectdao{
Public list<?> Find (String sql,object[] pars) throws Exception {
PreparedStatement PS = null;
ResultSet rs = null;

Connection conn = Dbutil.openconnection ();
PS = conn.preparestatement (SQL);
for (int i = 0;i < Pars.length; i++) {
Ps.setobject (i+1, pars[i]);
}
rs = Ps.executequery ();

list<map<string,object>> data = new arraylist<map<string,object>> ();

ResultSetMetaData MD = Rs.getmetadata ();
int columnCount = Md.getcolumncount ();
while (Rs.next ()) {
map<string, object> map = new hashmap<string, object> ();
for (int i = 1; I <= columnCount; i++) {
Map.put (Md.getcolumnname (i), rs.getobject (i));
}
Data.add (map);
}

Rs.close ();
Ps.close ();
Conn.close ();

return data;
}

public boolean exec (String sql, object[] pars) throws Exception {
Connection conn = Dbutil.openconnection ();
Conn.setautocommit (FALSE);

PreparedStatement PS = conn.preparestatement (SQL);
for (int i = 0;i < Pars.length; i++) {
Ps.setobject (i+1, pars[i]);
}
Boolean flag = Ps.execute ();

Conn.commit ();
Conn.setautocommit (TRUE);
Ps.close ();
Conn.close ();
return flag;
}

Public int[] Execbatch (String sql, list<object[]> List) throws Exception {
Connection conn = Dbutil.openconnection ();
Conn.setautocommit (FALSE);

PreparedStatement PS = conn.preparestatement (SQL);
For (object[] pars:list) {
for (int i = 0;i < Pars.length; i++) {
Ps.setobject (i+1, pars[i]);
}
Ps.addbatch ();
}

Int[] counts = Ps.executebatch ();

Conn.commit ();
Conn.setautocommit (TRUE);
Ps.close ();
Conn.close ();

return counts;
}
}

A common approach to crud for JDBC