MySQL安装步骤(ZIP版)
https://blog.csdn.net/QQ943889638/article/details/91357517
IntelliJ IDEA 连接数据库 详细过程
https://www.cnblogs.com/Ran-Chen/p/9646187.html
一、Mysql 数据库命令
进入终端,连接 mysql | mysql -h localhost -P3306 -u root -p | 注意啊,这句结尾没 分号,其它命令是有分号的 |
---|---|---|
显示数据表 | show databases; | |
退出数据库 | exit; | |
二、连接 Mysql
import java.sql.*; //导入java.sql包
/**************************
* 连接MySQL数据库程序:
*************************/
public class Login {
static Connection con; //声明Connection对象
static Statement sql; //声明Statement对象
static ResultSet res; //声明ResultSet对象
String url = "jdbc:mysql://110.110.110.110:3306/imm_final?useUnicode=true&characterEncoding=UTF-8&userSSL=false&serverTimezone=GMT%2B8";
String user = "root110";
String password = "root110";
public Connection getConnection() { //建立返回值为Connection的方法
try { //加载数据库驱动
Class.forName("com.mysql.cj.jdbc.Driver"); //com.mysql.jdbc.Driver会出现问题 查看 :https://blog.csdn.net/qq_41943867/article/details/90574135
System.out.println("数据库驱动加载成功");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try { //通过访问数据库的URL获取数据库连接对象
con = DriverManager.getConnection(url, user, password);
System.out.println("数据库连接成功");
System.out.print('\n');
} catch (SQLException e) {
e.printStackTrace();
}
return con; //按方法要求放回一个Connection对象
}
/**************************
* 读表程序:
*************************/
public static void main(String[] args) {
Login c = new Login(); //创建本类对象
con =c.getConnection(); //与数据库建立连接
try {
sql = con.createStatement(); //实例化Statement对象
res = sql.executeQuery("select * from shotdata_order_by_datetime"); // 从建立的10.1.40.45数据库的 shotdata_order_by_datetime 表单读取数据
System.out.print("id");
System.out.print(' ');
System.out.print('|');
System.out.print(' ');
System.out.print("id_t");
System.out.print(' ');
System.out.print('|');
System.out.print(' ');
System.out.print("CYCLE_TIME");
System.out.print(' ');
System.out.print('|');
System.out.print(' ');
System.out.print("INJ_TIME");
System.out.print('\n');
while(res.next()) { //如果当前语句不是最后一条,则进入循环
String id = res.getString("id"); //获取id字段值
String name = res.getString("id_t"); //获取“姓名”字段值
String sex = res.getString("CYCLE_TIME"); //获取“性别”字段值
String age = res.getString("INJ_TIME"); //获取“年龄”字段值
System.out.print(' ');
System.out.print(id); //输出获取到的字段值
System.out.print(' ');
System.out.print('|');
System.out.print(' ');
System.out.print(name);
System.out.print(' ');
System.out.print('|');
System.out.print(' ');
System.out.print(sex);
System.out.print(' ');
System.out.print(' ');
System.out.print(' ');
System.out.print(' ');
System.out.print(' ');
System.out.print('|');
System.out.print(' ');
System.out.print(age);
System.out.print('\n');
}
}catch(SQLException e) {
e.printStackTrace();
}
}
}