这是加上过滤器后，一启动eclipse就报的错误，但是IDEA没事

老师，过滤器这边同样的代码。为什么我在IDEA跑起来没有任何问题，但是用IDEA跑，他把图片，CSS，JS文件都给过滤了？ ，如果我不加

这些的话，连样式什么都出不来

Mybatis_Mybatis入门案例

导入jar包

pojo包

com.bjsxt.pojoUsers {
    String String () {
        }

    (userid) {
        .= userid}

    String () {
        }

    (String username) {
        .= username}

    String () {
        }

    (String usersex) {
        .= usersex}
}

mybatis-cfg.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

    <!--引入properties文件-->
    <properties resource="db.properties"/>

    <!--环境的配置-->
    <environments default="development">
        <environment id="development">
            <!--配置事务-->
            <transactionManager type="JDBC"></transactionManager>
            <!--配置数据源-->
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="#{jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <!--引入映射配置文件-->
    <mappers>
        <!--使用相对路径方式引入-->
        <mapper resource="com/bjsxt/mapper/UsersMapper.xml"/>
    </mappers>
</configuration>

bd.properties文件

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/bjsxt
jdbc.username=root
jdbc.password=root

mapper包

select * from users

dao包

com.bjsxt.daocom.bjsxt.pojo.Usersjava.io.IOExceptionjava.util.ListUsersDao {
    List<Users> () IOException}

impl包

package com.bjsxt.dao.impl;

import com.bjsxt.dao.UsersDao;
import com.bjsxt.pojo.Users;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class UsersDaoImpl implements UsersDao {
    /**
     * 查询所有用户
     * @return
     */
    @Override
    public List<Users> selectUsersAll() throws IOException {
        //创建SqlSessionFactory对象
        InputStream inputStream = Resources.getResourceAsStream("mybatis-cfg.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //获取SqlSession对象
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //通过SqlSession对象下的API完成对数据库的操作
        List<Users> list = sqlSession.selectList("com.bjsxt.mapper.UserMapper.selectUsersAll");
        //关闭SqlSession对象
        sqlSession.close();
        return list;
    }
}

test包

com.bjsxt.testcom.bjsxt.dao.UsersDaocom.bjsxt.dao.impl.UsersDaoImplcom.bjsxt.pojo.Usersjava.io.IOExceptionjava.util.ListTest {
    (String[] args)IOException {
        UsersDao usersDao = UsersDaoImpl()List<Users> list = usersDao.selectUsersAll()(Users users:list){
            System..println(users.getUserid()++users.getUsername()++users.getUsersex())}
    }
}

报警

D:\Java\jdk1.8.0_192\bin\java.exe "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2020.1\lib\idea_rt.jar=52913:C:\Program Files\JetBrains\IntelliJ IDEA 2020.1\bin" -Dfile.encoding=UTF-8 -classpath "D:\java\jdk1.8.0_192\jre\lib\charsets.jar;D:\java\jdk1.8.0_192\jre\lib\deploy.jar;D:\java\jdk1.8.0_192\jre\lib\ext\access-bridge-64.jar;D:\java\jdk1.8.0_192\jre\lib\ext\cldrdata.jar;D:\java\jdk1.8.0_192\jre\lib\ext\dnsns.jar;D:\java\jdk1.8.0_192\jre\lib\ext\jaccess.jar;D:\java\jdk1.8.0_192\jre\lib\ext\jfxrt.jar;D:\java\jdk1.8.0_192\jre\lib\ext\localedata.jar;D:\java\jdk1.8.0_192\jre\lib\ext\nashorn.jar;D:\java\jdk1.8.0_192\jre\lib\ext\sunec.jar;D:\java\jdk1.8.0_192\jre\lib\ext\sunjce_provider.jar;D:\java\jdk1.8.0_192\jre\lib\ext\sunmscapi.jar;D:\java\jdk1.8.0_192\jre\lib\ext\sunpkcs11.jar;D:\java\jdk1.8.0_192\jre\lib\ext\zipfs.jar;D:\java\jdk1.8.0_192\jre\lib\javaws.jar;D:\java\jdk1.8.0_192\jre\lib\jce.jar;D:\java\jdk1.8.0_192\jre\lib\jfr.jar;D:\java\jdk1.8.0_192\jre\lib\jfxswt.jar;D:\java\jdk1.8.0_192\jre\lib\jsse.jar;D:\java\jdk1.8.0_192\jre\lib\management-agent.jar;D:\java\jdk1.8.0_192\jre\lib\plugin.jar;D:\java\jdk1.8.0_192\jre\lib\resources.jar;D:\java\jdk1.8.0_192\jre\lib\rt.jar;D:\code\servlet\mybatisdemo\out\production\mybatisdemo;D:\SSM 框架和项目开发 Mybatis\SSM 框架和项目开发 Mybatis\软件\lib\asm-7.1.jar;D:\SSM 框架和项目开发 Mybatis\SSM 框架和项目开发 Mybatis\软件\lib\cglib-3.3.0.jar;D:\SSM 框架和项目开发 Mybatis\SSM 框架和项目开发 Mybatis\软件\lib\ognl-3.2.14.jar;D:\SSM 框架和项目开发 Mybatis\SSM 框架和项目开发 Mybatis\软件\lib\log4j-1.2.17.jar;D:\SSM 框架和项目开发 Mybatis\SSM 框架和项目开发 Mybatis\软件\lib\mybatis-3.5.5.jar;D:\SSM 框架和项目开发 Mybatis\SSM 框架和项目开发 Mybatis\软件\lib\log4j-api-2.13.3.jar;D:\SSM 框架和项目开发 Mybatis\SSM 框架和项目开发 Mybatis\软件\lib\slf4j-api-1.7.30.jar;D:\SSM 框架和项目开发 Mybatis\SSM 框架和项目开发 Mybatis\软件\lib\log4j-core-2.13.3.jar;D:\SSM 框架和项目开发 Mybatis\SSM 框架和项目开发 Mybatis\软件\lib\commons-logging-1.2.jar;D:\SSM 框架和项目开发 Mybatis\SSM 框架和项目开发 Mybatis\软件\lib\javassist-3.27.0-GA.jar;D:\SSM 框架和项目开发 Mybatis\SSM 框架和项目开发 Mybatis\软件\lib\slf4j-log4j12-1.7.30.jar;D:\SSM 框架和项目开发 Mybatis\SSM 框架和项目开发 Mybatis\软件\lib\mysql-connector-java-5.1.48.jar" com.bjsxt.test.Test

log4j:WARN No appenders could be found for logger (org.apache.ibatis.logging.LogFactory).

log4j:WARN Please initialize the log4j system properly.

log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

Thu Dec 31 13:19:56 CST 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException: 

### Error querying database.  Cause: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

### The error may exist in com/bjsxt/mapper/UsersMapper.xml

### The error may involve com.bjsxt.mapper.UserMapper.selectUsersAll

### The error occurred while executing a query

### Cause: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:135)

at com.bjsxt.dao.impl.UsersDaoImpl.selectUsersAll(UsersDaoImpl.java:27)

at com.bjsxt.test.Test.main(Test.java:13)

Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:864)

at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1707)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217)

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:768)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:208)

at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:224)

at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:219)

at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:95)

at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:432)

at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:89)

at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:139)

at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:61)

at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)

at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)

at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)

at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)

at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)

... 4 more

Process finished with exit code 1

sub.disabled=!check.checked;

老师麻烦帮我讲下上面这行代码，不是很理解，麻烦老师了

老师，同样的代码不知道为什么写在eclipse就一直找不到Driver类了，我也引入jar包了 

为什么我的背景没有效果?之前的都有就是到了商品栏这里没有效果了

@WebServlet("/logout.do")
public class LogoutServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        HttpSession session = req.getSession();
        session.invalidate();
        resp.sendRedirect("login.jsp");
    }
}

<li><cite></cite><a href="logout.do" target="rightFrame">退出登陆</a><i></i></li>

报404为什么呢

为什么在这个url后面要加个 ？呢                        

老师跨域的解决方法cors没有讲到吧，用cors怎么做跨域呢？谢谢！

# coding=utf-8
import pymysql
# pip install cryptography

# 创建连接
con = pymysql.connect(host='localhost',user='root',database='python_db',password='123456',port=3306)
print(con)
# 创建游标对象
cur = con.cursor()
# 编写创建表的sql
sql="""
    creat table t_student(
    sno int primary key auto_increment,
    sname varchar(30) not null,
    age int(2),
    score float(3,1)
    );
"""
try:
    # 执行创建标的sql
    cur.execute(sql)
    print('创建表成功')
except Exception as e:
    print(e)
    print('创建表失败')
finally:
    # 关闭连接
    con.close()

报错：

<pymysql.connections.Connection object at 0x0000014B8DE3C908>
(1064, "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 'creat table t_student(\n    sno int 
primary key auto_increment,\n    sname varchar' at line 1")
创建表失败

老师，为什么这里无法打印这个return值呢？

老师请问这个项目全部更新好了的吗，可以作为毕业设计参考吗

#coding=utf-8
'''组件对象的绑定
1.通过command属性绑定(适合简单不需获取event对象) Button(root,text="登录",command=login)
2.通过bind()方法绑定(适合需要获取evnet对象) c1 = Canvas(); c1.bind("<Button-1>",drawLine)
   组件类的绑定
调用对象的bind_class函数，将该组件类所有的组件绑定事件：
w.bind_class("Widget","event",eventhanler) 比如：btn01.bind_class("Button","<Button-1>",func)
'''
#多种事件绑定方式汇总
from tkinter import *
root = Tk()
root.geometry("270x30")

def mouseTest1(event):
    print("bind()方式绑定,可获取event对象")
    print(event.widget)

def mouseTest2(a, b):
    print("a={0}, b={1}".format(a, b))
    print("command方式绑定,不能直接获取event对象")

def mouseTest3(event):
    print("钟呢呢右键单击事件，绑定给所有按钮啦！！")
    print(event.widget)

b1 = Button(root, text="测试bind()绑定") #第一个按钮b1
b1.pack(side="left")
b1.bind("<Button-1>", mouseTest1) #bind方式绑定事件

b2 = Button(root, text="测试command绑定", command=lambda: mouseTest2("xiannv", "zhongnene"))#第二个按钮b2 通过lambda直接传参
b2.pack(side="left")

b1.bind_class("<Button>", "<Button-2>", mouseTest3)#给所有Button按钮都绑定右键单击事件<Button-2>

root.mainloop()

<button-2>为鼠标中键，然而单击鼠标中键没反应

看视频高老师是单击的鼠标右键 我也试了但也没反应

老师，用的第二种方法依然没解决无二级权限，后续就无需列表

我这样改了下，返回数据时无二级菜单的就无列表

老师，看视频里写的

public ...

void....

static...

但是自己写的时候不知道什么时候改用那个来修饰，只能对着视频敲，不知道什么意思

看了一些解释还是很懵