Hi chitra,

I am sending select statement code. Implement the following code.


import java.sql.*;
public class SelectState {
public static void main(String a[])
{
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
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();
}
}
}


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

Read for more information with example

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

Thanks.

Amardeep