久违的jdbc样板代码

最新推荐文章于 2025-03-08 17:26:06 发布

最新推荐文章于 2025-03-08 17:26:06 发布 · 150 阅读

文章标签：

#JDBC #MySQL

java学习专栏收录该内容

25 篇文章

订阅专栏

本文展示了一个使用 Java 访问 MySQL 数据库的基本示例，包括建立连接、执行 SQL 查询并获取结果集的过程。


public class DB {
	private String url = "jdbc:mysql://localhost:3306/test";

	private String user = "root";
	private String pwd = "yanshaozhi";

	public Connection getcon() throws InstantiationException,
			IllegalAccessException, ClassNotFoundException, SQLException {
		Connection con;
		Class.forName("org.gjt.mm.mysql.Driver").newInstance();
		con = DriverManager.getConnection(url, user, pwd);
		return con;
	}

	public ResultSet executeSql(String sqlstr) throws InstantiationException,
			IllegalAccessException, ClassNotFoundException, SQLException {
		Connection conn;
		Statement stmt;

		conn = getcon();
		stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery(sqlstr);

		return rs;
	}

	public static void main(String[] args) throws InstantiationException,
			IllegalAccessException, ClassNotFoundException, SQLException {
		DB mysql11 = new DB();
		ResultSet rs;
		rs = mysql11.executeSql("select * from user");
		try {
			while (rs.next()) {
				System.out.println(rs.getString("username"));
			}
		} catch (Exception e) {
			System.out.println(e.getMessage());
		}
	}
}