dotcheck.java

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

package org.wuhang.transfer;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.JOptionPane;

public class DoTcheck {
	 
	 public static boolean daoTcheck_j(Connection import_con,Connection export_con){
    	 try {
     		PreparedStatement import_st = null;
  			PreparedStatement export_st = null;
  			Vector<String> checkcode = new Vector<String>();
  			Vector<Date> updatetime = new Vector<Date>();
  			Vector<String> bz = new Vector<String>();
  			String export_sql = "select * from Tcheck";
  			export_st = export_con.prepareStatement(export_sql);
  			ResultSet rs = export_st.executeQuery();
  			
  			String import_sql = "insert into Tcheck (checkcode,updatetime,bz) values (?,?,?)";
  			import_st = import_con.prepareStatement(import_sql);
  			
  			while(rs.next()){
 				checkcode.addElement(rs.getString("checkcode"));
 				updatetime.addElement(rs.getDate("updatetime"));
 				bz.addElement(rs.getString("bz"));
 				System.out.println(checkcode+" "+updatetime+" "+bz);

 			}
  			rs.close();
 			export_st.close();
 			if (checkcode.isEmpty()) {
 				JOptionPane.showMessageDialog(null, "抱歉原数据库里无数据库验证码,"
 						+ "请先添加数据库验证码!", "提示", JOptionPane.ERROR_MESSAGE);
 				return false;
 			} else {
 				import_st.setString(1, checkcode
 						.elementAt(checkcode.size() - 1));
 				import_st.setDate(2, updatetime
 						.elementAt(updatetime.size() - 1));
 				import_st.setString(3, bz.elementAt(bz.size() - 1));
 				import_st.execute();
 				import_st.close();
 				import_con.commit();
 				export_con.commit();
 				return true;
 			}
  		} catch (SQLException e) {
  			// TODO Auto-generated catch block
  			e.printStackTrace();
  			return false;
  		}
    }
	 
	 public static boolean check(Connection access_con,Connection javadb_con){
     		boolean flag = false;
		    PreparedStatement access_st = null;
			String checkcode = null;
			Date updatetime = null;
			String access_sql = "select checkcode,updatetime from Tcheck";
			try {
				access_st = access_con.prepareStatement(access_sql);
				ResultSet rs = access_st.executeQuery();
				if(rs.next()){
					checkcode = rs.getString("checkcode");
					updatetime = rs.getDate("updatetime");
				}
				rs.close();
		    	access_st.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				flag = false;
			}
			if (updatetime == null) 
				flag = false;
			String javadb_sql = "select id from Tcheck where checkcode=? and updatetime=?";
			try {
				access_st = javadb_con.prepareStatement(javadb_sql);
				access_st.setString(1, checkcode);
				access_st.setDate(2, updatetime);
				ResultSet rrss = access_st.executeQuery();
				if(rrss.next()){
					rrss.getInt("id");
					flag = true;
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				flag = false;
			}
			return flag;
		
	}
}