JDBC阶段学习小结

川长思鸟来 2022-05-27 02:51 148阅读 0赞

**完整项目的jar包**[下载][Link 1]

> 数据库连接步骤  
> `//1.加载驱动程序 Class.forName("com.mysql.jdbc.Driver"); //2.获得数据库的连接 Connection conn = DriverManager.getConnection(URL, USER, PASSWORD); //3.通过数据库的连接操作数据库， 实现增删改查 Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select user_name,age from whs_goddess");`

MyEclipse 10
    删除整行的快捷键 ：CTRL + D

> **[MySQL 警告WARN: Establishing SSL connection without server’s identity verification is not recommended.][MySQL _WARN_ Establishing SSL connection without server_s identity verification is not recommended.]**  
> `Tue Apr 10 16:02:33 CST 2018 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.`  
> 这是警告不是错误，以后使用是不影响的。大概的意思就是说建立ssl连接，但是服务器没有身份认证，这种方式不推荐使用。

**解决办法：**  
　　原来的连接url：

Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "letmein");

现在的连接url:

Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false","root", "letmein");
    // 连接URL为 jdbc:mysql//服务器地址/数据库名 ，后面的2个参数分别是登陆用户名和密码

MyEclipse 10
    注释快捷键 ：
    CTRL + SHIFT + /
    或者 
    CTRL + /

> sql语句写错导致的问题  
> `Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '('小夏',1,22,'2018-04-10','xiaoxia@whs.com','18800005555','ADMIN',current_date' at line 1`

String sql = "" + "INSERT INTO whs_goddess" + "(user_name, sex, age, birthday, email, mobile," + "create_user, create_date, update_user, update_date, isdel" + "VALUES(" + "?,?,?,?,?,?,?,current_date(),?,current_date(),?)";

改成

String sql = "" + "INSERT INTO whs_goddess" + "(user_name, sex, age, birthday, email, mobile," + "create_user, create_date, update_user, update_date, isdel） " + "VALUES(" + "?,?,?,?,?,?,?,current_date(),?,current_date(),?)";

就ok了

[Link 1]: https://download.csdn.net/download/ken1583096683/10343917
[MySQL _WARN_ Establishing SSL connection without server_s identity verification is not recommended.]: http://www.cnblogs.com/xiangyangzhu/