Crud.rar_operation_servlet

import java.util.*; import java.sql.*; public class EmpDao { public static Connection getConnection(){ Connection con=null; try{ Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","tiger"); }catch(Exception e){System.out.println(e);} return con; } public static int save(Pro e){ int status=0; try{ Connection con=EmpDao.getConnection(); PreparedStatement ps=con.prepareStatement( "insert into productdetails(product_id,product_cost,description) values (?,?,?)"); ps.setInt(1,e.getProductid()); ps.setInt(2,e.getProductcost()); ps.setString(3,e.getProductdescription()); status=ps.executeUpdate(); con.close(); }catch(Exception ex){ex.printStackTrace();} return status; } public static int update(Pro e){ int status=0; try{ Connection con=EmpDao.getConnection(); String selectSQL ="update productdetails set product_cost=?,description=? where product_id=?"; PreparedStatement ps=con.prepareStatement(selectSQL); ps.setInt(1,e.getProductcost()); ps.setString(2,e.getProductdescription()); ps.setInt(3,e.getProductid()); status=ps.executeUpdate(); con.close(); }catch(Exception ex){ex.printStackTrace();} return status; } public static int delete(int id){ int status=0; try{ Connection con=EmpDao.getConnection(); PreparedStatement ps=con.prepareStatement("delete from productdetails where product_id=?"); ps.setInt(1,id); status=ps.executeUpdate(); con.close(); }catch(Exception e){e.printStackTrace();} return status; } public static Pro getProductById(int id){ Pro e=new Pro(); try{ Connection con=EmpDao.getConnection(); PreparedStatement ps=con.prepareStatement("select * from productdetails where product_id=?"); ps.setInt(1,id); ResultSet rs=ps.executeQuery(); if(rs.next()){ e.setProductid(rs.getInt(1)); e.setProductcost(rs.getInt(2)); e.setProductdescription(rs.getString(3)); } con.close(); }catch(Exception ex){ex.printStackTrace();} return e; } public List<Pro> getAllProducts(){ List<Pro> list=new ArrayList<Pro>(); try{ Connection con=EmpDao.getConnection(); PreparedStatement ps=con.prepareStatement("select * from productdetails"); ResultSet rs=ps.executeQuery(); while(rs.next()){ Pro e=new Pro(); e.setProductid(rs.getInt(1)); e.setProductcost(rs.getInt(2)); e.setProductdescription(rs.getString(3)); list.add(e); } con.close(); }catch(Exception e){e.printStackTrace();} return list; } }