java-用main方法连接数据库测试
main{try {Connection con = null;Class.forName("com.mysql.jdbc.Driver").newInstance();// mysql驱动con = (Connection) DriverManager.getConnection("jdbc:p6spy:mysql://xxx/xx", user, name);S
·
main{
try {
Connection con = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
// mysql驱动
con = (Connection) DriverManager.getConnection("jdbc:p6spy:mysql://xxx/xx",
user, name);
Statement ps = (Statement) con.createStatement();
String sql = "select * from xx";
ResultSet rs = ps.executeQuery(sql);
while (rs.next()) {
// 循环输出结果集
String account = rs.getString("account");
System.out.println("account:" + account);
}
} catch (Exception e) {
System.out.println("MYSQL error" + e.getMessage());
}
try {
Connection con = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
// mysql驱动
con = (Connection) DriverManager.getConnection("jdbc:p6spy:mysql://xxx/xx",
user, name);
Statement ps = (Statement) con.createStatement();
String sql = "select * from xx";
ResultSet rs = ps.executeQuery(sql);
while (rs.next()) {
// 循环输出结果集
String account = rs.getString("account");
System.out.println("account:" + account);
}
} catch (Exception e) {
System.out.println("MYSQL error" + e.getMessage());
}
或者调用PreparedStatement子接口来进行数据库的连接
无需安装部署，在线快速体验 Byzer
更多推荐
1
0- 0
已为社区贡献1条内容
所有评论(0)