*all.java
package kaohe1;
public class all {
String name;
String sex;
String c;
String java;
String sjjg;
String sum;
String date;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getC() {
return c;
}
public void setC(String c) {
this.c = c;
}
public String getJava() {
return java;
}
public void setJava(String java) {
this.java = java;
}
public String getSjjg() {
return sjjg;
}
public void setSjjg(String sjjg) {
this.sjjg = sjjg;
}
public String getSum() {
return sum;
}
public void setSum(String sum) {
this.sum = sum;
}
public String getDate() {
return date;
}
public void setDate(String date) {
this.date = date;
}
}
*grade.java
package kaohe1;
import java.util.Date;
public class grade {
String no;
String subject;
String grade;
String date;
public String getNo() {
return no;
}
public void setNo(String no) {
this.no = no;
}
public String getSubject() {
return subject;
}
public void setSubject(String subject) {
this.subject = subject;
}
public String getGrade() {
return grade;
}
public void setGrade(String grade) {
this.grade = grade;
}
public String getDate() {
return date;
}
public void setDate(String date) {
this.date = date;
}
public static void main(String[] args) {
// TODO Auto-generated method stub
}
}
*JDBC.java
package kaohe1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Statement;
public class JDBC {
public Connection getConnection(){
Connection conn = null;
String driver="com.mysql.jdbc.Driver";
String user="root";
String password="zjd123456";
String url="jdbc:mysql://localhost:3306/2233?characterEncoding=utf8";
try {
Class.forName(driver);
conn = DriverManager.getConnection(url,user,password);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
//插入student表
public boolean insertStu(String no,String name,String sex){
boolean flag = false;
Connection conn = this.getConnection();
Statement stmt;
PreparedStatement ps =null;
String sql = "insert into student (no,name,sex) values(?,?,?)";
try {
ps = conn.prepareStatement(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//给?传值
try {
ps.setString(1,no);
ps.setString(2,name);
ps.setString(3,sex);
//4.执行sql语句
int count = ps.executeUpdate();
System.out.println(count);
if (count == 1) {
flag = true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
//输入grade表
public boolean insertGra(String no,String subjects,String grade,String date){
boolean flag = false;
Connection conn = this.getConnection();
Statement stmt;
PreparedStatement ps =null;
System.out.println(date);
String sql = "insert into grade (no,subjects,grade,date) values(?,?,?,?)";
try {
ps = conn.prepareStatement(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//给?传值
try {
ps.setString(1,no);
ps.setString(2,subjects);
ps.setString(3,grade);
ps.setString(4,date);
//4.执行sql语句
int count = ps.executeUpdate();
System.out.println(count);
if (count == 1) {
flag = true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
public ResultSet findTableValue(String selectSql){
Connection conn = this.getConnection();
Statement stmt;
ResultSet rs=null;
try {
stmt = (Statement) conn.createStatement();
// System.out.println("22222");
rs = stmt.executeQuery(selectSql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// System.out.println(rs);
return rs;
}
}
*main1.java
package kaohe1;
import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import com.mysql.jdbc.RowDataCursor;
public class main1 {
public static void main(String[] args) throws IOException {
HashMap<Integer,student> map = new HashMap<>();
HashMap<Integer,grade> map2 = new HashMap<>();
HashMap<Integer, all> allMap = new HashMap<>();
List rsList = new ArrayList<>();
//调用读取sheet1,sheet2的方法
readSheet1 readSheet1 = new readSheet1();
map = readSheet1.readSheet1();
map2 = readSheet1.readSheet2();
System.out.println();
//写入sheet1,sheet2
writeSheet1 writeSheet1 = new writeSheet1();
writeSheet1.writeSheet1(map);
writeSheet1.writeSheet2(map2);
//查询数据
allMap = writeSheet1.select();
System.out.println(allMap);
//写入txt
txtWrite txtw = new txtWrite();
txtw.txtWrite(allMap);
}
}