java mysql 数据插入一张表_java实现mysql数据库从一张表插入数据到另一张表

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));

}

}

}