JAVA连接mysql数据库例程

最新推荐文章于 2025-12-29 17:07:25 发布

原创最新推荐文章于 2025-12-29 17:07:25 发布 · 367 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #java

J2SE基础专栏收录该内容

2 篇文章

订阅专栏

本文提供了一个使用Java连接MySQL数据库并从特定表中检索时间数据的示例。通过加载MySQL JDBC驱动程序并建立数据库连接，该示例展示了如何执行简单的SQL查询来获取存储的时间值。

package com.xmty.testmysql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Test {

	public int getPushTime() {
		int time = 0;
		String dbDriver = "com.mysql.jdbc.Driver";
		String dbUrl = "jdbc:mysql://localhost:3306/timetask?user=root&password=tiger";
		String dbUser = "root";
		String dbPassword = "tiger";
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		try {
			Class.forName(dbDriver);
			conn = DriverManager.getConnection(dbUrl);
			String sql = "select * from timeint";
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			if (rs.next()) {
				time = rs.getInt("time");
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			if (null != conn) {
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				conn = null;
			}
			if (null != stmt) {
				try {
					stmt.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				stmt = null;
			}
			if (null != rs) {
				try {
					rs.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				rs = null;
			}
		}
		System.out.println("获取的时间为：" + time);
		return time;
	}
	
	public static void main(String[] args) {
		new Test().getPushTime();
	}

}