Latest Tutorials| Questions and Answers|Ask Questions?|Site Map




Have Programming Question? Ask it here!
 
 
 


Ragini Shukla
Hiiii
1 Answer(s)      6 years ago
Posted in : Java Beginners



Advertisement
View Answers

September 8, 2008 at 2:02 PM


Hello Ragini

This is code, as per your requirement u made modification

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class Test1 {

public void search(){
String searchstring = "raj";
String srch = "select name from Mytable where name LIKE '%" + searchstring + "%'";
System.out.println(srch);
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/testing";, "root", "");

Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(srch);
if(!rs.next()){
System.out.println("No Record Found" + rs.getRow());
}else{
rs = stmt.executeQuery(srch);
while(rs.next()){
System.out.println(rs.getString("name"));
}
}
}catch(Exception ex){
System.out.println("Exception");
}

}

public static void main(String s[]){
Test1 t = new Test1();
t.search();
}

}

Regards
Rajaniaknt Mishra
rajanikant.misra@sify.com


Related Tutorials/Questions & Answers:
Advertisements
RAJ9992
Servlet sending image  hiiii In my html page i use how to send this image value to servlet plz be inform me anybody
input using scanner and add/sub/mul/div of a matrix
input using scanner and add/sub/mul/div of a matrix  hiiii...... performe matrix add/sub/mul/div using scanner
RAJ9992
Send Image Value to Servlet  hiiii In my html page i use input type=image src="" value="" name="" how to send this image value to servlet plz be inform me anybody
meenakshi
meenakshi  HIIII, Any one can help me,, I have created a form in jsp and bind it by using spring:bind in spring. I have use ModelAndView of SimpleFormController . But when i called onSubmit thn onSubmit not called
login data
login data  Hiiii Sir I am doing banking project on Asp.net i have created database on sql and also created a connection to gui but m not getting the data after login i want to show particular data for particular user means if i
login data
login data   Hiiii Sir I am doing banking project on Asp.net i have created database on sql and also created a connection to gui but m not getting the data after login i want to show particular data for particular user means
error in accessing database - JSP-Servlet
error in accessing database  hiiii im tanushri im tryng to connect my database to the servlet i hv succeeded in connectivity but im stuck to nother error called Got minus one from read call although i hv feeded data to my
error got minus one from read call - JSP-Servlet
error got minus one from read call  hiiii while connecting my servlet to database im getting error called java.sql.SQLException: Io exception: Got minus one from a read call oracle.jdbc.dbaccess.DBError.throwSqlException
 

 

 

DMCA.com