通过java连接并处理数据库的脚本代码样例

目录

 

1.测试主类

2.涉及的ExcelmportUtils 工具类

---

1.测试主类

package com.example.demo.utils;

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import com.example.demo.entity.CmsLife;

/**
 * @author hanzl
 * @date 2020/6/17 5:01 下午
 */
public class MySQLCmsLifeConnection {
  public static void main(String [] args) throws Exception{
    String url="jdbc:mysql://****";
    String user="user";
    String password="aaa";
    PreparedStatement stmt = null;
    PreparedStatement stmtQuery = null;

    try {
      //1. 加载驱动
      Class.forName("com.mysql.cj.jdbc.Driver");
      //2. 获取连接
      Connection conn= DriverManager.getConnection(url,user,password);
      // 执行查询
      System.out.println(" 实例化Statement对...");
      String sql = "insert into t_car_life (f_id, f_type,f_resouce_id,f_sort,f_status,f_publish_time,f_create_by,f_create_time,f_yn) "
          + "values(?,?,?,?,?,?,?,?,1)";

      //增加insert
      String filePath = "/Users/mac/Desktop/cmsLife.xlsx";
      File file=new File(filePath);
      InputStream inputStream=new FileInputStream(file);
      List<CmsLife> list= ExcelmportUtils.encapsulationJaveBean(inputStream,new CmsLife(),"YYYY-MM-dd HH:mm:ss");

      int index=0;
      for(CmsLife cs:list){
        index++;
        System.out.println(cs.getId());
        System.out.println(sql);

        String sqlQury = "select f_id  as id fr