Jdbc封装类
package com.util;
import java.sql.*;
public class Jdbc {
static {
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
String url = "jdbc:mysql://127.0.0.1:3306/myweb?serverTimezone=UTC";
String userName = "root";
String passWord = "123";
Connection conn = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
public void GetConnection(){
try {
conn = DriverManager.getConnection(url,userName,passWord);
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
public PreparedStatement prepareStatement(String sql){
try {
preparedStatement = conn.prepareStatement(sql);
} catch (SQLException throwables) {
throwables.printStackTrace();
}
return preparedStatement;
}
public void Close(){
if (resultSet!=null){
try {
resultSet.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if (preparedStatement!=null){
try {
preparedStatement.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if (conn!=null){
try {
conn.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
创建Jdbc对象查找user表内所有内容
public List<User> selectAll(){
List<User> list = new ArrayList<User>();
Jdbc jdbc = new Jdbc();
PreparedStatement preparedStatement;
ResultSet resultSet = null;
jdbc.GetConnection();
String sql = "select * from user";
preparedStatement = jdbc.prepareStatement(sql);
try {
resultSet = preparedStatement.executeQuery();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
try {
while (resultSet.next()) {
User user = new User();
user.setUserId(resultSet.getInt(1));
user.setUserName(resultSet.getString(2));
user.setSex(resultSet.getString(4));
user.setEmail(resultSet.getString(5));
list.add(user);
}
} catch (SQLException throwables) {
throwables.printStackTrace();
} finally {
jdbc.Close();
}
return list;
}