前言
嘿嘿,愉快的码砖过程来了,今天打算和大家分享一下怎样实现增删改查以及前段时间学习时用到的通用分页,想知道怎么实现吗?那我就来告诉你!
核心思路:
增删改查呢,用到了之前学过的三层架构,使用了三层架构,能够明确分工,因为三层架构之间互不干扰,各司其职。
1、首先第一步:在你的数据库表中创建好你需要的表格以及添加好数据(我这里呢,用的是t_solr_job表格,数据是我自己添加好的);
2、当你弄好了数据库表中的数据之后,可打开你的eclipse新建一个项目(记得是Dynamic Web Project),千万注意的一点就是在你新建项目前,一定要先看一下你的Tomcat服务有没有配置好!
切记:一定要记得导入你需要使用到的jar包:
(因为我用的是sqlserver数据库,所以需要导入sqljdbc的jar)
3、然后在项目的src中新建好你需要使用的包,就像我下面展示的这样:
4、写实体类和l辅助类,我这里以com.entity包中的Job类和com.util包中 DBHelper类为例:
首先是Job类
/**
*
* @author 小汪同学 2020年5月20日 下午4:12:44
*
*/
public class Job implements Serializable{
private static final long serialVersionUID = 1L;
private String id;
private String job;
private String company;
private String address;
private String salary;
private String url;
private String limit;
private String time;
private String descs;
private String jobhandle;
private String addresshandle;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getJob() {
return job;
}
public void setJob(String job) {
this.job = job;
}
public String getCompany() {
return company;
}
public void setCompany(String company) {
this.company = company;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getSalary() {
return salary;
}
public void setSalary(String salary) {
this.salary = salary;
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
public String getLimit() {
return limit;
}
public void setLimit(String limit) {
this.limit = limit;
}
public String getTime() {
return time;
}
public void setTime(String time) {
this.time = time;
}
public String getdescs() {
return descs;
}
public void setdescs(String descs) {
this.descs = descs;
}
public String getJobhandle() {
return jobhandle;
}
public void setJobhandle(String jobhandle) {
this.jobhandle = jobhandle;
}
public String getAddresshandle() {
return addresshandle;
}
public void setAddresshandle(String addresshandle) {
this.addresshandle = addresshandle;
}
public static long getSerialversionuid() {
return serialVersionUID;
}
public Job() {
super();
}
public Job(String id, String job, String company, String address, String salary) {
super();
this.id = id;
this.job = job;
this.company = company;
this.address = address;
this.salary = salary;
}
public Job(String id, String job, String company, String address, String salary, String time) {
super();
this.id = id;
this.job = job;
this.company = company;
this.address = address;
this.salary = salary;
this.time = time;
}
public Job(String id, String job, String company, String address, String salary, String limit, String time) {
super();
this.id = id;
this.job = job;
this.company = company;
this.address = address;
this.salary = salary;
this.limit = limit;
this.time = time;
}
public Job(String job, String company, String address, String salary, String url, String limit, String time,
String descs, String jobhandle, String addresshandle) {
super();
this.job = job;
this.company = company;
this.address = address;
this.salary = salary;
this.url = url;
this.limit = limit;
this.time = time;
this.descs = descs;
this.jobhandle = jobhandle;
this.addresshandle = addresshandle;
}
public Job(String id, String job, String company, String address, String salary, String url, String limit, String time,
String descs, String jobhandle, String addresshandle) {
super();
this.id = id;
this.job = job;
this.company = company;
this.address = address;
this.salary = salary;
this.url = url;
this.limit = limit;
this.time = time;
this.descs = descs;
this.jobhandle = jobhandle;
this.addresshandle = addresshandle;
}
@Override
public String toString() {
return "Job [id=" + id + ", job=" + job + ", company=" + company + ", address=" + address + ", salary=" + salary
+ ", url=" + url + ", limit=" + limit + ", time=" + time + ", descs=" + descs + ", jobhandle=" + jobhandle
+ ", addresshandle=" + addresshandle + "]";
}
}
然后是DBHelper类:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import com.microsoft.sqlserver.jdbc.SQLServerDriver;
/**
*
* @author 小汪同学 2020年5月20日 下午4:13:30
*
*/
public class DBHelper {
//SQLServerDriver
private static final String url="jdbc:sqlserver://localhost:1433;DatabaseName=DB_T243";
private static final String cname="com.microsoft.sqlserver.jdbc.SQLServerDriver";
/**
* 加载驱动
*/
static {
try {
Class.forName(cname);
}catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
/**
* 创建连接
* @return con
*/
public static Connection getcon() {
Connection con=null;
try {
con=DriverManager.getConnection(url,"sa","123");
}catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return con;
}
/**
* 关闭连接
* @pa