packagecn.gtmc.schedule.app;importcn.gtmc.schedule.domain.Employee;import java.sql.*;importjava.util.ArrayList;importjava.util.List;/*** Created by Yaooo on 2019/8/12.*/
public classScheduleApp {publicConnection getCon() {//数据库连接名称
String username="root";//数据库连接密码
String password="root";
String driver="com.mysql.jdbc.Driver";//其中test为数据库名称
String url="jdbc:mysql://node1:3306/test";
Connection conn=null;try{
Class.forName(driver);
conn=(Connection) DriverManager.getConnection(url,username,password);
}catch(Exception e){
e.printStackTrace();
}returnconn;
}public voidaddData(Employee employee){
String sql="insert into copyEmployee (id, name, email, gender) values(?, ?, ?, ?)";
java.sql.PreparedStatement ptmt= null;try{
ptmt=getCon().prepareStatement(sql);
ptmt.setString(1, employee.getId());
ptmt.setString(2, employee.getLastName());
ptmt.setString(3, employee.getEmail());
ptmt.setString(4, employee.getGender());
ptmt.execute();//执行给定的SQL语句,该语句可能返回多个结果
} catch(SQLException e) {
e.printStackTrace();
}
}public ListgetSelect() {
String sql= "select * from employee";
Connection conn=getCon();
PreparedStatement pst= null;//定义一个list用于接受数据库查询到的内容
List list = new ArrayList();try{
pst=(PreparedStatement) conn.prepareStatement(sql);
ResultSet rs=pst.executeQuery();while(rs.next()) {
Employee employee= newEmployee();//将查询出的内容添加到list中
String id = rs.getString("id");
String lastName= rs.getString("name");
String email= rs.getString("email");
String gender= rs.getString("gender");
employee.setLastName(lastName.substring(2,4)); //这边做字段处理
employee.setId(id);
employee.setEmail(email);
employee.setGender(gender);
addData(employee);
}
}catch(Exception e) {
}returnlist;
}public static voidmain(String[] args){
ScheduleApp app= newScheduleApp();
List list =app.getSelect();for (int i = 0; i < list.size(); i++) {
System.out.println(list.get(i));
}
}
}