创建jdbc基本步骤
public static void main(String[] args) throws SQLException {
Connection con=null;
//注册驱动
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
try {
//反射
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//连接数据库
try {
con = DriverManager.getConnection("jdbc:mysql:///test?characterEncoding=UTF-8", "root", "Cyp123..");
} catch (SQLException e) {
e.printStackTrace();
}
//获取操作对象
Statement statement =con.createStatement();
//编写sql
String sql ="select *from comment";
//执行sql,获取数据
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()){
System.out.println("tx_img:"+resultSet.getObject("tx_img"));
}
//释放资源
resultSet.close();
statement.close();
con.close();
}