DriverDao.java package com.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.bean.Driver; import com.util.DbUtil; public class DriverDao { Connection con; PreparedStatement ps; ResultSet rs; public boolean add(Driver d) throws SQLException { con=DbUtil.getConnection(); ps=con.prepareStatement("insert into DriverCab values(?,?,?,?,?,?)"); ps.setInt(1, d.getAadhar()); ps.setString(2, d.getName()); ps.setInt(3, d.getAge()); ps.setString(4, d.getGender()); ps.setString(5, d.getAddress()); ps.setDouble(6, d.getSalary()); int r=ps.executeUpdate(); ps.close(); con.close(); if(r!=0) return true; else return false; } public Driver search(String name) throws SQLException { con=DbUtil.getConnection(); Driver d=new Driver(); ps=con.prepareStatement("select * from DriverCab where name=?"); ps.setString(1, name); rs=ps.executeQuery(); while(rs.next()) { d.setAadhar(rs.getInt(1)); d.setName(rs.getString(2)); d.setAge(rs.getInt(3)); d.setGender(rs.getString(4)); d.setAddress(rs.getString(5)); d.setSalary(rs.getDouble(6)); } ps.close(); con.close(); return d; } }
| 0 |