mob1.java

这个程序是创建用户

package 创建用户;



import java.awt.Component;
import java.awt.Container;
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.*;
import javax.swing.event.*;

//import test0207.CarPayment;


/**
* This code was generated using CloudGarden's Jigloo
* SWT/Swing GUI Builder, which is free for non-commercial
* use. If Jigloo is being used commercially (ie, by a corporation,
* company or business for any purpose whatever) then you
* should purchase a license for each developer using Jigloo.
* Please visit www.cloudgarden.com for details.
* Use of Jigloo implies acceptance of these licensing terms.
* *************************************
* A COMMERCIAL LICENSE HAS NOT BEEN PURCHASED
* for this machine, so Jigloo or this code cannot be used legally
* for any corporate or commercial purpose.
* *************************************
*/
public class Mob1 extends JFrame {
	
	private JLabel lmob;
	private JLabel lname;
	private JLabel lidcard;
	private JLabel ltel;
	private JTextField tmob;
	private JTextField tname;
	private JTextField tidcard;
	private JTextField ttel;
	private JTextArea info;
	private JButton submit1;
	
	public  Mob1()
	{
		Container contentPane = getContentPane();
		contentPane.setLayout( null );
		//lmob
		lmob = new JLabel();
		lmob.setBounds( 40, 24, 80, 21 );
		lmob.setText( "号码" );
		contentPane.add( lmob );
		//lmob
//		lname
		lname = new JLabel();
		lname.setBounds( 40, 50, 80, 21 );
		lname.setText( "姓名:" );
		contentPane.add( lname );
		//lname
//		lidcard
		lidcard = new JLabel();
		lidcard.setBounds(43, 78, 80, 21);
		lidcard.setText( "证件:" );
		contentPane.add( lidcard );
		//lidcard
//		lname
//		ltel
		ltel = new JLabel();
		ltel.setBounds( 40, 100, 80, 21 );
		ltel.setText( "固话:" );
		contentPane.add( ltel );
		//ltel
		tmob = new JTextField();
		tmob.setBounds( 80, 24, 120, 21 );
		tmob.setHorizontalAlignment( JTextField.RIGHT ); 
		contentPane.add( tmob );
		   
	    tname = new JTextField();
		tname.setBounds( 80, 50, 120, 21 );
		tname.setHorizontalAlignment( JTextField.RIGHT ); 
	    contentPane.add( tname );
	    
	    tidcard = new JTextField();
	    tidcard.setBounds( 80, 75, 120, 21 );
	    tidcard.setHorizontalAlignment( JTextField.RIGHT ); 
	    contentPane.add( tidcard );
	    
	    ttel = new JTextField();
	    ttel.setBounds( 80, 100, 120, 21 );
	    ttel.setHorizontalAlignment( JTextField.RIGHT ); 
	    contentPane.add( ttel );
//	  search
//	  set up calculateJButton and register its event handler
	    submit1 = new JButton();
	    submit1.setBounds( 110, 128, 60, 24 );
	    submit1.setText( "提交" );
	    contentPane.add( submit1 );
	    submit1.addActionListener( 
	    
	       new ActionListener() // anonymous inner class
	       {
	          // event handler called when user clicks calculateJButton
	          public void actionPerformed( ActionEvent event )
	          {
	             saveuser( event );
	          }
	          
	       } // end anonymous inner class
	       
	    ); // end call to addActionListener
	    
	    //search
	    info= new JTextArea();
	    info.setBounds( 28, 168, 232, 90 );
		info.setEditable( false );
	    contentPane.add( info );
	    
	    setTitle( "中国移动" ); 
	    setSize( 288, 302 );                  
	    setVisible( true );                   
	    
	}
	private void saveuser(ActionEvent event)
	{
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
		} catch (Exception e) {
			System.out.println("数据库驱动程序错误!");
		}
		String url="jdbc:oracle:thin:@sj217:1521:sist17"; 
		String user="system"; 
		String password="manager"; 
		Connection conn;
		try {
			conn = DriverManager.getConnection(url,user,password);//建立数据库连接
			Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); //建立数据库查询对象
	       String mob=tmob.getText();
			
	        String sql="select * from system.sy where mob='"+mob+"'";
	        ResultSet rs=stmt.executeQuery(sql);
	        rs.last();//将结果集的指针指向最后一行
	        int a=rs.getRow();//将当前的行号取得过来.换句话说,这个a就是结果集当中结果的个数
	        if(a>0)
	        {
	        	info.setText("");
	        	info.append("该号码已经存在");
	        	System.out.println(a);
	        }
	        else
	        {  String name=tname.getText();
        	String idcard=tidcard.getText();
        	String tel=ttel.getText();
        	sql="insert into system.sy(mob,name,idcard,tel) values('"+mob+"','"+name+"','"+idcard+"','"+tel+"')";
        	stmt.executeUpdate(sql);
        	sql="insert into system.yh(mob,bla) values('"+mob+"',0)";
        	stmt.executeUpdate(sql);
        	info.setText("");
        	info.append(mob+"用户注册成功");
	        }
	    
	        
			
	     
	       
	      
	       
		
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		}
//	searchname
	public static void main( String[] args )
	{
	   Mob1 application = new Mob1();
	   application.setDefaultCloseOperation( JFrame.EXIT_ON_CLOSE );

	} 

	}