studenthw.java

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

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();
		}
	}
}