loginbean.java

j2ee关于BEANS的多个例子

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

public class LoginBean extends JPanel
{
	private JLabel labLogo,lab;
	private JTextField txtPin;
	private String logo="请设置银行名";
	
	public LoginBean()
	{
		labLogo =new JLabel(logo);
		lab = new JLabel("Enter Pin Number: ");
		txtPin=new JTextField(10);
		BorderLayout bl= new BorderLayout();
		setLayout(bl);
		add("North",labLogo);
		add("West",lab);
		add("East",txtPin);
	}
	public void setLogo(String lo)
	{
		logo=lo;
		labLogo.setText(lo);
	}
/*	public String getLogo()
	{
		return logo;
	}
*/	public void ValidatePinNo()
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=DriverManager.getConnection("jdbc:odbc:Mydatabase","faculty","");
			PreparedStatement ps=con.prepareStatement("Select * from login where cpin_no = ?;");
			
			ps.setString(1,txtPin.getText().trim());
			ResultSet rs=ps.executeQuery();
			
			if (rs.next())
				JOptionPane.showMessageDialog(this,"登陆成功");
			else
				JOptionPane.showMessageDialog(this,"查无此用户");
		}			
		catch(Exception e)
		{
			System.out.println(e);
		}
		
	}
}