189 8069 5689
本文实例为大家分享了java实现顶一下踩一下功能的具体代码，供大家参考，具体内容如下
我们提供的服务有：做网站、网站设计、微信公众号开发、网站优化、网站认证、滦南ssl等。为1000多家企事业单位解决了网站和推广的问题。提供周到的售前咨询和贴心的售后服务，是有科学管理、有技术的滦南网站制作公司
效果图如下：
主页面index.html:
Digg
后台servlet:
package com.test;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.NumberFormat;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Digg extends HttpServlet {
private static Connection con = null;
private static Statement stmt = null;
/**
* Constructor of the object.
*/
public Digg() {
super();
}
/**
* Destruction of the servlet.
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf8");
response.setCharacterEncoding("utf8");
String action = request.getParameter("action");
String digtype = request.getParameter("digtype");
if(action.equals("digs")){
try {
response.getWriter().write(dig(digtype));
} catch (Exception e) {
e.printStackTrace();
}
}else if(action.equals("getdigshtml")){
try {
response.getWriter().write(getDigHtml());
} catch (Exception e) {
e.printStackTrace();
}
}
}
private String dig(String digtype)throws Exception{
String sql ="";
if(digtype.equals("digs")){
sql ="update dig set digs=digs+1 where id =1";
}else{
sql ="update dig set undigs=undigs+1 where id =1";
}
int num =stmt.executeUpdate(sql);
if(num>0){
return "3";
}
return "1";
}
public static void main(String[] args){
NumberFormat nf = NumberFormat.getPercentInstance();
nf.setMaximumIntegerDigits(4);
nf.setMaximumFractionDigits(6);
double d = (double)1/(double)7;
System.out.println(nf.format(d));
}
private String getDigHtml()throws Exception{
NumberFormat nf = NumberFormat.getPercentInstance();
nf.setMaximumIntegerDigits(3);
nf.setMaximumFractionDigits(2);
String sql ="select * from dig where id=1";
ResultSet res = stmt.executeQuery(sql);
double digSum = 0 ;
double unDigSum =0 ;
double digSumAll = 0;
String digPer = "0%";
String unDigPer = "0%";
while(res.next()){
digSum = res.getInt("digs");
unDigSum = res.getInt("undigs");
}
digSumAll = digSum + unDigSum;
if(digSumAll !=0 ){
digPer = nf.format(digSum/digSumAll);
unDigPer = nf.format(unDigSum/digSumAll);
}
String str="";
return str;
}
/**
* Initialization of the servlet.
*
* @throws ServletException
* if an error occurs
*/
public void init() throws ServletException {
try {
Class.forName("com.MySQL.jdbc.Driver");
con = DriverManager.getConnection(
"jdbc:mysql://172.16.42.39:3306/dig", "root", "12345678");
stmt = con.createStatement();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void closeCon() {
try {
stmt.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
sql语句：
CREATE TABLE dig( id INT PRIMARY KEY, digs INT, undigs INT ); INSERT INTO dig VALUES(1,0,0);
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持创新互联。