项目结构
connectionuitl.java主要是用于获取与数据库的连接connection
package JDBCTest.uitl;
import java.sql.Connection;
import java.sql.DriverManager;
public class ConnectionUitl {
static Connection connection=null;
static String user="root";
static String url="jdbc:mysql://127.0.0.1:3306/miduoduo?useUnicode=true&characterEncoding=utf-8";
static String password="123456";
public static Connection getConnection() {
try {
Class.forName("com.mysql.jdbc.Driver");
connection=DriverManager.getConnection(url, user, password);
} catch (Exception e) {
//编译异常
e.printStackTrace();
}
return connection;
}
}
Comment.java是与数据库的表成一个对应关系一张表对应一个实体类
package JDBCTest.model;
public class Comment {
private Integer id;
private Integer commodityId;
private String comment;
private String name;
private String commentTime;
public Comment(Integer id, Integer commodityId, String comment, String name, String commentTime) {
this.id = id;
this.commodityId = commodityId;
this.comment = comment;
this.name = name;
this.commentTime = commentTime;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public Integer getCommodityId() {
return commodityId;
}
public void setCommodityId(Integer commodityId) {
t