jsp mysql 增删改_jsp连接mysql的增删改操作

create database addressdb;

use addressdb;

create table addressList(

id int primary key,

name varchar(20),

phone varchar(20),

address varchar(100),

email varchar(40)

);

//AddressBean.java

package beans;

public class AddressBean {

private int id;

private String name;

private String phone;

private String address;

private String email;

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getPhone() {

return phone;

}

public void setPhone(String phone) {

this.phone = phone;

}

public String getAddress() {

return address;

}

public void setAddress(String address) {

this.address = address;

}

public String getEmail() {

return email;

}

public void setEmail(String email) {

this.email = email;

}

}

//AddressDemo.java

package beans;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.Collection;

public class AddressDemo extends ConnBean {

private Connection connection = null;

public void closePstmt(PreparedStatement pstmt) {

try {

if (connection != null)

connection.close();

connection = null;

} catch (SQLException e3) {

e3.printStackTrace();

}

}

public AddressBean[] getAllRecords() {

ResultSet rs = null;

PreparedStatement pstmt = null;

Collection list = new ArrayList();

try {

connection = getConnectio