使用statement访问MySQL数据库

使用statement访问MySQL数据库

package study;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
//定义一个JDBCdemo类
public class JDBCdemo {
	private final String USERNAME = "root";//用户名
	private final String PASSWORD = "123456";//密码
	private final String URL = "jdbc:mysql://localhost:3306/test?serverTimezone=UTC";//指定服务器时区
	Connection connection = null;
	Statement statement = null;

	public void update() {//更新操作（增，删，改）
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");//加载MySQL数据库驱动  mysql-connector-java-8.0.17.jar  （注意：类名里边的cj）
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);//和数据库建立连接
			statement = connection.createStatement();
			String sql1 = "insert into user values(3,'张俊华','男');";
			String sql2 = "update user set uname='陈明想' where uid=1;";
			String sql3 = "delete from user where uid=43";
			int executeUpdate = statement.executeUpdate(sql3);
			if (executeUpdate != 0) {
				// System.out.println("insert 操作成功");
				// System.out.println("update 操作成功");
				System.out.println("delete 操作成功");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if (statement != null)//关闭连接
					statement.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				if (connection != null)//关闭连接
					connection.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}

-- 创建测试类 --

package study;

public class JDBCtest {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		JDBCdemo jdbcdemo = new JDBCdemo();
		jdbcdemo.update();
		System.out.println("hello, operation end!");
	}

}

执行结果如下：