dealresult.java

排课系统,系统根据学校的需要

package mainpacket;

import static mainpacket.JDBCConnectionFactory.*;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.beans.Statement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTable;

public class DealResult implements ActionListener{
	private Connection conn = getConnection();
	private JTable jta;
	private PreparedStatement pstmt ;
	
	public DealResult(JTable jta){
		this.jta=jta;
	}

	public void actionPerformed(ActionEvent e) {
		int begin=jta.getSelectedRow();
		int i=jta.getSelectedRowCount();
		
		String s = e.getActionCommand();
		if(s.equals("鎵撳嵃")){
			
		}
		if(s.equals("鍒犻櫎")){
			java.sql.Statement stmt = null;
			ResultSet rs = null;
			try {
				stmt=conn.createStatement();
				rs=stmt.executeQuery("delete from result1_wdf");
				for(int m=0;m<6;m++)
					for(int n=1;n<6;n++){
						jta.setValueAt(null,m,n);
					}
			} catch (SQLException e1) {
				e1.printStackTrace();
			}finally{
				try{
					if(rs!=null)
						rs.close();
					if(stmt!=null)
						stmt.close();
					
				}catch(Exception ee){}
			}
			
		}	
	}	
}