www.pudn.com > st.rar > SumitHomeWork.java

import java.awt.*; 
import java.awt.event.*; 
 
import javax.swing.*; 
import java.util.*; 
import java.sql.*; 
import java.util.Date; 
 
public class SumitHomeWork extends JPanel implements ActionListener,ItemListener{ 
	JComboBox cb1=new JComboBox(); 
	JComboBox cb2=new JComboBox(); 
	TextArea ta=new TextArea("",400,400,10); 
	JButton b1=new JButton("提交"); 
	  
	Calendar gc=new GregorianCalendar(); 
	///// 
	String sql;  
    Connection conn;  
    Statement stmt;  
    ResultSet rs; 
    ////// 
    String IDtem=new String(); 
 
	 
	 
	SumitHomeWork(String ID){ 
		IDtem=ID; 
		JLabel l1=new JLabel("选择话题 "); 
		JLabel l2=new JLabel("选择阶段 "); 
		String num[]={"first","second","third","fouth","fifth"}; 
		int i; 
		for(i=0;i<3;i++){ 
			cb1.addItem(num[i]); 
		} 
		 
		for(i=0;i<5;i++){ 
			cb2.addItem(num[i]); 
		} 
	 
		try{ 
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
			String url="jdbc:odbc:SUMMIT";  
			String user="sa";  
			String password="198662";  
			conn= DriverManager.getConnection(url,user,password); 
			stmt=conn.createStatement();  
			sql="select * from HomeWork where SNO='"+IDtem+"'"; 
			rs=stmt.executeQuery(sql); 
			rs.next(); 
			String hw1=new String(); 
			hw1=rs.getString(3); 
			ta.setText(""); 
			ta.setText(hw1);				 
			conn.close(); 
			//rs.close(); 
			stmt.close();		 
	   }catch(Exception e3){JOptionPane.showMessageDialog(null,e3.getMessage());} 
	     
	   setLayout(null);this.setBackground(Color.yellow); 
	   JLabel top=new JLabel("         提交作业         "); 
	   add(top);add(l1);add(l2); 
	   add(cb1);add(cb2);add(ta);add(b1); 
	   top.setBounds(100, 30, 400, 30); 
	   l1.setBounds(60, 100, 100, 30); 
	   cb1.setBounds(120, 100, 100, 30); 
	   l2.setBounds(250, 100, 100, 30); 
	   cb2.setBounds(310, 100, 100, 30); 
	   ta.setBounds(40, 160, 400, 400); 
	   b1.setBounds(200, 580, 100, 30); 
	   top.setFont(new Font("Times",Font.CENTER_BASELINE,30)); 
	    
	   b1.addActionListener(this); 
	   cb2.addItemListener(this); 
	 
		 
	} 
	public void itemStateChanged(ItemEvent i){ 
		if(i.getSource()==cb2){ 
		  
			int k=cb2.getSelectedIndex()+1; 
			try{ 
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
				String url="jdbc:odbc:SUMMIT";  
				String user="sa";  
				String password="198662";  
				conn= DriverManager.getConnection(url,user,password); 
				stmt=conn.createStatement();  
				sql="select * from HomeWork where SNO='"+IDtem+"'"; 
				 
				 
				rs=stmt.executeQuery(sql); 
				rs.next(); 
				 
				ta.setText(""); 
				ta.setText(rs.getString(3*k)); 
				stmt.close(); 
				conn.close(); 
				 
			}catch(Exception e){JOptionPane.showMessageDialog(null, e.getMessage());} 
		} 
	} 
	public void actionPerformed(ActionEvent e){ 
		if(e.getSource()==b1){ 
			String s1=cb1.getSelectedItem().toString().trim(); 
			String s2=cb2.getSelectedItem().toString().trim(); 
	       int j=cb1.getSelectedIndex()+1;//话题 
			int k=cb2.getSelectedIndex()+1;//阶段 
		 
			int today_y=gc.get(Calendar.YEAR); 
			int today_m=gc.get(Calendar.MONTH)+1; 
			int today_d=gc.get(Calendar.DATE); 
		 
			//System.out.println(j); 
			//System.out.println(k); 
			 
			 
		 
			try{ 
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
				String url="jdbc:odbc:SUMMIT";  
				String user="sa";  
				String password="198662";  
				conn= DriverManager.getConnection(url,user,password); 
				stmt=conn.createStatement();  
				 
				sql="select * from Teacher"; 
				rs=stmt.executeQuery(sql); 
				rs.next(); 
				String tem=rs.getString(k+6).trim(); 
				 
				int y=Integer.parseInt(tem.substring(0, 4)); 
				int m=Integer.parseInt(tem.substring(5, 7)); 
				int d=Integer.parseInt(tem.substring(8, 10)); 
				boolean b=true; 
				if(today_yy){b=false;} 
				if(today_y==y){ 
					if(today_mm){b=false;} 
					if(today_m==m){ 
						if(today_dd){b=false;} 
						if(today_d==d){b=true;} 
						 
					} 
				} 
				if(b==false){ 
					JOptionPane.showMessageDialog(null, "超期"); 
					return; 
				} 
				else{ 
				sql="update HomeWork set TOPIC='"+j+"'"+",HW"+k+"='"+ta.getText().toString().trim()+"' where SNO='"+IDtem+"'"; 
				//System.out.println(sql); 
				int ok=stmt.executeUpdate(sql); 
				if(ok==1){JOptionPane.showMessageDialog(null, "提交成功");} 
				else{JOptionPane.showMessageDialog(null, "提交失败");} 
				 
								 
				conn.close(); 
			 
				stmt.close();		 
		   } 
			}catch(Exception e3){JOptionPane.showMessageDialog(null,e3.getMessage());} 
			 
		} 
	} 
}