java 连接mysql并执行sql语句

最新推荐文章于 2023-11-20 21:30:05 发布

备忘录_bwl

最新推荐文章于 2023-11-20 21:30:05 发布

阅读量426

点赞数

文章标签： java 开发语言

本文链接：https://blog.csdn.net/chc_94/article/details/126147026

版权


```java
package cc.dfsoft.usmart;

import cc.dfsoft.usmart.core.cmdbuild.domain.pojo.MeterStateTemplateValuePojo;
import cc.dfsoft.usmart.core.cmdbuild.util.DateFilterUtil;
import cc.dfsoft.usmart.core.cmdbuild.util.DateFormatUtil;
import cc.dfsoft.usmart.core.collection.domain.bean.MeterStateTemplate;
import cc.dfsoft.usmart.core.settlement.domain.PriceInfoDto;
import cc.dfsoft.usmart.redis.SerializableTool;
import cc.dfsoft.usmart.util.ByteUtil;
import cc.dfsoft.usmart.util.JSONUtil;
import cc.dfsoft.usmart.util.StringUtil;
import com.fasterxml.jackson.core.type.TypeReference;
import com.fasterxml.jackson.databind.ObjectMapper;
import org.apache.commons.lang3.StringUtils;
import org.apache.commons.lang3.SystemUtils;

import java.math.BigDecimal;
import java.sql.*;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;

public class demo {

	public static void main(String[] args) throws ParseException {

		

//使用jdbc链接数据库
		try {
			int ColumnCount;
			Class.forName("com.mysql.cj.jdbc.Driver").newInstance();

		
		String url = "jdbc:mysql://1111111111:3306/usmartsass?characterEncoding=UTF-8";
		String user = "111111111";
		String password = "BBu393wV1S3yKYKx3";
		//获取数据库连接

			Connection conn = (Connection) DriverManager.getConnection ( url, user, password );

			if (!conn.isClosed ()) {

				System.out.println("数据库连接成功：");



		String sqls = "SELECT * from user ";
				PreparedStatement ps = conn.prepareStatement(sqls);

				ResultSet rs = ps.executeQuery();

				List list = new ArrayList();
				List meterNolist = new ArrayList();

				ResultSetMetaData rsmd = rs.getMetaData();

				while (rs.next()) {

					ColumnCount = rsmd.getColumnCount();

					Map rowData = new HashMap();

					for (int i = 1; i <= ColumnCount; i++) {

						rowData.put(rsmd.getColumnName(i), rs.getObject(i));
					
					}

//将ResultSet结果集写入list

					list.add(rowData);

				}

				System.out.println(list);

				ps.close();

				conn.close();

			}

		} catch (InstantiationException e) {
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}