selectcourse.java

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

package mainpacket;

import static mainpacket.JDBCConnectionFactory.*;

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

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

public class Selectcourse implements ActionListener {
	private Connection conn=getConnection();
	private PreparedStatement pstmt;
	private PreparedStatement pstmt1;
	private JTextField jtf;
	private ResultSet rs;
	private ResultSet rs1;
	private JFrame jframe;
	private JTable jt;
	
	public Selectcourse(JTextField jtf,JFrame jrame,JTable jt){
		this.jtf=jtf;
		this.jframe=jframe;
		this.jt=jt;
	}
	
	public void actionPerformed(ActionEvent e) {
		String s=jtf.getText();
		System.out.println(s);
		String ss=null;
		try {
			pstmt=conn.prepareStatement("select * from result1_wdf where cname='"+s.trim()+"'");
			rs=pstmt.executeQuery();
			if(!rs.next()){
				JOptionPane jp=new JOptionPane();
				JLabel l=new JLabel();
				l.setText("鏃犳