这段时间主要在复习巩固一下Java的基础知识,使用开源框架很久JDBC操作都忘得差不多了,在这里重新写一下JDBC的实现
mport java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
public class JdbcUtil {
private static String username="root";
private static String password="XXXXXXX";
private static String url="jdbc:mysql://localhost:3306/XXXx";
private static String driver="com.mysql.jdbc.Driver";
private static Connection conn=null;
private static PreparedStatement ps=null;
private static ResultSet rs=null;
private static Connection getConnection(){
if(conn!=null)
return conn;
try {
Class.forName(driver);
Connection connection= DriverManager.getConnection(url,username,password);
return conn;
}catch (ClassNotFoundException| SQLException e){
e.printStackTrace();