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

drawpad  一直报错,我是照抄的。。
tkinter.filedialog *
tkinter.colorchooser *

win_width=win_height=(Frame):

    (,master=,bgcolor=):
        ().(master)    .master=master
        .bgcolor=bgcolor
        .x = .y = .fgcolor = .lastDraw = .startDrawFlag = .pack()
        .createWidget()

    ():
        drawpad = Canvas(root,=win_width,=win_height*,=.bgcolor)
        drawpad.pack()

        btn_start = Button(root,=,=)
        btn_start.pack(=,=)
        btn_pen = Button(root, =, =)
        btn_pen.pack(=, =)
        btn_rect = Button(root, =, =)
        btn_rect.pack(=, =)
        btn_clear = Button(root, =, =)
        btn_clear.pack(=, =)
        btn_erasor = Button(root, =, =)
        btn_erasor.pack(=, =)
        btn_line = Button(root, =, =)
        btn_line.pack(=, =)
        btn_lineArrow = Button(root, =, =)
        btn_lineArrow.pack(=, =)
        btn_color= Button(root, =, =)
        btn_color.pack(=, =)

        btn_pen.bind_class(,,.eventManager)
        .drawpad.bind(,.stopDraw)

        root.bind(, .kuaijiejian)
        root.bind(, .kuaijiejian)
        root.bind(, .kuaijiejian)



    (,event):
        name = event.widget.winfo_name()
        (name)
        name==.drawpad.bind(,.myline)
        name==:
            .drawpad.bind(, .mylineArrow)
        name==:
            .drawpad.bind(, .myRect)
        name==:
            .drawpad.bind(, .myPen)
        name == :
            .drawpad.bind(, .myErasor)
        name == :
            .drawpad.delete()
        name ==:
            c = askcolor(=.fgcolor,=)
            .fgcolor = c[]

    (,):
        .startDrawFlag = .lastDraw = (,event):
        .drawpad.delete(.lastDraw)
        .startDrawFlag:
            .startDrawFlag=.x = event.x
            .y = event.y



    (,event):
        .startDraw(event)
        .lastDraw = .drawpad.create_line(.x,.y,event.x,event.y,=.fgcolor)
    (,event):
        .startDraw(event)
        .lastDraw = .drawpad.create_line(.x,.y,event.x,event.y,=LAST,=.fgcolor)
    (,event):
        .startDraw(event)
        .lastDraw = .drawpad.create_rectangle(.x,.y,event.x,event.y,=.fgcolor)

    (, event):
        .startDraw(event)
        .drawpad.create_line(.x, .y, event.x, event.y, =.fgcolor)
        .x = event.x
        .y = event.y

    (, event):
        .startDraw(event)
        .drawpad.create_line(event.x-, event.y-, event.x+, event.y+, =.bgcolor)
        .x = event.x
        .y = event.y

    (,event):
        event.char ==:
            .fgcolor = event.char ==:
            .fgcolor = event.char == :
            .fgcolor = __name__ == :
    root = Tk()
    root.geometry((win_width)++(win_height)+)
    root.title()
    app = Application(=root)
    root.mainloop()


Python 全系列/第二阶段:Python 深入与提高/GUI编程(隐藏) 31996楼

老师好:

          示例三,视频里老师测试的两种结果是一样的吧,没看出有什么区别,

第一种:

SQL> select last_name,job_id from employees where job_id like 'SA_%';
LAST_NAME                 JOB_ID
------------------------- ----------
Abel                      SA_REP
Ande                      SA_REP
Banda                     SA_REP
Bates                     SA_REP
Bernstein                 SA_REP
Bloom                     SA_REP
Cambrault                 SA_MAN
Cambrault                 SA_REP
Doran                     SA_REP
Errazuriz                 SA_MAN
Fox                       SA_REP
Grant                     SA_REP
Greene                    SA_REP
Hall                      SA_REP
Hutton                    SA_REP
Johnson                   SA_REP
King                      SA_REP
Kumar                     SA_REP
Lee                       SA_REP
Livingston                SA_REP
LAST_NAME                 JOB_ID
------------------------- ----------
Marvins                   SA_REP
McEwen                    SA_REP
Olsen                     SA_REP
Ozer                      SA_REP
Partners                  SA_MAN
Russell                   SA_MAN
Sewall                    SA_REP
Smith                     SA_REP
Smith                     SA_REP
Sully                     SA_REP
Taylor                    SA_REP
Tucker                    SA_REP
Tuvault                   SA_REP
Vishney                   SA_REP
Zlotkey                   SA_MAN
35 rows selected

第二种:

SQL> select last_name,job_id from employees where job_id like 'SA\_%' escape '\';
LAST_NAME                 JOB_ID
------------------------- ----------
Abel                      SA_REP
Ande                      SA_REP
Banda                     SA_REP
Bates                     SA_REP
Bernstein                 SA_REP
Bloom                     SA_REP
Cambrault                 SA_MAN
Cambrault                 SA_REP
Doran                     SA_REP
Errazuriz                 SA_MAN
Fox                       SA_REP
Grant                     SA_REP
Greene                    SA_REP
Hall                      SA_REP
Hutton                    SA_REP
Johnson                   SA_REP
King                      SA_REP
Kumar                     SA_REP
Lee                       SA_REP
Livingston                SA_REP
LAST_NAME                 JOB_ID
------------------------- ----------
Marvins                   SA_REP
McEwen                    SA_REP
Olsen                     SA_REP
Ozer                      SA_REP
Partners                  SA_MAN
Russell                   SA_MAN
Sewall                    SA_REP
Smith                     SA_REP
Smith                     SA_REP
Sully                     SA_REP
Taylor                    SA_REP
Tucker                    SA_REP
Tuvault                   SA_REP
Vishney                   SA_REP
Zlotkey                   SA_MAN
35 rows selected


JAVA 全系列/第三阶段:数据库编程/SQL 语言 31997楼

封装jdbc

package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;

public class jdbcUtil {
    //获取connection对象
    //关闭connection
    //关闭statement对象
    private static String driver="com.mysql.jdbc.Driver";
    private static String connectionUrl="jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf8";
    private static String username="root";
    private  static String psw="123456";

    static {
        //读取propertile
        /*ResourceBundle  bundle=ResourceBundle.getBundle("jdbc");
        driver=bundle.getString("driver");
        connectionUrl=bundle.getString("connectionUrl");
        username=bundle.getString("username");
        psw=bundle.getString("psw");*/
        
        try {
            Class.forName(driver);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    public static Connection getConnection(){
        Connection conn=null;
        try {
            conn= DriverManager.getConnection(connectionUrl,username,psw);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }
    public static void closeStatement(Statement state){
        if(state!=null){
            try {
                state.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    public static void closeConnection(Connection conn){
        if(conn!=null){
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

测试

package jdbc;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
public class testJdbc {
    public void insertTable(){
        //驱动注册
        Connection conn=null;
        Statement state=null;
        try {
            conn=jdbcUtil.getConnection();
            String str="insert into usertable values(4,'zhao','123','123@1qq')";
            state=conn.createStatement();
            int flag=state.executeUpdate(str);
            System.out.print(flag);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            jdbcUtil.closeConnection(conn);
            jdbcUtil.closeStatement(state);
        }

    }
    public static void main(String[] args) {
        testJdbc test=new testJdbc();
        test.insertTable();

    }
}

不用读取properties,运行如下

image.png

我用读取properties文件

properties文件

jdbc.driver=com.mysql.jdbc.Driver
jdbc.connectionUrl=jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.psw=123456
package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;

public class jdbcUtil {
    //获取connection对象
    //关闭connection
    //关闭statement对象
    private static String driver";
    private static String connectionUrl;
    private  static String psw;

    static {
        //读取propertile
        ResourceBundle  bundle=ResourceBundle.getBundle("jdbc");
        driver=bundle.getString("driver");
        connectionUrl=bundle.getString("connectionUrl");
        username=bundle.getString("username");
        psw=bundle.getString("psw");
        
        try {
            Class.forName(driver);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    public static Connection getConnection(){
        Connection conn=null;
        try {
            conn= DriverManager.getConnection(connectionUrl,username,psw);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }
    public static void closeStatement(Statement state){
        if(state!=null){
            try {
                state.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    public static void closeConnection(Connection conn){
        if(conn!=null){
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

测试类代码没变就改了插入的数据,结果运行如下

image.png

我上网查了原因,没有找到加载该类,初始化没有成功,有些博客说在properties文件中加上jdbc.我加了还是不对

image.png

这是为啥

JAVA 全系列/第三阶段:数据库编程/JDBC技术(旧) 31999楼
Python 全系列/第三阶段:Python 网络与并发编程/网络通信 32000楼
JAVA 全系列/第四阶段:网页编程和设计/Javascript 语言(旧) 32001楼
Python 全系列/第二十三阶段:人工智能基础_机器学习理论和实战(旧)/GBDT算法 32004楼
Python 全系列/第二十三阶段:人工智能基础_机器学习理论和实战(旧)/GBDT算法 32005楼
JAVA 全系列/第三阶段:数据库编程/MySQL数据库的使用 32006楼
JAVA 全系列/第三阶段:数据库编程/MySQL数据库的使用 32007楼

课程分类

百战程序员微信公众号

百战程序员微信小程序

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