can anybody tell me how to connect jsp with MYSQL?
*****************************
step1:download the mysql_connector.jar ,place it in webapps/lib
step2:try the following code in jsp
**************************
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://<ip_address>/<data_base_name>","<username>","<password>");
java.sql.Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from <table_name>");
while(rs.next())
{}