how to search data from database in java code example
Example: searching in database using java
import java.sql.*;
public class jdbcConn {
public static void main(String[] args) throws Exception {
Class.forName("org.apache.derby.jdbc.ClientDriver");
Connection con = DriverManager.getConnection(
"jdbc:derby://localhost:1527/testDb","username", "password");
Statement stmt = con.createStatement();
String query[] = {
"SELECT * FROM emp where id = 1",
"select name from emp where name like 'ravi_'",
"select name from emp where name like 'ravi%'"
};
for(String q : query) {
ResultSet rs = stmt.executeQuery(q);
System.out.println("Names for query "+q+" are");
while (rs.next()) {
String name = rs.getString("name");
System.out.print(name+" ");
}
System.out.println();
}
}
}