?? showclicknumber.java
字號:
package com.v246;
public class ShowClickNumber
{
public static String getClickNumber(String id)throws Exception
{
java.sql.Connection conn=null;
java.sql.Statement stm=null;
java.sql.ResultSet rs=null;
Connections connTmp=new Connections();
String re=null;
try
{
conn=connTmp.getConnection();
stm=conn.createStatement();
rs=stm.executeQuery("select * from article where ArticleID="+id);
if(rs.next())
{
re=String.valueOf(rs.getInt("Hits"));
System.out.println("ok");
stm.executeUpdate("update article set Hits=Hits+1 where ArticleID="+id);
}
else
{
re="數據錯誤";
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
if(rs!=null)rs.close();
if(stm!=null)stm.close();
if(conn!=null)conn.close();
}
return re;
}
public static void main(String args[])
{
try
{
System.out.println(getClickNumber("80"));
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -