package com.vikas.bean;
import java.util.Date;
import com.mysql.jdbc.Blob;
public class EmployeeBean { private String name; private double salary; private String bday; private Blob image; public String getName() { return name; } public void setName(String name) { this.name = name; } public double getSalary() { return salary; } public void setSalary(double salary) { this.salary = salary; }
public String getBday() { return bday; } public void setBday(String bday) { this.bday = bday; } public Blob getImage() { return image; } public void setImage(Blob image) { this.image = image; } }
package com.vikas.commons;
import java.sql.Connection;import java.sql.DriverManager;
public class BaseConnection { private static Connection conn=null; public static Connection getConnection(){ try{ Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","vikas123"); }catch (Exception e) { e.printStackTrace(); } return conn; } public static void main(String[] args) { System.out.println(getConnection().toString()); }
}
package com.vikas.commons;
import java.text.SimpleDateFormat;import java.util.Date;
public class DateFormatter { public static String dateToString(Date date){ try{ SimpleDateFormat sdf=new SimpleDateFormat("dd-MM-yyyy"); if(date!=null){ String sdate=sdf.format(date); return sdate; } } catch(Exception e) { e.printStackTrace(); } return null; } public static Date stringToDate(String sDate){ try{ SimpleDateFormat sdf=new SimpleDateFormat("dd-MM-yyyy"); if(sDate!=null){ Date date=sdf.parse(sDate); return date; } } catch(Exception e) { e.printStackTrace(); } return null; } public static String stringToSqlDate(String sDate){ try{ SimpleDateFormat sdf=new SimpleDateFormat("dd-MM-yyyy"); if(sDate!=null){ Date date=sdf.parse(sDate); java.sql.Date sqlDate = new java.sql.Date(date.getTime()); return sqlDate.toString(); } } catch(Exception e) { e.printStackTrace(); } return null; }
}
package com.vikas.dao;
import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.Statement;import java.util.ArrayList;import java.util.Date;
import com.vikas.bean.EmployeeBean;import com.vikas.commons.BaseConnection;import com.vikas.commons.DateFormatter;
public class EmployeeDAO { public void save(EmployeeBean emp){ try{ Connection conn = BaseConnection.getConnection(); /*Statement stmt = conn.createStatement(); String sql = "INSERT INTO employee(name,salary,birthday) VALUES('"+emp.getName()+"',"+emp.getSalary()+",'"+DateFormatter.stringToSqlDate(emp.getBday())+"')"; System.out.println(sql); stmt.executeUpdate(sql);*/ PreparedStatement pst = conn.prepareStatement("INSERT INTO employee(name,salary,birthday) VALUES(?,?,?)"); pst.setString(1, emp.getName()); pst.setDouble(2, 10000); pst.setString(3, DateFormatter.stringToSqlDate(emp.getBday())); //pst.setDate(3, DateFormatter.stringToDate(emp.getBday())); pst.executeUpdate(); System.out.println("Data Saved"); }catch (Exception e) { e.printStackTrace(); } } public void update(EmployeeBean emp){ try{ Connection conn = BaseConnection.getConnection(); PreparedStatement pst = conn.prepareStatement("UPDATE employee SET salary=?,birthday=? WHERE name=?"); pst.setDouble(1, emp.getSalary()); pst.setString(2, DateFormatter.stringToSqlDate(emp.getBday())); pst.setString(3, emp.getName()); pst.executeUpdate(); }catch (Exception e) { e.printStackTrace(); } } public void delete(String id){ try{ Connection conn = BaseConnection.getConnection(); PreparedStatement pst = conn.prepareStatement("DELETE FROM employee WHERE name=?"); pst.setString(1, id); pst.executeUpdate(); }catch (Exception e) { e.printStackTrace(); } } public EmployeeBean find(String id){ try{ Connection conn = BaseConnection.getConnection(); PreparedStatement pst = conn.prepareStatement("SELECT * FROM employee WHERE name=?"); pst.setString(1, id); ResultSet rs = pst.executeQuery(); EmployeeBean emp = new EmployeeBean(); if(rs.next()){ emp.setName(rs.getString(1)); emp.setSalary(rs.getDouble(2)); emp.setBday(DateFormatter.dateToString(rs.getDate(3))); } return emp; }catch (Exception e) { e.printStackTrace(); } return null; } public ArrayList
findAll(){ try{ Connection conn = BaseConnection.getConnection(); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM employee"); ArrayList emps = new ArrayList(); while(rs.next()){ EmployeeBean emp = new EmployeeBean(); emp.setName(rs.getString(1)); emp.setSalary(rs.getDouble(2)); emp.setBday(DateFormatter.dateToString(rs.getDate(3))); emps.add(emp); } return emps; }catch (Exception e) { // TODO: handle exception } return null; }
public static void main(String[] args) { EmployeeDAO dao = new EmployeeDAO(); EmployeeBean empbean = new EmployeeBean(); /*empbean.setName("Auro d'morgan"); empbean.setSalary(7000.0); empbean.setBday("21-12-2009"); dao.update(empbean);*/ empbean=dao.find("amit"); //dao.delete("Auro d'morgan"); System.out.println(empbean.getName()+" "+empbean.getSalary()+" "+empbean.getBday()); empbean.setSalary(1111); /*ArrayList emps= dao.findAll(); for(EmployeeBean emp :emps){ System.out.println(emp.getName()+" "+emp.getSalary()+" "+emp.getBday()); }*/ }}
Posts
