感觉自己忘了JDBC的基本操作流程,今天就记录下来吧,时常复习
package jdbcDemo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class JdbcText {
public static void main(String[] args) {
String sql = "select * from user";
String url = "jdbc:mysql://localhost:3306/oa?useUnicode=true&characterEncoding=UTF-8";
String user = "root";
String password = "root";
String drive = "com.mysql.jdbc.Driver";
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
try {
//加载mysql驱动程序
Class.forName(drive);
//获取链接
connection = DriverManager.getConnection(url,user,password);
//创建Statement
statement = connection.createStatement();
//执行查询
resultSet = statement.executeQuery(sql);
//获取数据
while(resultSet.next()) {
System.out.println(resultSet.getString("username"));
}
} catch (Exception e) {
}finally {
//关闭资源
try {
resultSet.close();
statement.close();
connection.close();
} catch (Exception e2) {
}
}
}
}