package db;
import java.sql.*;
public class DBUtil {
private static final String URL="jdbc:mysql://localhost:3306/jdbc_learn?useUnicode=true&characterEncoding=utf-8";
private static final String USER="root";
private static final String PASSWORD="roottest";
private static Connection conn=null;
static {
try {
// 加载驱动程序
Class.forName("com.mysql.jdbc.Driver");
// 获得数据库的连接
conn=DriverManager.getConnection(URL, USER, PASSWORD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static Connection getConnection(){
return conn;
}
public static void main(String[] args) throws SQLException {
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT id, user_name FROM imooc_goddess");
while (rs.next()){
System.out.println(rs.getInt("id") + rs.getString("user_name"));
}
}
}
JavaWeb基础(1)—— 使用 JDBC 连接 MySQL
最新推荐文章于 2022-11-23 22:41:16 发布