Jaydeep

• Jul 26th, 2006

 

Hello friends,

             For Connect JSP With My SQL u can't use ODBC Bridge Driver. For that you required external driver called "j-connector'. With the help of this external driver you can connect JSP to MySQL. if u have any query about this connection than just mail me on my mail id jaydip_mit@yahoo.com ok Bye

Mohammad Mustafeezur Rahman (Xavient I S)

• Jul 28th, 2006

 

firstly Install MySQL driver on your systemif u dont have : no probsdownload it from neturl is http://dev.mysql.com/downloads/connector/odbc/3.51.html<%String connectionURL = "jdbc:mysql://localhost:3306/mydatabase?user=;password=";Class.forName("com.mysql.jdbc.Driver").newInstance();connection = DriverManager.getConnection(connectionURL, "", "");statement = connection.createStatement();rs = statement.executeQuery("SELECT * FROM [Tablename]");while (rs.next()) {out.println(rs.getString("[field name]")+"
");} rs.close();%>for more assistance u can mail me on md_mustafiz@yahoo.comI will give u entire code..........