1.JavaBean属性的传递
package com.employee;
public class EmployeeBean {
public EmployeeBean(){}
private Integer depId;
private String depname;
private String depaddr;
public Integer getDepId() {
return depId;
}
public void setDepId(Integer depId) {
this.depId = depId;
}
public String getDepname() {
return depname;
}
public void setDepname(String depname) {
this.depname = depname;
}
public String getDepaddr() {
return depaddr;
}
public void setDepaddr(String depaddr) {
this.depaddr = depaddr;
}
}
2.逻辑(从数据库中读取数据)
package com.employee;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
public class EmployeeDao {
public static Connection getConnection(){
Connection conn = null;
try{
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/flexspc";
String username = "root";
String userpassword = "AstroSky";
Class.forName(driver);
conn = DriverManager.getConnection(url, username, userpassword);
}catch(Exception e){
e.printStackTrace();
}
return conn;
}
public List getAllList(){
List list = null;
String sql = "select * from spc_employee";
EmployeeBean bean;
try{