JSP网站计数器实例
2009年11月25日
0:11
用JSP做一个网站计数器,实现示例:
代码中counter.java是计数器的代码,counter.jsp是引用计数器的jsp代码,还有其中用的Databa的代码在下面。
counter.java
package UfulClass;
import java.sql.*;
public class Counter
{
private int count;
private Databa Mechanism=new Databa();
public Counter()
{
ResultSet uteQuery("lect Counter from Counter");
try
{
开心就好英文while (rs.next())
{
Int("Counter");
}
}
catch(SQLException ex)
{头饰英文
}
finally
{
Mechanism.cloStmt();
Mechanism.cloConn();
}
}
synchronized public void Increa()
{
count++;
}
synchronized public String[] getCountImage()
{
char[] chars=String.valueOf(count).toCharArray();
int numChars=chars.length;
String[] images=new String[numChars];
for (int LoopNum=numChars-1;LoopNum>-1;LoopNum--)
{
images[LoopNum]=String.valueOf(chars[LoopNum])+".gif";
}
return images;
}
synchronized public void UpdateCounter()
{
<tr>
<td align="center">
<td align="center">
<%
if (Value("LogStatus")=="TRUE")
out.println("<font size=\"2
\">"+Value("Urname").toString()+
tWelcomeMessage()+"</font>");
el
out.println("<font size=\"2
\">"+WelcomeMessage()+"</font>");
%>
</td>
</tr>
<tr>
<td><font size="2">您是第</font></td>
</tr>
<tr>
<td align="center">
<%
String[] CountImage();
for (int LoopNum=0 ; LoopNum<imgs.length ; LoopNum++){ out.print("<img src=\"/Images/" + imgs[LoopNum] + "\"height=\"15\" width=\"8\">");
}
%>
</td>
</tr>
<tr>
<td align="right"><font size="2">位访客</font></td>
</tr>
</table>
Databa.java
package UfulClass;
import java.sql.*;
import java.util.*;
import javax.naming.*;
public class Databaluodai
{
solon
//String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
//String sConnStr = "jdbc:odbc:Mechanism";
//String sDBDriver="com.microsoft.jdbc.sqlrver.SQLServerDriver";
//String sConnStr="jdbc:microsoft:sqlrver://127.0.0.1:1433;DatabaName=Mechanism";
Context ctx = null;
Hashtable ht=null;
javax.sql.DataSource ds = null;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
public Databa()
{
ht=new Hashtable();
ht.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
ht.put(Context.PROVIDER_URL,"t3://127.0.0.1:80");
try
{
ctx = new InitialContext(ht);
ds = (javax.sql.DataSource)ctx.lookup("Mechanism");
/
/Class.forName(sDBDriver);
}
catch(javax.naming.NamingException e)
catch(javax.naming.NamingException e)
{
}
}
public void executeInrt(String sql)
{
try
头皮痒头皮屑多
{
//conn = Connection(sConnStr,"","");
conn = ds.getConnection();
stmt = ateStatement();
stmt.clo();
conn.clo();
}
catch(SQLException ex)
{
}
}
public ResultSet executeQuery(String sql)
{
try
{
//conn = Connection(sConnStr,"ur","111111");
conn = ds.getConnection();
stmt =
LY);
rs = uteQuery(sql);
}
catch(SQLException ex)
{
}
return rs;
}
public ResultSet executePreparedQuery(String sql)
{
try
{
//conn = Connection(sConnStr,"","");
//stmt =
_READ_ONLY);
//rs = utePreparedQuery(sql);
conn = ds.getConnection();
stmt =
conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_RE
AD_ONLY);
}
catch(SQLException ex)
{
}
伞的英文单词return rs;
}
}
public void executeUpdate(String sql)
{
try
{
/
/conn = Connection(sConnStr,"ur","111111");
conn = ds.getConnection();
stmt = ateStatement();
stmt.clo();
conn.clo();
}
catch(SQLException ex)
{
}
}
public void executeDelete(String sql)
{
口译教程try
{
//conn = Connection(sConnStr,"","");
conn = ds.getConnection();
stmt = ateStatement();
as
stmt.clo();2013高考数学试卷
什么意思英文
conn.clo();
}
catch(SQLException ex)
{
}
}
public void cloStmt()
{
try
{
stmt.clo();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public void cloConn()
{
try
{
conn.clo();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}