eclipse连接mysql代码。。。。。。

最新推荐文章于 2023-01-13 08:54:07 发布

foolboy_

最新推荐文章于 2023-01-13 08:54:07 发布

阅读量243

点赞数

CC 4.0 BY-SA版权

文章标签： eclipse MySQL

本文链接：https://blog.youkuaiyun.com/foolboy_/article/details/97289939

本文详细介绍了如何在Eclipse IDE中配置并连接MySQL数据库，包括安装JDBC驱动，创建数据库连接，编写Java代码进行数据库操作，以及解决常见连接问题的步骤和技巧。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package qwe;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class asd{
	private static final String DB_URL = "jdbc:mysql://localhost:3306/nu123?useUnicode =true&characterEncoding = UTF-8&useSSL =false&serverTimezone = GMT";
	static final String userName = "root";                       //nu123是数据库库名
	static final String passwd = "111111";
	public static void main(String[] args) throws SQLException, ClassNotFoundException {
		Connection con = null;
  		Statement sta = null;
  		Class.forName("com.mysql.cj.jdbc.Driver");
  		System.out.println("Connecting to database...");
  		con = DriverManager.getConnection(DB_URL, userName, passwd);
  		System.out.println("Creating statement...");
 		sta = con.createStatement();
  		String sql;
  		sql = "SELECT stu_id, stu_name FROM asd123";    //asd123是表名，stu_id, stu_name是列名
  		ResultSet rs = sta.executeQuery(sql);
  		System.out.println("rs: " + rs.toString());
  		while (rs.next()) {
  			int id = rs.getInt("stu_id");
   			String name = rs.getString("stu_name");
   			System.out.print("ID: " + id + "    ");
   			System.out.println("name: " + name);
   		}
  		sta.close();
  		con.close();
  		rs.close();
 	}
}