querydemo.java

来自「java课件 java课件 java课件 java课件」· Java 代码 · 共 69 行

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;


public class QueryDemo extends JFrame implements ActionListener{
	JPanel jp=new JPanel(),
	       jpBar= new JPanel();
	JTextArea jta = new JTextArea();
	JLabel jbl = new JLabel("SQL");
	JTextField jtfd = new JTextField(20);
	JButton jbtn = new JButton("Execute");
	Container contentPane=null;
	
	Connection conn=null;
	Statement stmt=null;
	ResultSet rst =null;       
	
	public QueryDemo(){
	   try{
	   	 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
         String url="jdbc:odbc:student";
         String user = "scott";
         String password = "tiger";
         conn = DriverManager.getConnection(url,"","");
         Statement stmt = null;
       }catch(Exception e){
	   	 System.out.println(e); 
	   } 	
	   contentPane = getContentPane();
	   jp.setLayout(new BorderLayout());
	   jpBar.add(jbl);
	   jpBar.add(jtfd);
	   jpBar.add(jbtn);
	   jp.add(jta,BorderLayout.CENTER);
	   jp.add(jpBar,BorderLayout.SOUTH);
	   contentPane.add(jp,BorderLayout.CENTER);
	   jtfd.setFocusable(true);
	   jtfd.addActionListener(this);
	   jbtn.addActionListener(this);
	   
	   setSize(400,300);
	   setLocation(300,200);
	   setVisible(true);
	   setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);   	
	}
	
	public void actionPerformed(ActionEvent ae){
		String sql = jtfd.getText();
		try{
		 stmt = conn.createStatement();
      rst = stmt.executeQuery(sql);
		
         jta.setText("");
         while(rst.next()){
           jta.append(rst.getString(1)+"  "+rst.getString(2)+
                         "  "+rst.getString(3)+
                         "  "+rst.getString(4)+
                         "  "+rst.getString(5)+"\n");   		
        }
       }catch(SQLException e){
       }
    }
        
	public static void main(String []args){
		new QueryDemo();
	}
}