数据库连接方法一

package dao;
import java.sql.*;


public class Demo1 {
final static String URL = "jdbc:mysql://localhost:3306/forStudy";
final static String USER = "root";
final static String PASSWORD = "";
public static void main(String[] args) {
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
//String sql = "INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS) VALUES (6,'李丹', '女','河南南阳');";
String sql = "SELECT * FROM STUDENT WHERE ID >= 3";
try {
//1.加载数据库驱动程序
Class.forName("com.mysql.jdbc.Driver");
//2.建立连接（Java程序和数据库之间的连接）
con = DriverManager.getConnection(URL, USER, PASSWORD);
//3.向数据库发送SQL语句
stmt = con.createStatement();
//数据库查询
rs = stmt.executeQuery(sql);
int id;
String name, sex, address;
while(rs.next()){
id = rs.getInt("ID");
name = rs.getString("NAME");
sex = rs.getString("sex");
address = rs.getString("address");

System.out.println("id = " + id + ", name = "
+ name + ", sex = " + sex 
+ ", address" + address) ;
}

System.out.println("数据库操作完毕");

} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally{
//4.数据库操作完毕之后需要关闭相关连接
if(con != null){
try {
con.close();
con = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
if(stmt != null){
try {
stmt.close();
stmt = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
if(rs != null){
try {
rs.close();
rs = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}



}


}