Hi friend,



I am sending code. if you have any problem then send me code and explain in detail, what's your proper query.


import java.sql.*;

public class SelectState {
public static void main(String a[]) {
Connection con = null;
String url = "jdbc:mysql://localhost:192.168.10.211/";;
String dbName = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName = "amar";
String password = "amar123";
try {
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+dbName,userName,password);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select Name from Employee");
System.out.println("Results");
while( rs.next() ) {
String data = rs.getString(1);
System.out.println(data);
}
st.close();
}
catch( Exception e ) {
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}

-----------------------------------

Please visit for more informaton:

http://www.roseindia.net/jdbc/

Thanks.

Amardeep

Hi arvind

i am sending some link to you, where you can found the solution of your problem.


http://roseindia.net/sql/LIKE-Operator.shtml
http://roseindia.net/sql/sql-and-like.shtml


Thanks
sandeep