会员可以在此提问,百战程序员老师有问必答
对大家有帮助的问答会被标记为“推荐”
看完课程过来浏览一下别人提的问题,会帮你学得更全面
截止目前,同学们一共提了 133811个问题

webdemo.zip

老师  发现我的代码有个BUG  就是根据用户输入条件查询时当同时提供username、usersex时是查不到结果的,其他情况都可查到,浏览器显示如下 ,控制台报错如下  想知道 是我的代码哪里敲错了  还是这个项目目前就存在的BUG

image.png


点击查询 显示如下

image.png


image.png

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'lilei' in 'where clause'
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2020)
	at com.bjsxt.dao.impl.UserManagerDaoImpl.selectUserByProperty(UserManagerDaoImpl.java:96)
	at com.bjsxt.service.Impl.UserManagerServiceImpl.findUser(UserManagerServiceImpl.java:26)
	at com.bjsxt.web.servlet.UserManagerServlet.findUser(UserManagerServlet.java:56)
	at com.bjsxt.web.servlet.UserManagerServlet.doPost(UserManagerServlet.java:31)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.bjsxt.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:29)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)




JAVA 全系列/第六阶段:JavaWeb开发/Web实战案例 9139楼
JAVA 全系列/第十五阶段:海量数据存储与查询/MyCat(旧) 9140楼
JAVA 全系列/第八阶段:Linux入门到实战/Maven 9141楼
JAVA 全系列/第一阶段:AI驱动的JAVA编程/变量、数据类型、运算符 9142楼
JAVA 全系列/第六阶段:项目管理与SSM框架/Mybatis 9143楼
JAVA 全系列/第八阶段:Linux入门到实战/Linux(旧) 9147楼

pygametimerandom
_display = pygame.display
COLOR_BLACK = pygame.Color()
COLOR_RED = pygame.Color()
version = MainGame():
    window = SCREEN_HEIGHT = SCREEN_WIDTH = TANK_P1 = EnemyTank_list = []
    EnemTank_count = Bullet_list = []
    Enemy_bullet_list = []
    ():
        ():
        _display.init()
        MainGame.window = _display.set_mode([MainGame.SCREEN_WIDTHMainGame.SCREEN_HEIGHT])
        MainGame.TANK_P1 = Tank()
        .creatEnemyTank()
        _display.set_caption(+version)
        :
            MainGame.window.fill(COLOR_BLACK)
            .getEvent()
            MainGame.window.blit(.getTextSurface(%(MainGame.EnemyTank_list))())
            MainGame.TANK_P1.displayTank()
            .blitEnemyTank()
            MainGame.TANK_P1 MainGame.TANK_P1.stop:
                MainGame.TANK_P1.move()
            .blitBullet()
            .blitEnemyBullet()
            time.sleep()
            _display.update()
    ():

        top = speed = random.randint()
        i (MainGame.EnemTank_count):
            left = random.randint()
            eTank = EnemyTank(left*topspeed)
            MainGame.EnemyTank_list.append(eTank)
    ():
        eTank MainGame.EnemyTank_list:
            eTank.displayTank()
            eTank.randMove()
            eBullet = eTank.shot()
            MainGame.Enemy_bullet_list.append(eBullet)
    ():
        bullet MainGame.Bullet_list:
            bullet.live:
                bullet.displayBullet()
                bullet.bulletMove()
            :
                MainGame.Bullet_list.remove(bullet)
    ():
        eBullet MainGame.Enemy_bullet_list:
            eBullet.live:
                eBullet.displayBullet()
                eBullet.bulletMove()
            :
                MainGame.Bullet_list.remove(eBullet)

    ():
        eventList = pygame.event.get()
        event eventList:
            event.type == pygame.QUIT:
                .endGame()
            event.type == pygame.KEYDOWN:
                event.key == pygame.K_LEFT:
                    ()
                    MainGame.TANK_P1.direction = MainGame.TANK_P1.stop = event.key == pygame.K_RIGHT:
                    ()
                    MainGame.TANK_P1.direction = MainGame.TANK_P1.stop = event.key == pygame.K_UP:
                    ()
                    MainGame.TANK_P1.direction = MainGame.TANK_P1.stop = event.key == pygame.K_DOWN:
                    ()
                    MainGame.TANK_P1.direction = MainGame.TANK_P1.stop = event.key == pygame.K_SPACE:
                    ()
                    (MainGame.Bullet_list) < :
                        m = Bullet(MainGame.TANK_P1)
                        MainGame.Bullet_list.append(m)
                    :
                        ()
                    (%(MainGame.Bullet_list))
            event.type == pygame.KEYUP:
                event.key == pygame.K_LEFT event.key == pygame.K_RIGHT event.key == pygame.K_UP event.key == pygame.K_DOWN:
                    MainGame.TANK_P1.stop = (text):
        pygame.font.init()
        font = pygame.font.SysFont()
        textSurface = font.render(textCOLOR_RED)
        textSurface
    ():
        ()
        ()
Tank():
    (lefttop):
        .images = {
            :pygame.image.load():pygame.image.load():pygame.image.load():pygame.image.load()
        }
        .direction = .image = .images[.direction]
        .rect = .image.get_rect()
        .rect.left = left
        .rect.top = top
        .speed = .stop = ():
        .direction == :
            .rect.left > :
                .rect.left -= .speed
        .direction == :
            .rect.left + .rect.height < MainGame.SCREEN_WIDTH:
                .rect.left += .speed
        .direction == :
            .rect.top > :
                .rect.top -= .speed
        .direction == :
            .rect.top + .rect.height < MainGame.SCREEN_HEIGHT:
                .rect.top += .speed
    ():
        Bullet()
    ():
        .image = .images[.direction]
        MainGame.window.blit(.image.rect)
MyTank(Tank):
    ():
        EnemyTank(Tank):
    (lefttopspeed):
        .images = {
            : pygame.image.load(): pygame.image.load(): pygame.image.load(): pygame.image.load()
        }
        .direction = .randDirection()
        .image = .images[.direction]
        .rect = .image.get_rect()
        .rect.left = left
        .rect.top = top
        .speed = speed
        .stop = .step = ():
        num = random.randint()
        num == :
            num == :
            num == :
            num == :
            ():
        .step <= :
            .direction = .randDirection()
            .step = :
            .move()
            .step -= Bullet():
    (tank):
        .image = pygame.image.load()
        .direction = tank.direction
        .rect = .image.get_rect()
        .direction == :
            .rect.left = tank.rect.left + tank.rect.width/- .rect.width/.rect.top = tank.rect.top - .rect.height
        .direction == :
            .rect.left = tank.rect.left + tank.rect.width / - .rect.width / .rect.top = tank.rect.top + tank.rect.height
        .direction == :
            .rect.left = tank.rect.left - .rect.width / - .rect.width / .rect.top = tank.rect.top + tank.rect.width / - .rect.width / .direction == :
            .rect.left = tank.rect.left + tank.rect.width
            .rect.top = tank.rect.top + tank.rect.width / - .rect.width / .speed = .live = ():
        .direction == :
            .rect.top > :
                .rect.top -= .speed
            :
                .live = .direction == :
            .rect.top < MainGame.SCREEN_HEIGHT - .rect.height:
                .rect.top += .speed
            :
                .live = .direction == :
            .rect.left > :
                .rect.left -= .speed
            :
                .live = .direction == :
            .rect.left < MainGame.SCREEN_WIDTH - .rect.width:
                .rect.left += .speed
            :
                .live = ():
        MainGame.window.blit(.image.rect)
Explode():
    ():
        ():
        Wall():
    ():
        ():
        Music():
    ():
        ():
        MainGame().startGame()

检查了好几次,每次到了8分38秒此时效果时候就弹出下面的提示,该怎么处理呢?

image.png

Python 全系列/第二阶段:Python 深入与提高/游戏开发-坦克大战 9149楼

课程分类

百战程序员微信公众号

百战程序员微信小程序

©2014-2025百战汇智(北京)科技有限公司 All Rights Reserved 北京亦庄经济开发区科创十四街 赛蒂国际工业园
网站维护:百战汇智(北京)科技有限公司
京公网安备 11011402011233号    京ICP备18060230号-3    营业执照    经营许可证:京B2-20212637