selectdata.java

simple Ebook management software!

/**
 * 
 */
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
/**
 * @author Linden
 * @date 下午09:11:192007-10-20
 */
class SelectData extends JFrame implements ActionListener {
	JButton bu1;
	JTextArea ta1;
	public SelectData(){
		super("查询书目");
		Container c=getContentPane();
		c.setLayout(null);
		bu1=new JButton("读取所有书目");
		bu1.setSize(150,20);
		bu1.setLocation(160, 20);
		bu1.addActionListener(this);
		c.add(bu1);
		ta1=new JTextArea();
		ta1.setSize(420,280);
		ta1.setLocation(20, 50);
		c.add(ta1);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setSize(500,400);
		setVisible(true);
	}
	public void actionPerformed(ActionEvent e){
		String str="";
		try{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		}catch(ClassNotFoundException e1){
			System.out.println("没能发现驱动程序!");
		}
		try{
			String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=EBook";
			String user="sa"; //sqlserver 连接
			String password="123456";
			Connection con1= DriverManager.getConnection(url,user,password);
			Statement st1=con1.createStatement();
			ResultSet rs1=st1.executeQuery("select * from EBook");
			while(rs1.next()){
				str=str+rs1.getInt(1)+"\t"+rs1.getString(2)+"\t"+rs1.getString(3)+"\t"+rs1.getFloat(4)+"\n";	
			}
			rs1.close();
			con1.close();
			ta1.setText(str);
			JOptionPane.showMessageDialog(null, "数据库查询成功！");
		}catch(SQLException e2){
			System.out.println("没能发现数据库!");
		}
	}
	
}