任务1简单个人网站

TalentVirus

于 2010-03-02 11:08:00 发布

阅读量1.3k

点赞数

文章标签：任务 exception jdbc import mysql

本文链接：https://blog.csdn.net/TalentVirus/article/details/5338117

版权

<%@page contentType="text/html"%>
<%@page import="java.sql.*"%>
<%
int counter=0;
try{

  Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/test","root","123456");
  Statement stmt=conn.createStatement();
  ResultSet rs=stmt.executeQuery("select * from accesstimes");
  if(rs.next())counter=rs.getInt("times");
  stmt.executeUpdate("update accessTimes set times=times+1");
  rs.close();
  stmt.close();
  conn.close();
}catch(Exception e){e.printStackTrace();}
%>

<H1>helloo world</H1>
<p>welcome to my home page.please don,t run away!</p>
<hr>
<p>
Email me:<a href="mailto:webmaster@mywebsite.com">mailto:webmaster@mywebsite.com</a>
</p>
This page ghae been accessed<font color=red size=7><%=counter%></font>times