Package Com.pro.dao.impl;
Import Java.sql.Date;
Import java.sql.PreparedStatement;
Import Java.sql.ResultSet;
Import java.sql.SQLException;
Import java.sql.Statement;
Import java.sql.Connection;
Import Java.sql.Types;
Import Java.util.Vector;
Import oracle.jdbc.OracleCallableStatement;
Import Oracle.jdbc.OracleTypes;
Import Com.pro.dao.EmpDao;
Import Com.pro.dao.comm.DBConfigUtil;
Import com.pro.dao.comm.DBConnection;
Import COM.PRO.POJO.EMP;
public class Empdaoimpl implements Empdao {
@Override
public boolean Insert (EMP emp) {
Boolean issuccess = false;
Connection Connection = Dbconnection.getconnection ();
String sql = "INSERT into EMP values (?,?,?,?,?,?,?,?)";
PreparedStatement statement = null;
try {
statement = connection.preparestatement (SQL);
Populate the placeholder with the actual data
Statement.setint (1, Emp.getempno ());
Statement.setstring (2, Emp.getename ());
Statement.setstring (3, Emp.getjob ());
if (emp.getmgr () = = 0) {
Statement.setobject (4, NULL);
} else {
Statement.setint (4, Emp.getmgr ());
}
Statement.setdate (5, New Date (Emp.gethiredate (). GetTime ()));
Statement.setdouble (6, Emp.getsal ());
Statement.setdouble (7, Emp.getcomm ());
Statement.setint (8, Emp.getdeptno ());
int result = Statement.executeupdate ();
if (Result > 0) {
Issuccess = true;
System.out.println ("Insert succeeded!" + result);
} else {
System.out.println ("Insert failed!");
}
} catch (SQLException e) {
TODO auto-generated Catch block
E.printstacktrace ();
} finally {
Dbconnection.close (NULL, statement, connection);
}
return issuccess;
}
@Override
public boolean update (String exp) {
TODO auto-generated Method Stub
return false;
}
@Override
public boolean Delete (String exp) {
Boolean issuccess = false;
Connection Connection = Dbconnection.getconnection ();
String sql = "Delete from emp where" + exp;
Statement Statement = null;
try {
statement = Connection.createstatement ();
int result = statement.executeupdate (SQL);
if (Result > 0) {
Issuccess = true;
System.out.println ("Delete succeeded!" + result);
} else {
System.out.println ("Delete failed!");
}
} catch (SQLException e) {
TODO auto-generated Catch block
E.printstacktrace ();
} finally {
Dbconnection.close (NULL, statement, connection);
}
return issuccess;
}
@Override
public Boolean Delete () {
Boolean issuccess = false;
Connection Connection = Dbconnection.getconnection ();
//
String sql = "Delete from emp";
Statement Statement = null;
try {
statement = Connection.createstatement ();
int result = statement.executeupdate (SQL);
//
if (Result > 0) {
Issuccess = true;
System.out.println ("Delete succeeded!" + result);
} else {
System.out.println ("Delete failed!");
// }
} catch (SQLException e) {
TODO auto-generated Catch block
E.printstacktrace ();
} finally {
Dbconnection.close (NULL, statement, connection);
// }
Return dbconnection.executeupdate ("Delete from emp", NULL) > 0? True
: false;
}
@Override
Public EMP Search (String exp) {
TODO auto-generated Method Stub
return null;
}
@Override
Public vector<emp> Searchmuil (String exp) {
TODO auto-generated Method Stub
return null;
}
@Override
Public vector<emp> Search () {
vector<emp> allemp = new vector<emp> ();
Connection Connection = Dbconnection.getconnection ();
//
String sql =
"Select Empno,ename,job,mgr,hiredate,sal,comm,deptno from emp";
Statement Statement = null;
ResultSet ResultSet = null;
try {
statement = Connection.createstatement ();
ResultSet = statement.executequery (sql);
ResultSet = Dbconnection.executequery (
"Select Empno,ename,job,mgr,hiredate,sal,comm,deptno from emp",
NULL);
while (Resultset.next ()) {
EMP emp = new EMP ();
Emp.setempno (Resultset.getint (1));
Emp.setename (resultset.getstring ("ename"));
Emp.setjob (resultset.getstring ("job"));
Emp.setmgr (Resultset.getint ("Mgr"));
Emp.sethiredate (Resultset.getdate ("HireDate"));
Emp.setsal (resultset.getdouble ("Sal"));
Emp.setcomm (resultset.getdouble ("comm"));
Emp.setdeptno (Resultset.getint ("Deptno"));
Allemp.add (EMP);
}
} catch (SQLException e) {
TODO auto-generated Catch block
E.printstacktrace ();
}
finally {
Dbconnection.close (NULL, statement, connection);
// }
return allemp;
}
@Override
Public vector<emp> Search (int pagenum) {
vector<emp> allemp = new vector<emp> ();
Connection Connection = Dbconnection.getconnection ();
String sql = "{call Data_control.pagedata (' SCOTT. EMP ',?,?,?)} ";
Oraclecallablestatement statement = null;
ResultSet ResultSet = null;
try {
statement = (oraclecallablestatement) connection.preparecall (SQL);
Statement.setint (1, pagenum);
Statement.setint (2, Integer.parseint (dbconfigutil
. GetProperty ("Page.default.count")));
Statement.registeroutparameter (3, oracletypes.cursor);
Statement.execute ();
ResultSet = Statement.getcursor (3);
while (Resultset.next ()) {
EMP emp = new EMP ();
Emp.setempno (Resultset.getint (1));
Emp.setename (resultset.getstring ("ename"));
Emp.setjob (resultset.getstring ("job"));
Emp.setmgr (Resultset.getint ("Mgr"));
Emp.sethiredate (Resultset.getdate ("HireDate"));
Emp.setsal (resultset.getdouble ("Sal"));
Emp.setcomm (resultset.getdouble ("comm"));
Emp.setdeptno (Resultset.getint ("Deptno"));
Allemp.add (EMP);
}
} catch (SQLException e) {
TODO auto-generated Catch block
E.printstacktrace ();
} finally {
Dbconnection.close (ResultSet, statement, connection);
}
return allemp;
}
}
Simple additions and deletions to check and change