java和Mysql互通

1.mysql

1. mysql创建数据库zjgm
   
   2.zjgm数据库后创建stu表
   2.java

1.在src创建包，在包里创建test
package zhongruan;

import java.sql.*;

public class test{
public static void main(String[] args) throws ClassNotFoundException, SQLException {
2.创建lib,lib里加mysql包

//1.加载驱动
Class.forName(“com.mysql.jdbc.Driver”);
//2.创建连接
Connection connection =DriverManager.getConnection(“jdbc:mysql://localhost/zjgm?user=root&password=123456&characterEncoding=utf-8&useSSL=true”);
System.out.println(“创建连接成功”);
//3.写sql
String sql=“selectfrom stu";
//4.得到statement对象
PreparedStatement statement = connection.prepareStatement(sql);
//5.执行sql
ResultSet resultSet =statement.executeQuery();
//6.处理结果集
while (resultSet.next()){
int id = resultSet.getInt( 1);
String name = resultSet.getString(2);
int age = resultSet.getInt( 3);
System.out.println(id+name+age);
//查看
//String sql="selectfrom stu”;
//PreparedStatement statement = connection.prepareStatement(sql);
//加
//String sql=“INSERT INTO stu(id,name,age)VALUES (8,‘erss’,977)”;
//PreparedStatement statement =connection.prepareStatement(sql);
//statement.executeUpdate();
//删除
//String sql = “DELETE FROM stu WHERE id = 2”;
//PreparedStatement statement =connection.prepareStatement(sql);
//statement.executeUpdate();
//ResultSet resultSet =statement.executeQuery();
//改
//String sql=“UPDATE stu SET name=99, age=99 WHERE id=1”;
//关闭
//PreparedStatement statement =connection.prepareStatement(sql);
//statement.executeUpdate();