jdbc连接数据库

Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");


String url = "jdbc:mysql://127.0.0.1:3306/assetmanager";
String user = "root";
String password = "";


conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
String sql = "select * from bank";
rs = stmt.executeQuery(sql);
while (rs.next()) {
String bankId = rs.getString("bankId");
String bankName = rs.getString("bankName");
String bankTel = rs.getString("bankTel");


System.out.println(bankId + "--" + bankName + "--" + bankTel);


}


} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
stmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}