有效沟通问答-【官方】百战程序员_IT在线教育培训机构

com.bjsxt;

java.sql.Connection;
java.sql.DriverManager;
java.sql.SQLException;
java.sql.Statement;

JdbcTest {
    insertDepartments(String department_name,location_id){
        Connection conn = ;
        Statement state = ;
        {
            Class.();
            conn = DriverManager.(,,);
            String sql=+department_name++location_id+;
            state = conn.createStatement();
            falg = state.executeUpdate(sql);
            System..println(falg);
        } (Exception e) {
            e.printStackTrace();
        }{
            (state !=){
                {
                    state.close();
                } (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
        (conn !=){
            {
                conn.close();
            } (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    main(String[] args) {
        JdbcTest test = JdbcTest();
        test.insertDepartments(,);
    }
}

还在报错，请老师解惑。

JAVA 全系列/第四阶段：数据库与AI协同技术实战/JDBC技术（旧） 35513楼

com.bjsxt;

java.sql.Connection;
java.sql.DriverManager;
java.sql.SQLException;
java.sql.Statement;

JdbcTest {
    insertDepartments(String department_name,location_id){
        Connection conn = ;
        Statement state = ;
        {
            Class.();
            conn = DriverManager.(,,);
            String sql=+department_name++location_id+;
            state = conn.createStatement();
            falg = state.executeUpdate(sql);
            System..println(falg);
        } (Exception e) {
            e.printStackTrace();
        }{
            (state !=){
                {
                    state.close();
                } (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
        (conn !=){
            {
                conn.close();
            } (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    main(String[] args) {
        JdbcTest test = JdbcTest();
        test.insertDepartments(,);
    }
}

老师：String sql="insert into departments values(default,'"+department_name+"',"+location_id+")";（逗号加了后运行还在报错）

Mon Nov 04 18:55:35 CST 2019 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.

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:3978)

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

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

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

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

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

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

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

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

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:386)

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

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

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

at com.bjsxt.JdbcTest.insertDepartments(JdbcTest.java:17)

at com.bjsxt.JdbcTest.main(JdbcTest.java:44)

请老师再帮忙检查下。

JAVA 全系列/第四阶段：数据库与AI协同技术实战/JDBC技术（旧） 35514楼

TCP不是具有保活机制吗，如果客户端断开了连接，服务端就没法收到ACK响应，这样的话

服务端不是可以在有限次数之内进行重发吗，如果达到了次数就自动断开了吗，为什么RabbitMQ是基于

TCP的但是它不会保活

JAVA 全系列/（旧的隐藏）第十二阶段：spring全家桶（Spring Cloud）/Spring Cloud 35515楼

老师，您看下最后一题我这思路有问题吗，如果可以的话我这代码哪出问题了

Python 全系列/第一阶段：Python入门/函数和内存分析 35516楼

请问高老师怎么把10这个值传进去到递归算法里的阿

JAVA 全系列/第一阶段：AI驱动的JAVA编程/控制语句、方法、递归算法 35517楼

运行结果：

D:\java\bin\java.exe "-javaagent:D:\idea\IntelliJ IDEA 2019.1.3\lib\idea_rt.jar=58536:D:\idea\IntelliJ IDEA 2019.1.3\bin" -Dfile.encoding=UTF-8 -classpath D:\java\jre\lib\charsets.jar;D:\java\jre\lib\deploy.jar;D:\java\jre\lib\ext\access-bridge-64.jar;D:\java\jre\lib\ext\cldrdata.jar;D:\java\jre\lib\ext\dnsns.jar;D:\java\jre\lib\ext\jaccess.jar;D:\java\jre\lib\ext\jfxrt.jar;D:\java\jre\lib\ext\localedata.jar;D:\java\jre\lib\ext\nashorn.jar;D:\java\jre\lib\ext\sunec.jar;D:\java\jre\lib\ext\sunjce_provider.jar;D:\java\jre\lib\ext\sunmscapi.jar;D:\java\jre\lib\ext\sunpkcs11.jar;D:\java\jre\lib\ext\zipfs.jar;D:\java\jre\lib\javaws.jar;D:\java\jre\lib\jce.jar;D:\java\jre\lib\jfr.jar;D:\java\jre\lib\jfxswt.jar;D:\java\jre\lib\jsse.jar;D:\java\jre\lib\management-agent.jar;D:\java\jre\lib\plugin.jar;D:\java\jre\lib\resources.jar;D:\java\jre\lib\rt.jar;D:\code\javaBase\out\production\code com.qsq.Service.HTML.SocketTest

len:800

POST /index.html HTTP/1.1

Host: localhost:9999

Connection: keep-alive

Content-Length: 34

Cache-Control: max-age=0

Origin: http://localhost:63342

Upgrade-Insecure-Requests: 1

Content-Type: application/x-www-form-urlencoded

User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.87 Safari/537.36

Sec-Fetch-User: ?1

Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3

Sec-Fetch-Site: same-site

Sec-Fetch-Mode: navigate

Referer: http://localhost:63342/javaBase/code/com/qsq/Service/HTML/index.html?_ijt=k8t0dqesk7qbcnbgkuemfqcn69

Accept-Encoding: gzip, deflate, br

Accept-Language: zh-CN,zh;q=0.9

Cookie: Idea-f60c4641=c8fd0e4c-b10e-428c-9f8a-7de24435d478

Process finished with exit code 0

问题：如何获取请求正文username和password的内容？

JAVA 全系列/第二阶段：JAVA 基础深化和提高/手写服务器项目（旧） 35518楼

com.qsq.Service.HTMLcom.qsq.Service.Socket.CloseUtiljava.io.BufferedReaderjava.io.InputStreamjava.io.InputStreamReaderjava.net.ServerSocketjava.net.SocketSocketTest {
    (String[] args){
        ServerSocket serverSocket = Socket socket = InputStream inputStream = {
            serverSocket = ServerSocket()socket = serverSocket.accept()inputStream = socket.getInputStream()[] buf =  []len = inputStream.read(buf)System..println(+ len)System..println(String(buflen))} (Exception e) {
            e.printStackTrace()}{
            CloseUtil.(inputStreamserverSocketserverSocket)}
    }
}

JAVA 全系列/第二阶段：JAVA 基础深化和提高/手写服务器项目（旧） 35519楼

Java:

com.qsq.Service.HTMLcom.qsq.Service.Socket.CloseUtiljava.io.BufferedReaderjava.io.InputStreamjava.io.InputStreamReaderjava.net.ServerSocketjava.net.SocketSocketTest {
    (String[] args){
        ServerSocket serverSocket = Socket socket = InputStream inputStream = {
            serverSocket = ServerSocket()socket = serverSocket.accept()inputStream = socket.getInputStream()[] buf =  []len = inputStream.read(buf)System..println(+ len)System..println(String(buflen))} (Exception e) {
            e.printStackTrace()}{
            CloseUtil.(inputStreamserverSocketserverSocket)}
    }
}

html:

form测试用户名:
                密码: