package com.lixing.tool;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JDBC {
private static String user="root";
private static String pwd="root";
private static String url="jdbc:mysql://127.0.0.1:3306/vido";
private static String driver="com.mysql.jdbc.Driver";
//��ȡ���ݿ����ӷ���
public static Connection getConnection() throws ClassNotFoundException, SQLException{
Class.forName(driver);
return DriverManager.getConnection(url, user, pwd);
}
}
package com.lixing.controller;
import java.io.File;
import java.io.IOException;
import java.util.UUID;
import javax.accessibility.AccessibleRelation;
import javax.xml.ws.Response;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import com.lixing.dao.GameInfoDao;
import com.lixing.dao.UserInfoDao;
import com.lixing.pojo.PageData;
import com.lixing.pojo.UserInfo;
@Controller
public class UserInfoController {
//......................................中间省略部分是数据上传功能
@RequestMapping("/queryGameInfoList.do")
public @ResponseBody PageData findGameInfo(int page,int limit){
System.out.println("==============="+page);
System.out.println("==============="+limit);
//��ѯ�û���Ϣ�����ݴ��������������������з�ҳ
GameInfoDao dao=new GameInfoDao();
return dao.findGameInfo(page, limit);
}
@RequestMapping("deleGameInfo.do")
public @ResponseBody int deleteGameInfo(int id){
System.out.println("ɾ���û��ķ���======"+id);
GameInfoDao dao=new GameInfoDao();
return dao.deleGameInfoById(id);
}
}
package com.lixing.pojo;
public class PageData {
private String code;
private String msg;
private int count;
private Object data;
public String getCode() {
return code;
}
public void setCode(String code) {
this.code = code;
}
public String getMsg() {
return msg;
}
public void setMsg(String msg) {
this.msg = msg;
}
public int getCount() {
return count;
}
public void setCount(int count) {
this.count = count;
}
public Object getData() {
return data;
}
public void setData(Object data) {
this.data = data;
}
}
package com.lixing.pojo;
public class GameInfo {
private int id;
private String game;
private String type;
public int getid() {
return id;
}
public void setid(int id) {
this.id = id;
}
public String getgame() {
return game;
}
public void setgame(String game) {
this.game = game;
}
public String gettype() {
return type;
}
public void settype(String type) {
this.type = type;
}
}
package com.lixing.dao;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.lixing.pojo.GameInfo;
import com.lixing.pojo.PageData;
import com.lixing.pojo.UserInfo;
import com.lixing.tool.JDBC;
import java.sql.PreparedStatement;
public class GameInfoDao {
//中间省略部分为数据上传功能呢
public PageData findGameInfo(int page,int limit){
PageData p=new PageData();
List list=new ArrayList();
p.setCode("1");
p.setMsg("閿熸枻鎷烽敓鎹风》鎷烽敓鏂ゆ嫹閿熷眾甯�");
try {
page = (page-1)*limit; //閿熸帴绗》鎷烽敓鏂ゆ嫹閿熸枻鎷峰
Connection con=JDBC.getConnection();
String sql="select * from czgame limit ?,?";
PreparedStatement ps=con.prepareStatement(sql);
ps.setInt(1, page);
ps.setInt(2, limit);
ResultSet rs=ps.executeQuery();
boolean ifg=false;
while(rs.next()){
//閿熸枻鎷烽敓鏂ゆ嫹閿熸枻鎷蜂竴閿熸枻鎷烽敓鏂ゆ嫹閿熸嵎锝忔嫹閿熸枻鎷烽敓鏂ゆ嫹閿熸枻鎷蜂竴閿熸枻鎷穟serInfo閿熸枻鎷烽敓鏂ゆ嫹
GameInfo game=new GameInfo();
ifg=true;
game.setid(rs.getInt(1));
game.setgame(rs.getString(2));
game.settype(rs.getString(3));
list.add(game);
}
if(ifg){
p.setCode("0");
p.setMsg("閿熸枻鎷烽敓鏂ゆ嫹閿熸枻鎷烽敓鎹锋垚鐧告嫹閿熸枻鎷�");
p.setCount(findGameInfoCount()); //閿熸枻鎷峰彇閿熺煫浼欐嫹閿熸枻鎷烽敓鏂ゆ嫹閿熸枻鎷烽敓鏂ゆ嫹
p.setData(list);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return p;
}
public int findGameInfoCount(){
Connection con;
int num=0;
try {
con = JDBC.getConnection();
String sql="select count(*) from czgame ";
PreparedStatement ps=con.prepareStatement(sql);
ResultSet rs=ps.executeQuery();
if(rs.next()){
num=rs.getInt(1);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return num;
}
public int deleGameInfoById(int id){
int num=0;
try {
Connection con=JDBC.getConnection();
String sql="delete from czgame where id=?";
PreparedStatement ps=con.prepareStatement(sql);
ps.setInt(1, id);
num=ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
return num;
}
}
数据库表很简单
ID game type
用jquey.JS
只是不会在页面上使用这些后台JAVA代码显示网页页面上
最后能实现页面按钮对数据库数据进行删除
以及将数据库数据显示在页面上即可