package com.ynu.sg;
import java.io.*;
import java.sql.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class BestQueryServlet extends HttpServlet
{
//only set in the init() method, so concurrency
//issues should be fine.
private LavenderDBSingleton m_dbsingleton = null;
public void init()
{
/*
* This will instantiate it within the Servlet's
* virtual machine if it hasn't already. If it
* has, we have the instance of it.
*/
m_dbsingleton = LavenderDBSingleton.getInstance();
}
/**
* simply forwards all to doPost()
*/
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
doPost(request,response);
}
/**
* The main form!
*/
public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
PrintWriter out = response.getWriter();
out.println("<TITLE>Internal Inventory Check</TITLE>");
out.println("<BODY BGCOLOR='white'>");
out.println("<H1>Lavender Fields Farm Internal Inventory</H1>");
//show the date.
SimpleDateFormat sdf =new SimpleDateFormat ("EEE, MMM d, yyyy h:mm a");
java.util.Date newdate = new java.util.Date(Calendar.getInstance().getTime().getTime());
String datestring = sdf.format(newdate);
out.println("<H3>Inventory as of: " + datestring + "</H3>");
out.println("<TABLE BORDER=1>");
out.println("<TR><TD BGCOLOR='yellow'>" +
"<B><CENTER>Name</CENTER></B></TD>" +
"<TD BGCOLOR='yellow'><B>" +
"<CENTER>Description</CENTER></B></TD>" +
"<TD BGCOLOR='yellow'><B>" +
"<CENTER>Inventory Amount</CENTER></B></TD></TR>");
//Load the inventory from the database.
try
{
Connection con = m_dbsingleton.getConnection();
if (con == null)
{
out.println("<B>There are currently database problems. " +
"Please see your administrator for details.</B>");
return;
}
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from Inventory");
while (rs.next())
{
String amtString = "";
int amt = rs.getInt("Amount");
if (amt < 50)
amtString ="<TD><CENTER><FONT COLOR='RED'>" +
amt + "</FONT></CENTER></TD>";
else
amtString ="<TD><CENTER>" +
amt + "</CENTER></TD>";
out.println("<TR><TD><CENTER>" + rs.getString("Name") +
"</CENTER></TD><TD><CENTER>" +
rs.getString("Description") +
"</CENTER></TD>" + amtString + "</TR>");
}
rs.close();
out.println("</TABLE><HR>Items in <FONT COLOR='red'>RED</FONT>" +
" denote a possible low inventory. Click Here to " +
" contact <A HREF='mailto:mgmt@localhost'>" +
"MANAGEMENT</A> to order more supplies.");
//Free the connection!
m_dbsingleton.freeConnection( con );
}
catch (Exception e)
{
out.println("There were errors connecting to the database." +
" Please see your systems administrator for details.");
e.printStackTrace();
}
}
}
TestConnection.rar （13个子文件） 
TestConnection 
.project 1KB .mymetadata 315B
mysql-connector-java-5.0.4-bin.jar 484KB src com ynu sg LavenderDBSingleton.java 3KB BestQueryServlet.java 4KB WebRoot WEB-INF classes com ynu sg BestQueryServlet.class 4KB LavenderDBSingleton.class 2KB lib web.xml 718B index.jsp 829B META-INF MANIFEST.MF 36B DDConnectionBroker.jar 13KB .myeclipse .settings org.eclipse.jdt.core.prefs 330B .classpath 578B资源评论
苍梧野老2013-01-22蛮不错的，讲解很详细
普通网友2014-12-15这个内容很简单- jjbear112015-01-13很好，适合新手学习
呵呵哒呀2014-05-04还不错 帮了我很大的忙
