mysql jdbc入门_JDBC入门和MySQL常用语句

创建JDBC应用程序

注册JDBC驱动程序

初始化驱动程序，这样就可以打开与数据库的通信

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

打开链接

使用DriverManager.getConnection()方法来创建一个Connection对象

Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/testdb?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC", "user0", "123456");

执行语句

使用一个类型为Statement或PreparedStatement的对象，并提交一个SQL语句到数据库执行

String sql = "UPDATE user SET password = 'uuu' where name = 'ccc'";

Statement statement = connection.createStatement();

System.out.println(statement.executeUpdate(sql));

4.提取数据

若为查询语句，会从数据库中获取查询结果的数据。可以使用适当的ResultSet.getXXX()方法得到检索的数据

String sql = "select password from user where name = 'ccc'";

Statement statement = connection.createStatement();

ResultSet resultSet = statement.executeQuery(sql);

resultSet.next();

String name = resultSet.getString("password");

System.out.println(name);

释放资源

statement.close();

connection.close();

JDBC常用SQL语句

创建数据表

以下为创建MySQL数据表的SQL通用语法：

CREATE TABLE table_name (column_name column_type);

插入数

INSERT INTO table_name ( field1, field2,...fieldN )

VALUES

( value1, value2,...valueN );

更新数据

UPDATE table_name SET field1=new-value1, field2=new-value2

[WHERE Clause]

查询数据

SELECT column_name,column_name FROM table_name [WHERE Clause]

数据排序

SELECT field1, field2,...fieldN FROM table_name1, table_name2... RDER BY field1 [ASC [DESC][默认 ASC]], [field2...] [ASC [DESC][默认 ASC]]

WHERE子句

SELECT field1, field2,...fieldN FROM table_name1, table_name2... WHERE condition1 [AND [OR]] condition2.....