shennanigan83
Programmer
hello there! I'm totally new to jsp. could anyone tell me the syntax to connect jsp to MySQL? Thanks a whole lot in advnance!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MySQL and JSP connection
- Thread starter shennanigan83
- Start date
- Status
Hi,
Make sure you have the mysql-connector-java-3.0.8-stable-bin.jar in your classpath or you can download the driver from mysql.com
Ex :
String url = "jdbc:mysql://<host>/<database>?user=&password=";
Class.forName("com.mysql.jdbc.Driver"
.newInstance();
java.sql.Connection connection = java.sql.DriverManager.getConnection(url);
java.sql.Statement statement = connection.createStatement();
java.sql.ResultSet columns = statement.executeQuery(query);
while(columns.next())
{
out.println(columns.getString(1));
}
Cheers
-Venu
Make sure you have the mysql-connector-java-3.0.8-stable-bin.jar in your classpath or you can download the driver from mysql.com
Ex :
String url = "jdbc:mysql://<host>/<database>?user=&password=";
Class.forName("com.mysql.jdbc.Driver"
.newInstance(); java.sql.Connection connection = java.sql.DriverManager.getConnection(url);
java.sql.Statement statement = connection.createStatement();
java.sql.ResultSet columns = statement.executeQuery(query);
while(columns.next())
{
out.println(columns.getString(1));
}
Cheers
-Venu
- Thread starter
- #3
- Status
Similar threads