queryframe.java

在eclipse开发环境下使用java变成语言连接SQLSERVER,读取数据

package query;

import java.awt.Container;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;

public class QueryFrame extends JFrame implements ActionListener {

    JTextField jf=new JTextField(20);
    String[] value={"姓名","部门","薪水"};
    JComboBox box=new JComboBox(value);
    JButton find= new JButton("查询");
    JPanel panel_find=new JPanel();
    JPanel panel_content=new JPanel();
    Statement stmt=null;
    public QueryFrame(){
	this.setTitle("查询系统");
	Container c=this.getContentPane();
	jf.addActionListener(this);
	find.addActionListener(this);
	panel_find.add(jf);
	panel_find.add(box);
	panel_find.add(find);
	c.add(panel_find,"North");
	c.add(panel_content,"Center");
	this.setSize(400,400);
	this.setLocation(200,100);
	try{
	    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
	    Connection conn = DriverManager
		    .getConnection(
			    "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=xdf",
			    "sa","");
	    stmt=conn.createStatement();
	}catch(Exception e){
	    e.printStackTrace();
	}
	this.setVisible(true);
    }
   

    public void actionPerformed(ActionEvent e) {
	panel_content.removeAll();
	String item=(String) box.getSelectedItem();
	if(item.equals("姓名")){
	    item="name";
	}
	if(item.equals("部门")){
	    item="department";
	}
	if(item.equals("薪水")){
	    item="salary";
	}
	String content=jf.getText();
	int i=0;
	try{
	    String sql="select * from employee";
	    if(!content.equals("")){
		sql+="where"+item+"like'%"+content+"%'";
	    }
		ResultSet rs=stmt.executeQuery(sql);
		while(rs.next()){
		    int id=rs.getInt(1);
		    String name=rs.getString(2);
		    String department=rs.getString(3);
		    int salary=rs.getInt(4);
		    JLabel label=new JLabel(id+" "+name+" "+department+" "+salary);
		    JPanel panel=new JPanel();
		    panel.add(label);
		    panel_content.add(panel);
		    i++;
	    }
	}catch(Exception e1){
	    e1.printStackTrace();
	}
	panel_content.setLayout(new GridLayout(1,1));
	panel_content.validate();
    }
    public static void main(String[] args) {
	new QueryFrame();

    }

}