jdbcDay01

package com.tedu;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**

• JDBC入门程序

*/
public class jdbcDemo1 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Connection conn=null;
Statement stat=null;
ResultSet rs=null;
try {
//<-------------------------------------------------->
//1.注册数据库驱动
Class.forName(“com.mysql.jdbc.Driver”);
//2.获取数据库连接
//第一个参数表示地址第二个第三个分别表示数据库的账号密码
String url=“jdbc:mysql://localhost:3306/db”;
conn= DriverManager.getConnection(url,“root”,“root”);
//3.获取传输器
stat=conn.createStatement();
//4.利用传输器发送sql到数据库执行返回结果
String sql=“select * from account”;
rs=stat.executeQuery(sql);
//5.处理执行结果
while(rs.next()) {
//参数要与数据库列名保持一致
int id= rs.getInt(“id”);
String name=rs.getString(“name”);
double money =rs.getDouble(“money”);
System.out.println(id+" “+name+” "+money);
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
//6.释放资源
rs.close();
stat.close();
conn.close();
//<-------------------------------------------------->
}
}

}