JDBC的学习

JDBC

一、连接数据库操作

1、加载驱动

Class.forName("com.mysql.cj.jdbc.Driver");

2、创建连接对象

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/myschool", "root", "123456");

3、通过连接对象创建执行SQL命令的对象

Statement stmt=conn.createStatement();

4、创建SQL语句

String sql="al from student where StudentNo=1001";

5、执行SQL,并返回结果

int num = stmt.executeUpdate(sql);

6、关闭资源

stmt.close();
conn.close();

4.2 新增操作

关于时间的三种写法

4.2.1 时间戳

Date dt = new Date();
Timestamp timestamp = new Timestamp(dt.getTime());

String sql = "insert into news(newsTitle,createTime,author,city,newsContent)" +
" value('mmmmmm','" + timestamp + "','新华','北京','ddddddddddd')";

4.2.2 mysql的now()函数

 String sql = "insert into news(newsTitle,createTime,author,city,newsContent)" +
                    " value('mmmmmm',now(),'新华','北京','ddddddddddd')";

4.2.3 日期格式的字符串

String sql = "insert into news(newsTitle,createTime,author,city,newsContent)" +
                    " value('mmmmmm','2021-01-01 12:12:12','新华','北京','ddddddddddd')";

4.2.4 数据库的连接语句

jdbc:mysql://localhost:3306/news_db?serverTimezone=GMT%2B8&useUnicode=true&useSSL=false&characterEncoding=utf8