inputinfo.java

来自「用纯java语言实现的数字证书制作工具。」· Java 代码 · 共 205 行

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

public class InputInfo extends JFrame implements ActionListener 
{
		void buildConstraints(GridBagConstraints gbc,int gx,int gy,int gw,int gh,int wx,int wy)
	{
		gbc.gridx=gx;
		gbc.gridy=gy;
		gbc.gridwidth=gw;
		gbc.gridheight=gh;
		gbc.weightx=wx;
		gbc.weighty=wy;
	}
	
	JTextField UserName=new JTextField();
	JTextField Nation=new JTextField();
	JTextField City=new JTextField();
	JTextField Unit=new JTextField();
	JTextField Orgnization=new JTextField();
	JTextField IDCard=new JTextField();
	
	String flag;
	String UN,N,C,U,O,ID;
	public void Display()
	{
		JFrame f1=new JFrame("用户信息输入界面");
        JPanel pane=new JPanel();
		f1.setBounds(320,180,300,400);
		
		GridBagLayout gridbag = new GridBagLayout();
		GridBagConstraints constraints = new GridBagConstraints();
		pane.setLayout(gridbag);
		
		buildConstraints(constraints,0,0,1,1,10,40);
		constraints.fill=GridBagConstraints.NONE;
		constraints.anchor=GridBagConstraints.CENTER;
		JLabel Label1=new JLabel("用户名称",JLabel.CENTER);
		gridbag.setConstraints(Label1,constraints);
		pane.add(Label1);
		
		buildConstraints(constraints,1,0,1,1,90,0);
		constraints.fill=GridBagConstraints.HORIZONTAL;
	    constraints.anchor=GridBagConstraints.CENTER;	    
		gridbag.setConstraints(UserName,constraints);
		pane.add(UserName);
		
		buildConstraints(constraints,0,1,1,1,90,0);
		constraints.fill=GridBagConstraints.HORIZONTAL;
	    constraints.anchor=GridBagConstraints.CENTER;
		JLabel Label2=new JLabel("国家",JLabel.CENTER);
		gridbag.setConstraints(Label2,constraints);
		pane.add(Label2);
		
		buildConstraints(constraints,1,1,1,1,90,0);
		constraints.fill=GridBagConstraints.HORIZONTAL;
	    constraints.anchor=GridBagConstraints.CENTER;	    
		gridbag.setConstraints(Nation,constraints);
		pane.add(Nation);
		

		buildConstraints(constraints,0,2,1,1,10,40);
		constraints.fill=GridBagConstraints.NONE;
		constraints.anchor=GridBagConstraints.CENTER;
		JLabel Label4=new JLabel("城市",JLabel.CENTER);
		gridbag.setConstraints(Label4,constraints);
		pane.add(Label4);
		
		buildConstraints(constraints,1,2,1,1,90,0);
		constraints.fill=GridBagConstraints.HORIZONTAL;
	    constraints.anchor=GridBagConstraints.CENTER;	    
		gridbag.setConstraints(City,constraints);
		pane.add(City);
		
		buildConstraints(constraints,0,3,1,1,10,40);
		constraints.fill=GridBagConstraints.NONE;
		constraints.anchor=GridBagConstraints.CENTER;
		JLabel Label5=new JLabel("单位",JLabel.CENTER);
		gridbag.setConstraints(Label5,constraints);
		pane.add(Label5);
		
		buildConstraints(constraints,1,3,1,1,90,0);
		constraints.fill=GridBagConstraints.HORIZONTAL;
	    constraints.anchor=GridBagConstraints.CENTER;	    
		gridbag.setConstraints(Unit,constraints);
		pane.add(Unit);
		
		buildConstraints(constraints,0,4,1,1,10,40);
		constraints.fill=GridBagConstraints.NONE;
		constraints.anchor=GridBagConstraints.CENTER;
		JLabel Label6=new JLabel("组织",JLabel.CENTER);
		gridbag.setConstraints(Label6,constraints);
		pane.add(Label6);
		
		buildConstraints(constraints,1,4,1,1,90,0);
		constraints.fill=GridBagConstraints.HORIZONTAL;
	    constraints.anchor=GridBagConstraints.CENTER;	    
		gridbag.setConstraints(Orgnization,constraints);
		pane.add(Orgnization);

		buildConstraints(constraints,0,5,1,1,10,40);
		constraints.fill=GridBagConstraints.NONE;
		constraints.anchor=GridBagConstraints.CENTER;
		JLabel Label8=new JLabel("IDCard",JLabel.CENTER);
		gridbag.setConstraints(Label8,constraints);
		pane.add(Label8);
		
		buildConstraints(constraints,1,5,1,1,90,0);
		constraints.fill=GridBagConstraints.HORIZONTAL;
	    constraints.anchor=GridBagConstraints.CENTER;	    
		gridbag.setConstraints(IDCard,constraints);
		pane.add(IDCard);
		
		buildConstraints(constraints,0,6,1,1,50,40);
		constraints.fill=GridBagConstraints.NONE;
	    constraints.anchor=GridBagConstraints.EAST;
		JButton ok=new JButton("确认");
		gridbag.setConstraints(ok,constraints);
	    ok.addActionListener(this);
	    pane.add(ok);
	    
	    buildConstraints(constraints,1,6,1,1,90,0);
		constraints.fill=GridBagConstraints.NONE;
	    constraints.anchor=GridBagConstraints.WEST;
	    JButton cancel=new JButton("重置");
	    cancel.addActionListener(this);
	    gridbag.setConstraints(cancel,constraints);
	    pane.add(cancel); 
	    
	    f1.setContentPane(pane);
		f1.setVisible(true);
	}
	
	
	public void actionPerformed(ActionEvent ae)
   	{
   		UN=UserName.getText().trim();
   		N=Nation.getText().trim();
   		C=City.getText().trim();
   		U=Unit.getText().trim();
   		O=Orgnization.getText().trim();
   		ID=IDCard.getText().trim();
   		
       	if(ae.getActionCommand().equals("重置"))
       		{
       			UserName.setText("");
       			Nation.setText("");
				City.setText("");
				Unit.setText("");
				Orgnization.setText("");
				IDCard.setText("");
       	    }
     if(ae.getActionCommand().equals("确认"))
     	{
     		if(UN.equals("")||N.equals("")||C.equals("")||
     				U.equals("")||O.equals("")||ID.equals(""))
     				JOptionPane.showMessageDialog(null,"请完成表格内容的填写!");
     		else if(!ID.equals(""))
     		{
     			
      	 	try{
       		String query;
       		query="select * from UserData where IDCard='"+UN+"'";
       	    Connect conn=new Connect();
			Statement stmt=conn.con.createStatement();	
			ResultSet rs=stmt.executeQuery(query);
       	    if(!rs.next())
       	    {
       	    		query="insert into UserData(UserName,Nation,"
       	    				+"City,Unit,Orgnization,IDCard)"
       	    				+"values ('"+UN+"','"+N+"','"+C+"','"+U+"','"
       	    				+O+"','"+ID+"')";
       				stmt.executeUpdate(query);
       	       		JOptionPane.showMessageDialog(null,"您的信息已经进入数据库!");
       	       		stmt.close();
					conn.con.close();
					this.setVisible(false);
       	    } 
       	    else
       	    {
       	    	JOptionPane.showMessageDialog(null,"IDCard重复，请重新选择!");
       	    } 	 
       	}
       	catch(SQLException se)
       	{
       		String mm;
	       	mm="数据库执行错误："+se.getMessage();
	       	JOptionPane.showMessageDialog(null,mm);
       		System.out.println("SQLException:"+se.toString());
       	}
        }
      }
   	}
   	
 /*
   	public static void main(String args[])
   	{
   		InputInfo in=new InputInfo();
   		in.Display();
   	}
*/
}