need search query

Hi Friend,

Please try the following code. It will be helpful in solving your problem.


/* For Working code use these sql queries

create database komal;

use komal;

create table stu(name varchar(10), dob date);

insert into stu values('komal','1984,10,27');

*/

import java.sql.*;

public class NewClass {

public static void main(String args[]) {

int date = 27;
int month = 10;
int year = 1984;

Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "komal";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";

Date dob = new Date(1);

try {
Class.forName(driver);
con = DriverManager.getConnection(url + db, user, pass);

String sql = "select * from stu where name ='komal'";
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);

while (rs.next()) {
dob = rs.getDate("dob");
}
} catch (Exception e) {
e.printStackTrace();
}
System.out.println(dob);

if (dob.compareTo(new Date(year - 1900, month - 1, date)) == 0) {
System.out.println("search sussesfull...");
} else {
System.out.println("Record not found");
}
}
}

Thanks