fpanel18.java

丽婴房库存销售系统 描述：C/S构架

package src1;

import java.awt.Color;
import java.awt.Rectangle;
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.SQLException;
import java.sql.Statement;

import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;

public class FPanel18 extends FunctionPanel implements ActionListener{

	
	private static final long serialVersionUID = 1L;
	private Connection connect=null;
	private Statement st=null;
	private ResultSet rset=null;
	private JLabel label1,label2;
	private JTextField tf1;
	JPasswordField pw1;
	private JButton bt1,bt2;
	private JPanel panel1,panel2;
	private String sql=null;
	public FPanel18() {
		// TODO 自动生成构造函数存根
		operationLabel.setText("操作：注销");
		this.setLayout(null);
		label1 = new JLabel("用户名");
	    label2 = new JLabel(" 密码");
	    label1.setIcon(new ImageIcon("./src/icons/25.gif"));
		label2.setIcon(new ImageIcon("./src/icons/25.gif"));
		tf1  =  new JTextField(12);
		pw1  =  new JPasswordField(6);
		bt1 = new JButton("注销");
		bt2 = new JButton("取消");
		bt1.setIcon(new ImageIcon("./src/icons/27.gif"));
		bt2.setIcon(new ImageIcon("./src/icons/27.gif"));
		
		panel1 =new JPanel();
		panel2=new JPanel();
		panel1.setBounds(150,150,260,80);
		panel2.setBounds(150,240,260,40);
		panel1.setBackground(new Color(240,255,255));
		panel2.setBackground(new Color(240,255,255));
		panel1.setLayout(null);
		
		label1.setBounds(20, 20, 100, 25);
		tf1.setBounds(130,20,100,25);
		label2.setBounds(20, 50, 100, 25);
		pw1.setBounds(130,50,100,25);
		
		panel1.add(label1);panel1.add(tf1);
		panel1.add(label2);panel1.add(pw1);
		panel2.add(bt1);panel2.add(bt2);
		this.add(panel1);
		this.add(panel2);
	
		bt1.addActionListener(this);
		bt2.addActionListener(this);
		this.setVisible(false);
	}

	public void actionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub
		if(e.getSource()== bt1)
		{  
			sql="select * from UInf where uID= '"+
			    tf1.getText().trim()+"' and pw='"+
			     String.copyValueOf(pw1.getPassword()).trim()+"';";
			try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
					} catch (ClassNotFoundException e2) {
					// TODO Auto-generated catch block
					e2.printStackTrace();
				}
			 try{ 
				 connect=DriverManager.getConnection("jdbc:odbc:MSSQL");
				st=connect.createStatement();
				rset=st.executeQuery(sql);
				//connect.close();
				}catch (SQLException e3) {
					// TODO Auto-generated catch block
					e3.printStackTrace();
					System.out.print(e3);
				}
			    boolean isexist=false;
			try {
				isexist=rset.next();
			} catch (SQLException e4) {
				// TODO Auto-generated catch block
				e4.printStackTrace();
			}
			if(! isexist){
				JOptionPane.showMessageDialog(null, "用户名或密码错误！");
			}
			else{
				sql="delete from UInf where uID='"+tf1.getText().trim()+"';";
				try {
					st.executeUpdate(sql);
					connect.commit();
					JOptionPane.showMessageDialog(null, "注销成功！");
				} catch (SQLException e4) {
					// TODO Auto-generated catch block
					JOptionPane.showMessageDialog(null, "注销失败！");
					e4.printStackTrace();
				}
			}
			
		}
		if(e.getSource()== bt2){
			tf1.setText("");
			pw1.setText("");
			
		}
	}

}