mysql设置中奖率_中奖概率的代码！

在写之前请在数据库(mysql)创建一个lib的数据库！

++++++++++++++++++++++++++++++++++++++++

package com.nf.entity;

import javax.persistence.*;

@Entity

@Table(name = "book")

public class Book {

private Integer id;

private String name;

private Integer price;

@Id

@GeneratedValue(strategy= GenerationType.IDENTITY)

@Column(name="id")

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

@Column(name = "name",length = 50,nullable = false)

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

@Column(name = "price",nullable = false)

public Integer getPrice() {

return price;

}

public void setPrice(Integer price) {

this.price = price;

}

}

==================================================

----------------------------------------------------------------------------------------

【包名com.nf.service】

(BookService.java 接口)

package com.nf.service;

import com.nf.entity.Book;

import java.util.List;

public interface BookService {

public List getAllBook();

}

----------------------------------------------------------------------------------------

【包名com.nf.service】

(BookServiceImpl.java)

package com.nf.service;

import com.nf.dao.BookDao;

import com.nf.entity.Book;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.context.annotation.Scope;

import org.springframework.stereotype.Service;

import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@Service

@Scope("prototype")

public class BookServiceImpl implements BookService {

@Autowired

private BookDao bookDao;

@Transactional

public List getAllBook() {

List bookList = bookDao.getAllBook();

//编写游戏规则(业务逻辑代码：没有任何数据库操作)

return bookList;

}

}

{这个是配置文件【此为mysql的配置】}

(下面的student为库名！user为账号！password为密码！自己改好自己的配置)

#database information

driverClass=com.mysql.cj.jdbc.Driver

jdbcUrl=jdbc:mysql://localhost:3306/lib?serverTimezone=UTC

user=root

password=root

//

记得在WebContent下面创建一个js目录放jquery-3.2.1.min.js(不知道朋友可以去百度下载！)

//

(这个是WebContent下面目录的项目)

(ok.jsp)

pageEncoding="UTF-8"%>

Insert title here

function isWin(userid) {

//构造一个发送给服务端的参数列表

var postData = {id:userid};

$.ajax({

url:"userAction_isWin.action",

type:'POST',

data:postData,

dataType:'json',//服务端返回类型

success:function (myresult) {

if (myresult.data==true){

alert('恭喜你获奖了');

}else{

alert('恭喜你,输了!');

}

},

timeout:3000,

error:function(){

alert('访问服务端失败')

}

});

}

id	名字	性别	年龄	状态	是否获奖
${ss.id}	${ss.userName}	${ss.sex}	${ss.age}	${ss.status}	访问

-------------------------------------------------------------下的表示另一个文件存放的代码

===================================下的表示另一个包下存放的代码