String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/alex_accountManage1";
String user = "root";
String password = "123456";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
// stmt.executeUpdate("insert into messages (message) values ('测试MySQL编码')");
ResultSet rs = stmt.executeQuery("select * from account");
while (rs.next()) {
int id = rs.getInt("id");
String message = rs.getString("MaterialName");
System.out.println(id + " " + message);
}
rs.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。