数据库连接及基本操作

[转]常用数据库连接

https://www.cnblogs.com/littlepage/p/11829628.html

示例

mySql：

Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/eesy","root","root");
PreparedStatement ps=conn.prepareStatement("select * from account");
ResultSet rs=ps.executeQuery();
while(rs.next()){
System.out.println(rs.getString("name"));
}
rs.close();
ps.close();
conn.close();