sumithomework.java

使用java连接server sql 2000 的一个小作业

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_y<y){b=true;}
				if(today_y>y){b=false;}
				if(today_y==y){
					if(today_m<m){b=true;}
					if(today_m>m){b=false;}
					if(today_m==m){
						if(today_d<d){b=true;}
						if(today_d>d){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());}
			
		}
	}
}