tablestudentstatueconcert.java

一个可以存储和打印成绩单的系统

package org.wuhang.cjsjk.OldDbToNewDb;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.HashMap;

public class TableStudentStatueConcert {
	static HashMap<Integer,Integer> id_num = new HashMap<Integer,Integer>();
	public static HashMap<Integer,Integer> getID_Num(){
		return id_num;
	}
	public static void studentstatue_concert(Connection new_con) {
		try {
			id_num.put(1, 1);
			id_num.put(2, 2);
			PreparedStatement statement = new_con
						.prepareStatement("insert into studentstatue (name) values(?)");
			statement.setString(1,"毕业");
			statement.execute();
			statement.setString(1, "没毕业");
			statement.execute();
			statement.close();
		} catch (Exception e) {
			System.out.println("some error");
			System.out.println(e.getMessage());
       } 
	}
}