Javatpoint Logo

DriverDa

By: anomva*** On: Tue Jun 21 15:31:18 IST 2016     Question Reputation0 Answer Reputation0 Quiz Belt Series Points0  0Blank User
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;

}
}
Up0Down