Can't display from MySql
Hi,
I am trying to display the movietitle from my sql database->moviexpress,table name->movie.However the output i get from the jsp page is NULL.Can anyone tell mi why?
Thanx ^.^
<%
// database parameters
String host="localhost";
String user="tomcat";
String pass="tomcat";
String db="test";
String conn;
Class.forName("org.gjt.mm.mysql.Driver");
// create connection string
conn = "jdbc:mysql://" + host + "/" + db + "?user=" + user + "&password=" + pass;
// pass database parameters to JDBC driver
Connection Conn = DriverManager.getConnection(conn);
// query statement
Statement SQLStatement = Conn.createStatement();
String movietitle = request.getParameter("movietitle");
String Query = "SELECT movietitle FROM movie" ;
out.println(movietitle);
SQLStatement.close();
Conn.close();
%>

