dele.java

创建一个数据库dbstu,其中包括下列表： １.student(学号

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
class Dele extends JFrame implements ActionListener{
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dbstu";
        Connection con;
        Statement stmt;



	JTextField t1=new JTextField(15);
//	JTextField t2=new JTextField(5);
//	JTextField t3=new JTextField(5);
	JLabel l1=new JLabel("输入学生学号:");
	JButton btn=new JButton("删除");JButton aa=new JButton("退出");
public Dele(){
	Container con=getContentPane();
		con.setLayout(new GridLayout(2,1));
	JPanel p1=new JPanel();
	p1.add(l1);p1.add(t1);
	JPanel p2=new JPanel();
	p2.add(btn);p2.add(aa);
	btn.addActionListener(this);aa.addActionListener(this);
	con.add(p1);con.add(p2);	
		setTitle("按学生学号删除指定学生");
		setSize(300,200);
		setLocation(200,200);
		setVisible(true);



	}
		public void actionPerformed(ActionEvent e){
			if(e.getSource()==aa){
				dispose();
		//	System.exit(0);
				}
			 else if(e.getSource()==btn)	
			{
				
			try {
           Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
       } catch(java.lang.ClassNotFoundException ef) {
            System.err.print("ClassNotFoundException: ");
            System.err.println(ef.getMessage());
        }

        try {	      
            con = DriverManager.getConnection(url, "sa", "");
			stmt = con.createStatement();

			
			PreparedStatement updateSales;
	
		
/**/	String updateString ="DELETE FROM student WHERE 学号=?";
			updateSales = con.prepareStatement(updateString);
				updateSales.setString(1, t1.getText());
	//	int bb=updateSales.getUpdateCount();
		updateSales.executeUpdate();
	//	System.out.println(bb);
		JOptionPane.showMessageDialog(null,"删除成功");
//该学号不存在
		/*	String updateString ="DELETE FROM student,address WHERE (student.学号=address.学号) AND (student.学号=address.学号=?)";	
		updateSales = con.prepareStatement(updateString);
				updateSales.setString(1, t1.getText());
		updateSales.executeUpdate();
		
	 updateString ="DELETE FROM stu WHERE 年龄 BETWEEN 18 AND 19";		
				updateSales = con.prepareStatement(updateString);
			updateSales.executeUpdate();
			*/
		//    student.学号=address.学号 AND 	
				
		
		} catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        } 	
				
				
				
				}
			}
			//	public static void main(String args[])
			//	{Dele xuehao=new Dele();} 
					
	}