denian.java

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

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
class Denian 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(15);
//	JTextField t3=new JTextField(5);
	JLabel l1=new JLabel("删除学生的年龄:");
	JLabel l2=new JLabel("到年龄        :");
	JButton btn=new JButton("删除");JButton aa=new JButton("退出");
public Denian(){
	Container con=getContentPane();
		con.setLayout(new GridLayout(3,1));
	JPanel p1=new JPanel();
	p1.add(l1);p1.add(t1);
	JPanel p2=new JPanel();
	p2.add(l2);p2.add(t2);
	JPanel p3=new JPanel();
	p2.add(btn);p2.add(aa);
	btn.addActionListener(this);aa.addActionListener(this);
	con.add(p1);con.add(p2);con.add(p3);	
		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 年龄 BETWEEN ? AND ?";		
				updateSales = con.prepareStatement(updateString);
				updateSales.setString(1, t1.getText());
				updateSales.setString(2, t2.getText());
			updateSales.executeUpdate();
JOptionPane.showMessageDialog(null,"删除成功");
	//删除失败
			
				
		
		} catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        } 	
				
				
				
				}
			}
			//	public static void main(String args[])
			//	{Denian xuehao=new Denian();} 
					
	}