Mysql 数据库命令、读取MySQL数据

客官°小女子只卖身不卖艺 2023-06-13 04:55 15阅读 0赞

# MySQL安装步骤（ZIP版） #

[https://blog.csdn.net/QQ943889638/article/details/91357517][https_blog.csdn.net_QQ943889638_article_details_91357517]

## IntelliJ IDEA 连接数据库 详细过程 ##

[https://www.cnblogs.com/Ran-Chen/p/9646187.html][https_www.cnblogs.com_Ran-Chen_p_9646187.html]

## 一、Mysql 数据库命令 ##

<table> 
 <thead> 
  <tr> 
   <th>进入终端，连接 mysql</th> 
   <th>mysql -h localhost -P3306 -u root -p</th> 
   <th>注意啊，这句结尾没 分号，其它命令是有分号的</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>显示数据表</td> 
   <td>show databases;</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>退出数据库</td> 
   <td>exit;</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
   <td></td> 
  </tr> 
 </tbody> 
</table>

## 二、连接 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();
            }
        }
    
    
    }

[https_blog.csdn.net_QQ943889638_article_details_91357517]: https://blog.csdn.net/QQ943889638/article/details/91357517
[https_www.cnblogs.com_Ran-Chen_p_9646187.html]: https://www.cnblogs.com/Ran-Chen/p/9646187.html