%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" %> <% String sql = "SELECT id, name FROM fromsa ORDER BY id"; Statement statement; ResultSet result; Connection connection = null; //String myDriver = "org.gjt.mm.mysql.Driver"; //String dbURL = "jdbc:mysql://localhost/w2online_trav"; //String dbUser = "w2online_myglobe"; //String dbPass = "globel1"; String myDriver = "com.mysql.jdbc.Driver"; String dbURL = "jdbc:mysql://dedi36a.your-server.co.za/globel_trav"; String dbUser = "myglobel"; String dbPass = "globel1"; try { Class.forName(myDriver).newInstance(); connection = DriverManager.getConnection(dbURL,dbUser,dbPass); statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); result = statement.executeQuery(sql); %>
![]() ![]() |
|
|
|