数据库连接模块
private static final String URL="jdbc:mysql://localhost:3306/mysql";
private static final String USER="root";
private static final String PASSWORD="123";
private static Connection conn=null;
static {
try {
//1.加载驱动程序
Class.forName("com.mysql.jdbc.Driver");
//2.获得数据库的连接
conn=DriverManager.getConnection(URL, USER, PASSWORD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static Connection getConnection(){
return conn;
注:3306是端口号,mysql是存放table的database, 应用时要根据实际情况来改成相应的数据库,(端口号一般情况下是默认的,不需要更改)
数据库操作模块
public String