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

import java.awt.*; 
import java.awt.event.*; 
import javax.swing.*; 
import javax.swing.event.*; 
import java.util.*; 
import java.sql.*; 
 
 
public class StudentHW extends JDialog implements ActionListener,ItemListener{ 
	JButton b1=new JButton("确定"); 
	JButton b2=new JButton("返回"); 
	TextArea ta1=new TextArea(500,200); 
	TextArea ta2=new TextArea(500,200); 
	TextArea ta3=new TextArea(500,200); 
	JComboBox cb1=new JComboBox(); 
	JTextField tf=new JTextField(10); 
	////////////// 
	JLabel l1=new JLabel("学生信息"); 
	JLabel l2=new JLabel("选择阶段"); 
	JLabel l3=new JLabel("请给分数"); 
	JLabel l4=new JLabel("评语"); 
	JPanel contentPane=new JPanel(); 
	///////// 
	String sql;  
    Connection conn;  
    Statement stmt;  
    ResultSet rs; 
     
    String IDtem; 
    StudentHW(String ID){ 
    	contentPane=(JPanel)this.getContentPane(); 
		contentPane.setBackground(Color.white); 
		contentPane.setLayout(null); 
		contentPane.add(b1);contentPane.add(b2); 
		contentPane.add(ta1); 
		contentPane.add(ta3); 
		contentPane.add(ta2); 
		contentPane.add(tf); 
		contentPane.add(cb1); 
		contentPane.add(l1); 
		contentPane.add(l2); 
		contentPane.add(l3); 
		contentPane.add(l4); 
		 
		///////////// 
		l1.setBounds(50, 20, 100, 30); 
		ta1.setBounds( 20,50  , 500 , 150 ); 
		l2.setBounds( 20, 210 , 100 , 30 ); 
		cb1.setBounds( 120, 210 , 100 ,30  ); 
		ta2.setBounds( 20, 240 , 500 , 200 ); 
		l3.setBounds( 20, 450 , 100 , 30 ); 
		tf.setBounds( 120,450  ,100  ,30  ); 
		l4.setBounds(20, 480, 100, 30); 
		ta3.setBounds( 20,510 ,500  ,100  ); 
		b1.setBounds( 100, 650 , 100 , 30 ); 
		b2.setBounds( 300, 650 , 100 ,30  ); 
		 
		 
		////// 
		ta1.setEditable(false); 
		cb1.addItem("一");cb1.addItem("二");cb1.addItem("三"); 
		cb1.addItem("四");cb1.addItem("五"); 
		 
		//// 
		this.setSize(500, 750); 
		setVisible(true); 
		setModal(true); 
		setTitle("查看与评改作业"); 
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); 
		Dimension screen=Toolkit.getDefaultToolkit().getScreenSize(); 
		setLocation((screen.width-200)/2,(screen.height-750)/2); 
		IDtem=ID; 
		init(); 
		 
		///////// 
		b1.addActionListener(this); 
		b2.addActionListener(this); 
		cb1.addItemListener(this); 
		 
		 
    	 
    	 
    } 
	 
	public void init(){ 
		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 Student.*,HomeWork.TOPIC from Student,HomeWork where Student.SNO=HomeWork.SNO AND Student.SNO='"+IDtem+"'"; 
			rs=stmt.executeQuery(sql); 
			rs.next(); 
			String s[]=new String[7]; 
			s[1]="学号："+rs.getString(1); 
			s[0]="姓名："+rs.getString(2); 
			s[2]="生日："+rs.getString(4).substring(0, 11); 
			s[3]="EMAIL："+rs.getString(5); 
			s[4]="PHONE："+rs.getString(6); 
			s[6]="个人简介："+rs.getString(7); 
			s[5]="已选话题："+rs.getString(8); 
			for(int i=0;i<=6;i++){ 
				ta1.append(s[i]+"\r\n"); 
			} 
			rs.close(); 
			stmt.close(); 
			conn.close(); 
			conn= DriverManager.getConnection(url,user,password); 
			stmt=conn.createStatement();  
			sql="select * from HomeWork where SNO='"+IDtem+"'"; 
		    rs=stmt.executeQuery(sql); 
		    rs.next(); 
		    ta2.setText(rs.getString(3)); 
		    tf.setText(rs.getString(4)); 
		    ta3.setText(rs.getString(5)); 
			rs.close(); 
			stmt.close(); 
			conn.close(); 
		}catch(Exception e){JOptionPane.showMessageDialog(null, e.getMessage());} 
		 
	} 
	 
	public void itemStateChanged(ItemEvent i){ 
		int index=cb1.getSelectedIndex(); 
		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(); 
		    ta2.setText(rs.getString(3+index*3)); 
		    tf.setText(rs.getString(4+index*3)); 
		    ta3.setText(rs.getString(5+index*3)); 
			rs.close(); 
			stmt.close(); 
			conn.close(); 
		}catch(Exception e){JOptionPane.showMessageDialog(null, e.getMessage());} 
		 
		 
	} 
 
	public void actionPerformed(ActionEvent e){ 
		if(e.getSource()==b1){ 
			String s1,s2; 
			s1=tf.getText().trim(); 
			s2=ta3.getText().trim(); 
			int index=cb1.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="update HomeWork set GRADE"+index+"='"+s1+"',OPINION"+index+"='"+s2+"' where SNO='"+IDtem+"'"; 
			    if(stmt.executeUpdate(sql)==1){JOptionPane.showMessageDialog(null, "保存成功");} 
			    else{JOptionPane.showMessageDialog(null, "保存失败");} 
 
			 
				stmt.close(); 
				conn.close(); 
			}catch(Exception e1){JOptionPane.showMessageDialog(null, e1.getMessage());} 
 
		} 
		if(e.getSource()==b2){ 
			dispose(); 
		} 
	} 
}