queryint.java

j2ee关于BEANS的多个例子

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

public class QueryInt extends JPanel
{
	private JLabel labTitle,labStat,labRes,labEmp;
	private JTextField txtStat;
	private java.awt.List lstRes;
	GridBagLayout gbl;
	GridBagConstraints gbc;
	
	private String dsn="MyDatabase";

	public  QueryInt()
	{
		vec=new Vector(1,1);
		Font font;
		gbl=new GridBagLayout();
		gbc=new GridBagConstraints();
		setLayout(gbl);
		labTitle=new JLabel("SQL Query Interface");
		labStat=new JLabel("Enter the SQL statement:");
		labRes=new JLabel("Result:");
		labEmp=new JLabel("");
		txtStat=new JTextField(30);
		lstRes=new java.awt.List();
		
		gbc.anchor=gbc.WEST;
		gbc.gridx=1;
		gbc.gridy=0;
		font=new Font("楷体",Font.BOLD,30);
		labTitle.setFont(font);
		gbl.setConstraints(labTitle,gbc);
		add(labTitle);
		
		gbc.anchor=gbc.NORTHWEST;
		gbc.gridx=0;
		gbc.gridy=1;
		gbl.setConstraints(labStat,gbc);
		add(labStat);
		
		gbc.anchor=gbc.NORTHWEST;
		gbc.gridx=1;
		gbc.gridy=1;
		gbl.setConstraints(txtStat,gbc);
		add(txtStat);
		
		gbc.anchor=gbc.NORTHWEST;
		gbc.gridx=0;
		gbc.gridy=2;
		gbl.setConstraints(labRes,gbc);
		add(labRes);
		
		gbc.anchor=gbc.NORTHWEST;
		gbc.gridx=1;
		gbc.gridy=2;
		gbc.weightx=1.0f;
		gbc.weighty=1.0f;
		gbl.setConstraints(lstRes,gbc);
		add(lstRes);
		
	}
	
	public void setDsn(String dsn)
	{
		this.dsn=dsn;
	}
	public String getDsn()
	{
		return dsn;
	}
	
	public void executeQurey()
	{
		try
		{
		
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=DriverManager.getConnection("jdbc:odbc:" + dsn,"faculty","");
			Statement stat=con.createStatement();
			ResultSet rs=stat.executeQuery((txtStat.getText()).trim());
			int i;
			ResultSetMetaData rsmd=rs.getMetaData();
			int colCount=rsmd.getColumnCount();
			String tempString="";
			for (i=1;i<=colCount;i++)
			{
				tempString=tempString + rsmd.getColumnName(i).trim() + ":";
			}
			lstRes.add(tempString);
			tempString="-------------------------------------------------------------------------------------";
			lstRes.add(tempString);
			tempString="";
			while(rs.next())
			{
				for (i=1;i<=colCount;i++)
				{
					tempString=tempString + rs.getString(i)
					+ ":";
				}
				lstRes.add(tempString);
				tempString="";
			}
			tempString="-------------------------------------------------------------------------------------";
			lstRes.add(tempString);
		}
		catch(Exception e)
		{
			System.out.println(e);
		}
	}
}