connectivity between jsp & MYSQL

[varsha25]

can anybody tell me how to connect jsp with MYSQL?

[byjufromgamut]

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=DriverManag er.getConnectio n("jdbc:mysql ://<ip_address>/<data_base_name >","<username>" ,"<password> ");
java.sql.Statem ent stmt=con.create Statement();
ResultSet rs=stmt.execute Query("select * from <table_name>" );
while(rs.next() )
{}