2021-11-02

每日100!推箱子2.0!
推箱子2.0
Run.java
package com.honghong2;

public class Run {
public static void main(String[] arge){
GameFrame gameFrame = new GameFrame(“推箱子2.0”);
gameFrame.setVisible(true);
}
}

GameFream.java
package com.honghong2;

import javax.swing.;
import java.awt.
;
import java.awt.event.KeyEvent;
import java.awt.event.KeyListener;

public class GameFrame extends JFrame{
//创建对象
private JPanel panel = null;
private JLabel worker = null;
private JLabel box = null;
private JLabel goal = null;
private JLabel walls[] = null;
//创建窗体
public GameFrame(String title){
super(title);//调用父类构造函数
setSize(2248+15,1248+38);
setLocationRelativeTo(null);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setResizable(false);

    initPanel();
    initWalls();
    this.goal = initLabel("goal4.png",17,6);
    this.worker = initLabel("workerRight5.png",3,3);
    this.box = initLabel("box5.png",8,9);
    addEvent();
}
private void addEvent(){
    super.addKeyListener(new KeyListener() {
        @Override
        public void keyTyped(KeyEvent e) {

        }

        @Override
        public void keyPressed(KeyEvent e) {

//System.out.println(“键盘每按一次,此方法被调用一次”);
/1 工人移动与图片改变/
int keyCode = e.getKeyCode();
String workerImgPath = “workerRight3.png”;
int x = 0, y = 0;
if (keyCode == KeyEvent.VK_A || keyCode == KeyEvent.VK_LEFT) {
x = -48;
workerImgPath = “workerLeft3.png”;
} else if(keyCode == KeyEvent.VK_W || keyCode == KeyEvent.VK_UP) {
y = -48;
workerImgPath = “workerUp3.png”;
} else if(keyCode == KeyEvent.VK_D || keyCode == KeyEvent.VK_RIGHT) {
x = 48;
} else if(keyCode == KeyEvent.VK_S || keyCode == KeyEvent.VK_DOWN) {
y = 48;
workerImgPath = “workerDown3.png”;
}
worker.setBounds(worker.getBounds().x + x, worker.getBounds().y + y, 48, 48);
ImageIcon img = new ImageIcon(“imgs/” + workerImgPath);
worker.setIcon(img);
/2 工人不能穿墙/
for (int i = 0; i < walls.length; i++) {
//如果工人的边界与某块围墙的边界有交集
if (worker.getBounds().intersects(walls[i].getBounds())) {
worker.setBounds(worker.getBounds().x - x, worker.getBounds().y - y, 48, 48);
break;
}
}
/3 工人推动箱子/
//如果工人的边界与箱子的边界有交集
if (worker.getBounds().intersects(box.getBounds())) {
box.setBounds(box.getBounds().x + x, box.getBounds().y + y, 48, 48);
}
/4 判断箱子是否穿墙/
for (int i = 0; i < walls.length; i++) {
//如果箱子的边界与某块围墙的边界有交集
if (box.getBounds().intersects(walls[i].getBounds())) {
//箱子退
box.setBounds(box.getBounds().x - x, box.getBounds().y - y, 48, 48);
//工人退
worker.setBounds(worker.getBounds().x - x, worker.getBounds().y - y, 48, 48);
break;
}
}
/5 判断输赢/
//如果箱子的边界与目的地的边界有交集
if (box.getBounds().intersects(goal.getBounds())) {
//弹个框
//静态方法: 用static关键字修饰的方法可以通过 代码: 类名.方法名访问
//普通方法 对象名.方法名 gameFrame.setSize()

                JOptionPane.showMessageDialog(null, "恭喜你,赢了!");
                System.exit(0);//退出系统(结束进程)
            }
        }

        @Override
        public void keyReleased(KeyEvent e) {

        }
    });
}

private JLabel initLabel(String imgPath ,int x,int y){
    //根据图片路径 创建图片对象
    ImageIcon img = new ImageIcon("imgs/"+imgPath);
    //创建标签 并且把图片放入标签
    JLabel label = new JLabel(img);
    //把标签放入面板
    panel.add(label);
    label.setBounds(x*48,y*48,48,48);
    return label;
}
private void initWalls(){
    //不要声明为局部变量
    this.walls = new JLabel[22*2 + 10*2 + 6 + 5 + 5];
    ImageIcon wallImg = new ImageIcon("imgs/wall5.png");
    for (int i = 0;i <= walls.length;i++){
        walls[i] = new JLabel(wallImg);
    }
    //添加围墙
    int insex = 0;
    for (int i = 0;i <= walls.length;i++){
        panel.add(walls[insex]);
        walls[insex++].setBounds(i*48,0,48,48);
        panel.add(walls[insex]);
        walls[insex++].setBounds(i*48,11,48,48);
    }
    for (int i = 1;i <= walls.length;i++){
        panel.add(walls[insex]);
        walls[insex++].setBounds(0,i*48,48,48);
        panel.add(walls[insex]);
        walls[insex++].setBounds(21,i*48,48,48);
    }
    for(int i = 0;i < 5;i++){
        panel.add(walls[insex]);
        walls[insex++].setBounds(14*48,(4+i)*48,48,48);
    }
    for(int i = 0;i < 6;i++){
        panel.add(walls[insex]);
        walls[insex++].setBounds((6 + i)*48,3*48,48,48);
    }
    for(int i = 0;i < 5;i++){
        panel.add(walls[insex]);
        walls[insex++].setBounds((3 + i)*48,(4+i)*48,48,48);
    }
}
private void initPanel(){
    panel = new JPanel();
    panel.setBackground(Color.orange);
    panel.setLayout(null);
    //设置面板与窗体关联
    setContentPane(panel);
}

}

运行结果

描述 用户行为日志表tb_user_log id uid artical_id in_time out_time sign_in 1 101 9001 2021-11-01 10:00:00 2021-11-01 10:00:31 0 2 102 9001 2021-11-01 10:00:00 2021-11-01 10:00:24 0 3 102 9002 2021-11-01 11:00:00 2021-11-01 11:00:11 0 4 101 9001 2021-11-02 10:00:00 2021-11-02 10:00:50 0 5 102 9002 2021-11-02 11:00:01 2021-11-02 11:00:24 0 (uid-用户ID, artical_id-文章ID, in_time-进入时间, out_time-离开时间, sign_in-是否签到) 场景逻辑说明:artical_id-文章ID代表用户浏览的文章的ID,artical_id-文章ID为0表示用户在非文章内容页(比如App内的列表页、活动页等)。 问题:统计202111月每天的人均浏览文章时长(秒数),结果保留1位小数,并按时长由短到长排序。 输出示例: 示例数据的输出结果如下 dt avg_viiew_len_sec 2021-11-01 33.0 2021-11-02 36.5 解释: 11月1日有2个人浏览文章,总共浏览时长为31+24+11=66秒,人均浏览33秒; 11月2日有2个人浏览文章,总共时长为50+23=73秒,人均时长为36.5秒。以下写法:select dt, round(avg(diff),1) avg_viiew_len_sec from ( select uid, date(in_time) dt sum(timestampdiff(SECOND,in_time,out_time)) diff from tb_user_log where dt='2021-11' group by uid,dt )t group by dt order by avg_viiew_len_sec 报错程序异常退出, 请检查代码"是否有数组越界等异常"或者"是否有语法错误" SQL_ERROR_INFO: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sum(timestampdiff(SECOND,in_time,out_time)) diff\nfrom\n tb_user_log\nwhere dt='' at line 9"
03-11
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值