Coding kat atas tu adalah untuk test connection diantara MySql + Tomcat JSP. so kalau korang pening tibe2 error kluar, tapi tengok coding semua dah betul. tapi tak tau kenapa application with db korang tu tak leh nak run. ada keluar error. so try guna coding kat atas ni check samada database dan tomcat korang bleh connect tak..
<%@ page import = "java.sql.*"%>02.<html>03.<head>04.<title>Obtaining a Connection </title>05.</head>06.<body>07.<%08.Connection conn=null;09.ResultSet result=null;10.Statement stmt=null;11.ResultSetMetaData rsmd=null;12.try13.{14.Class c=Class.forName("com.mysql.jdbc.Driver");15.}16.catch(Exception e)17.{18.out.write("Error!!!!!!" + e);19.}20.try21.{22.conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/databasename","username","password");23.out.write("Connected!");24.}25.catch(SQLException e)26.{27.System.out.println("Error!!!!!!" + e);28.}
Related posts:
