atmtag.java

J2EE关于JSP,SERVERLET的多个实用例子

import javax.servlet.jsp.*;
import javax.servlet.jsp.tagext.*;
import java.sql.*;
import java.io.*;

public class ATMTag extends TagSupport
{
	public int doStartTag()
	{
		try
		{
		}
		catch(Exception e)
		{
		}
		return EVAL_BODY_INCLUDE;
	}
	
	public int doEndTag()
	{
		try
		{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con=DriverManager.getConnection("jdbc:odbc:MyDatabase","faculty","");
		Statement sta=con.createStatement();
		ResultSet res=sta.executeQuery("select * from counter where mCashbalance<=10000");
		while(res.next())
		{
			JspWriter jw=pageContext.getOut();
			jw.write(res.getString(1));
			jw.write(String.valueOf(res.getDouble(3)));
			jw.write("<br>");
		}
		}
		catch(Exception e)
		{
			System.out.println(e);
		}
		return EVAL_PAGE;
	}
}