Connect to a GoDaddy database with JSP

[troyarch]

Is there some sample JSP code that can show me how to test a database connection to a MySQL database on a GoDaddy server. I know the GoDaddy hostname, database name, username, and password. GoDaddy Support only provides PHP sample code. Thanks.

 

[sedj]

String url = "jdbc:mysql://localhost:3306/test";
String user = "test";
String password = "test";

Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(url, user, password);

Replace localhost with your server name or IP, and the user/password.

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[sedj]

Oh, and replace "test" in the url with your mysql database name.

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk