package cs320.stu31;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class HelloJDBC extends HttpServlet {
boolean exceptionRaised;
String exceptionMsg;
public void init() throws ServletException
{
exceptionRaised = false;
exceptionMsg = "";
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch( ClassNotFoundException e )
{
exceptionRaised = true;
exceptionMsg = "Cannot load MySQL driver: " + e.getMessage();
}
}
public void doGet( HttpServletRequest request, HttpServletResponse response )
throws ServletException, IOException
{
PrintWriter out = response.getWriter();
out.print( "\n" );
out.print( "
Hello JDBC\n" );
if( exceptionRaised )
{
out.println( exceptionMsg );
return;
}
try
{
String url = "jdbc:mysql:///cs320stu31?user=cs320stu31&password=abcd";
Connection c = DriverManager.getConnection( url );
Statement stmt = c.createStatement();
ResultSet rs = stmt.executeQuery( "select * from items");
while( rs.next() )
{
out.println( rs.getString("name") );
out.println( rs.getString("price") );
out.println( rs.getFloat("quantity") );
out.println( "
" );
}
c.close();
}
catch( Exception e )
{
exceptionRaised = true;
exceptionMsg = e.getMessage();
}
if( exceptionRaised ) out.println( exceptionMsg );
out.print( "" );
}
public void doPost( HttpServletRequest request, HttpServletResponse response )
throws ServletException, IOException
{
doGet(request, response);
}
} // end of class HelloJDBC