Hi friend,


I am sending simple database connectivity code. if you have any problem then send me detail code and explain about it.


import java.sql.*;

public class JdbcConnection {

public static void main(String args[]) {

Connection con = null;
Statement st = null;
ResultSet rs = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";

try {
Class.forName(driver);
con = DriverManager.getConnection(url + db, userName, password);
st = con.createStatement();

String sql = "select * from person";
rs = st.executeQuery(sql);


System.out.println("Id\tName");
while (rs.next()) {
System.out.print(rs.getInt(1));
System.out.println("\t"+rs.getString(2));
}
rs.close();
st.close();
con.close();

} catch (Exception e) {
System.out.println(e);
}
}
}

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

Visit for more information.

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

Thanks.