java 如何执行dig 命令_教大家使用java实现顶一下踩一下功能

本文实例为大家分享了java实现顶一下踩一下功能的具体代码，供大家参考，具体内容如下

效果图如下：

主页面index.html:

Digg

$(function(){ getdigshtml();})

function isdigs(digtype)//顶一下，踩一下操作

{

$.ajax({

type:'POST',

url:'Digg',

data:'action=digs&digtype='+digtype,

/* beforeSend:function(){

$("#vote").hide();

$("#loadings").show();

}, ajax请求显示loading效果*/

success:function(msg){

switch (msg)

{

/* 后台用来判断

case '1':

$("#loadings").hide();

$("#vote").show();

alert("请先登录！");

break;

case '2':

$("#loadings").hide();

$("#vote").show();

alert("请先下载，再操作！");

break;

case '4':

$("#loadings").hide();

$("#vote").show();

alert("您已经参与过评价！");

break;*/

case '3':

getdigshtml();//重新绑定html

//$("#loadings").hide();

//$("#vote").show();

alert("谢谢你的参与！");

break;

default:

}

}

})

}

function getdigshtml()//获取顶一下，踩一下html

{

$.ajax({

type:'POST',

url:'Digg',

data:'action=getdigshtml',

success:function(msg){

$("#digg").html(msg);

}

})

}

* {

padding:0;

margin:0;

}

.digg {

height: auto;

width: 190px;

font-size:12px;

font-weight:normal;

}

.digg a {

display: block;

height: 48px;

width: 189px;

background-image: url(images/mark.gif);

background-repeat: no-repeat;

position: relative;

color: #000;

text-decoration: none;

}

.digg .good {

margin-bottom:10px;

margin-top:5px;

}

.digg .good a {

background-position: -189px 0px;

}

.digg .good a:hover {

background-position: 0px 0px;

}

.digg .bad a {

background-position: -378px 0px;

}

.digg .bad a:hover {

background-position: -567px 0px;

}

.digg a p {

padding-left:30px;

line-height:25px;

}

.digg .bar {

background-color: white;

height: 5px;

left: 20px;

overflow: hidden;

position: absolute;

text-align: left;

top: 30px;

width: 55px;

}

.bar #g_img {

background-image: url(images/sprites.gif);

background-repeat: repeat-x;

height: 5px;

width: auto;

}

.bar #b_img {

background-image: url(images/sprites.gif);

background-repeat: repeat-x;

height: 5px;

width: auto;

background-position: 0px -5px;

}

.num {

color: #333;

font: normal normal 100 10px/12px Tahoma;

left: 80px;

position: absolute;

top: 26px;

}

.digg .good .bar {

border: 1px solid #40A300;

}

.digg .bad .bar {

border: 1px solid #555;

}

后台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="

";

str+="";

str+="

很好

str+=""+digPer+"("+digSum+")";

str+="

";

str+="";

str+="

很差

str+=""+unDigPer+"("+unDigSum+")";

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);

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持脚本之家。