Java连接MySQL

Java数据库连接示例

最新推荐文章于 2025-09-06 22:56:13 发布

weixin_34358092

最新推荐文章于 2025-09-06 22:56:13 发布

阅读量56

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 java

原文链接：https://my.oschina.net/csmw00/blog/674011

为什么80%的码农都做不了架构师？>>>

import java.sql.*;

public class FirstConnection {

    public static void main(String[] args) {

	try {
	    Class.forName("com.mysql.jdbc.Driver");
	} catch (ClassNotFoundException e) {

	    e.printStackTrace();
	}
	/*
         * try { new com.mysql.jdbc.Driver(); } catch (SQLException e) {
         * e.printStackTrace(); }
         */
	Connection con = null;
	Statement stmt = null;
	ResultSet rs = null;
	try {
	    con = DriverManager
		    .getConnection("jdbc:mysql://localhost/myfirstdb?user=root&password=2490248");
	    stmt = con.createStatement();
	    rs = stmt.executeQuery("select * from dept");
	    while (rs.next()) {
		System.out.println(rs.getString("did"));
		System.out.println(rs.getString("dname"));
	    }
	} catch (SQLException e) {
	    System.out.println("出错了！");
	    e.printStackTrace();
	} catch (Exception e) {
	    System.out.println("大问题！");
	    e.printStackTrace();
	} finally {
	    try {
		if (rs != null)
		    rs.close();
		if (stmt != null)
		    stmt.close();
		if (con != null)
		    con.close();
	    } catch (SQLException e) {
		e.printStackTrace();
	    }
	}

    }

}

转载于:https://my.oschina.net/csmw00/blog/674011