userinfo.java

实现JSP开发的BBS源码

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


//查询用户信息
 public class  userInfo extends JFrame implements ActionListener{
 	
 	Connection con=null;
 	ResultSet rs=null;
 	Statement st=null;
 	
 	private String uId=new String();
 	private String uName=new String();
 	private String uSex=new String();
 	private String uBirth=new String();
 	private String uTel=new String();
 	private String uAddr=new String();
 	private String uCardNum=new String();
 	private String uIDCard=new String();
 	private String getCardNum=null;
 	private String getUserID=null;
 	private String command=null;
 	private boolean flag=true;//标志是用卡号查询
 	private boolean flag2;//标志是用卡号查询还是用UserID查询用户信息
 	
 	private JLabel userInfo=new JLabel("客户信息:");
 	private JLabel userIDLabel=new JLabel("客户ID:");
 	private JTextField userID=new JTextField(8);
 	private JLabel userNameLabel=new JLabel("姓 名:");
 	private JTextField userName=new JTextField(8);
 	private JLabel birthdayLabel=new JLabel("出生日期:");
 	private JLabel birthdayTypeLabel=new JLabel("(yyyy-mm-dd)");
 	private JTextField birthday=new JTextField(10);
 	private JLabel telLabel=new JLabel("电 话:");
 	private JTextField tel=new JTextField(11);
 	private JLabel addrLabel=new JLabel("地 址:");
 	private JTextField addr=new JTextField(30);
 	private JLabel sexLabel=new JLabel("性 别:");
 	private JTextField sex=new JTextField(6);
 	private JLabel userCardNumLabel=new JLabel("用户卡号:");
 	private JTextField userCardNum=new JTextField(18);
 	private JLabel userIDCardLabel=new JLabel("身份证");
 	private JTextField userIDCard=new JTextField(18);
 	private JLabel line1=new JLabel("---------------------------------------------------------------------------");
 	private JLabel line2=new JLabel("---------------------------------------------------------------------------");
 	private JLabel line3=new JLabel("---------------------------------------------------------------------------");
 	private JLabel line4=new JLabel("---------------------------------------------------------------------------");
 	private JLabel queryMethodsLabel=new JLabel("选择查询的方式:");
 	private JLabel method1Label=new JLabel("1.卡号查询");
 	private JLabel inputCardNumLabel=new JLabel("输入卡号:");
 	private JTextField inputCardNum=new JTextField(19);
 	private JLabel method2Label=new JLabel("2.用户ID查询");
 	private JLabel inputUserIDLabel=new JLabel("输入用户ID:");
 	private JTextField inputUserID=new JTextField(8);
 	private JButton query1=new JButton("查看");
 	private JButton query2=new JButton("查看");
 	private JButton clear=new JButton("清除");
 	private JButton exit=new JButton("退 出");
 	
 	//无参构造方法
 	public userInfo(){
 		userInfoSetup();
 	}
 	
 	//有参构造方法
 	public userInfo(String card){
 		userInfoSetup();
 		inputCardNum.setText(card);
 	}
 	
 	//初始化面板方法
 	public void userInfoSetup(){
 		setTitle("查看用户信息");
 		setSize(600,500);
 		setLocation(300,250);
 		setResizable(false);
 		
 		addWindowListener(new WindowAdapter(){
 			public void windowClosing(WindowEvent e){
 				userInfo.this.hide();
 			}
 		});
 		
 		
 		Container c=getContentPane();
 		c.setLayout(null);
 		c.add(userInfo);
 		userInfo.setBounds(10,10,80,30);
 		c.add(userIDLabel);
 		userIDLabel.setBounds(30,40,60,30);
 		c.add(userID);
 		userID.setBounds(90,40,250,30);
 		c.add(userNameLabel);
 		userNameLabel.setBounds(350,40,60,30);
 		c.add(userName);
 		userName.setBounds(400,40,160,30);
 		c.add(birthdayLabel);
 		birthdayLabel.setBounds(30,80,60,30);
 		c.add(birthday);
 		birthday.setBounds(90,80,160,30);
 		c.add(birthdayTypeLabel);
 		birthdayTypeLabel.setBounds(260,80,100,30);
 		c.add(sexLabel);
 		sexLabel.setBounds(350,80,60,30);
 		c.add(sex);
 		sex.setBounds(400,80,160,30);
 		c.add(addrLabel);
 		addrLabel.setBounds(30,120,60,30);
 		c.add(addr);
 		addr.setBounds(90,120,250,30);
 		c.add(telLabel);
 		telLabel.setBounds(350,120,60,30);
 		c.add(tel);
 		tel.setBounds(400,120,160,30);
 		c.add(userCardNumLabel);
 		userCardNumLabel.setBounds(30,160,60,30);
 		c.add(userCardNum);
 		userCardNum.setBounds(90,160,250,30);
 		c.add(userIDCardLabel);
 		userIDCardLabel.setBounds(350,160,60,30);
 		c.add(userIDCard);
 		userIDCard.setBounds(400,160,160,30);
 		c.add(line1);
 		line1.setBounds(0,210,300,5);
 		c.add(line2);
 		line2.setBounds(300,210,300,5);
 		c.add(queryMethodsLabel);
 		queryMethodsLabel.setBounds(250,220,300,20);
 		c.add(method1Label);
 		method1Label.setBounds(20,240,100,20);
 		c.add(inputCardNumLabel);
 		inputCardNumLabel.setBounds(80,260,60,40);
 		c.add(inputCardNum);
 		inputCardNum.setBounds(150,260,260,40);
 		c.add(query1);
 		query1.setBounds(420,260,60,40);
 		query1.addActionListener(this);
 		c.add(line3);
 		line3.setBounds(0,310,300,5);
 		c.add(line4);
 		line4.setBounds(300,310,300,5);
 		c.add(method2Label);
 		method2Label.setBounds(20,320,70,20);
 		c.add(inputUserIDLabel);
 		inputUserIDLabel.setBounds(80,340,70,40);
 		c.add(inputUserID);
 		inputUserID.setBounds(150,340,260,40);
 		c.add(query2);
 		query2.setBounds(420,340,60,40);
 		query2.addActionListener(this);	
 		c.add(clear);
 		clear.setBounds(200,420,70,35);
 		clear.addActionListener(this);
 		c.add(exit);
 		exit.setBounds(280,420,70,35);
 		exit.addActionListener(this);
 		show();
 	}
 	//查询
 	public void query(String inputStr1,String errorStr ,boolean flag){
 		if(flag){
 			command="select * from userTable where userCardNum='"+inputStr1+"'";
 		}
 		else{
 			command="select * from userTable where UserID='"+inputStr1+"'";
 		}
 		
 		try{
 			st=connectDB.conDB();//连接数据库
 			con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BSMS","sa","5201314");
 			rs=st.executeQuery(command);
 			if(rs.next()){
 				uId=rs.getString("userID");
 				uName=rs.getString("userName");
 				uBirth=rs.getString("birthday");
 				uSex=rs.getString("sex");
 				uTel=rs.getString("tel");
 				uAddr=rs.getString("addr");
 				//JOptionPane.showMessageDialog(null,uAddr);
 				uCardNum=rs.getString("userCardNum");
 				uIDCard=rs.getString("userIDCard");
 				showUserInfo(uId,uName,uBirth,uSex,uAddr,uTel,uCardNum,uIDCard);
 			}
 			else{
 				JOptionPane.showMessageDialog(null,errorStr);
 			}
 		}catch(SQLException ex){
 			while(ex!=null){
 				JOptionPane.showMessageDialog(null,ex);
 				ex.getNextException();
 				return;
 			}
 		}
 	closeDB.closeDB(st,con);
 	}
 	
 	//显示查询结果
 	public void showUserInfo(String uId,String uName,String uBirth,String uSex,String uAddr,String uTel,String uCardNum,String uIDCard){
 		userID.setText(uId);
 		userName.setText(uName);
 		birthday.setText(uBirth);
 		sex.setText(uSex);
 		addr.setText(uAddr);
 		tel.setText(uTel);
 		userCardNum.setText(uCardNum);
 		userIDCard.setText(uIDCard);                                                                                                            	
 		
 	}
   
   //事件监听
   public void actionPerformed(ActionEvent ae){
   	if(ae.getSource()==query1){  //用卡号查询用户信息
   		flag2=true;
   		getCardNum=inputCardNum.getText().trim();
   		if(getCardNum.equals("")==true){
   			JOptionPane.showMessageDialog(null,"请输入卡号后再查询!");
   			flag=false;
   			confirmDialog reEnter=new confirmDialog(this,"重新输入","重新输入卡号");
		    if(reEnter.isOkay){
				flag=true;
				return;
			}
			else{
				hide();
			}
   		}
   		query(getCardNum,"不存在拥有此卡号的用户信息",flag2);
   	}
   	else if(ae.getSource()==query2){  //用用户ID查询用户信息
   		flag2=false;
   		getUserID=inputUserID.getText().trim();
   		if(getUserID.equals("")==true){
   			flag2=false;
   			JOptionPane.showMessageDialog(null,"请输入用户ID后再查询!");
   			flag=false;
   			confirmDialog reEnter=new confirmDialog(this,"重新输入","重新输入用户ID");
		    if(reEnter.isOkay){
				flag=true;
				return;
			}
			else{
				hide();
			}
   		}
   		query(getUserID,"不存在此用户,或用户ID错误",flag2);	
   	}
   	else if(ae.getSource()==clear){  //清除按钮
   		userID.setText("");
 		userName.setText("");
 		birthday.setText("");
 		sex.setText("");
 		addr.setText("");
 		tel.setText("");
 		userCardNum.setText("");
 		userIDCard.setText("");
 		inputCardNum.setText("");
 		inputUserID.setText("");
 		flag=true;
 		flag2=false;
   	}
   	else if(ae.getSource()==exit){ //退出按钮
   		confirmDialog reEnter=new confirmDialog(this,"退出","确定退出程序吗?");
		if(reEnter.isOkay){
			flag=true;
            flag2=false;			
			return;
		}
		else{
			hide();
		}
   	}
   }
 	public static void main(String args[]){
 		userInfo User=new userInfo();
 	}
 }