mob2.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.*;



public class Mob2 extends JFrame {
	
	private JLabel lmob;
	
	private JTextField tmob;

	private JTextArea info;
	private JButton submit1;
	
	public  Mob2()
	{
		Container contentPane = getContentPane();
		contentPane.setLayout( null );
		//lmob
		lmob = new JLabel();
		lmob.setBounds( 40, 24, 80, 21 );
		lmob.setText( "号码" );
		contentPane.add( lmob );
//		ltel
		tmob = new JTextField();
		tmob.setBounds( 80, 24, 120, 21 );
		tmob.setHorizontalAlignment( JTextField.RIGHT ); 
		contentPane.add( tmob );
//	  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 )
	          {
	        	  showmoney( 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( "中国移动123" ); 
	    setSize( 288, 302 );                  
	    setVisible( true );                   
	    
	}
	private void showmoney(ActionEvent event)
	{
		//Db db=new Db();Db db1=new Db();int rs=db.q(sql);
		
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
		} catch (Exception e) {
			System.out.println("数据库驱动程序错误!");
		}
		String url="jdbc:oracle:thin:@sj215:1521:sist15"; 
		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); //建立数据库查询对象
			Statement stmt1=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.next();//因为结果集的默认位置不是第一行,而是第一行的上面
		   String name=rs.getString("name");
		   info.setText("");
		   info.append("姓名:"+name+"\n");
		  String   sql1="select * from system.yh where mob='"+mob+"'";
		   ResultSet rs1=stmt1.executeQuery(sql1);
		   rs1.next();
		   String bl=rs1.getString("bla");
		   double d=Double.parseDouble(bl);
		   info.append("当前余额为:"+bl+"\n");
		   if(d<10.00)
		   {
			   info.append("余额即将不足,请及时缴费");
		   }
	        
	    
	        
			
	     
	       
	      
	       
		
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		}
//	searchname
	public static void main( String[] args )
	{
	   Mob2 application = new Mob2();
	   application.setDefaultCloseOperation( JFrame.EXIT_ON_CLOSE );

	} 

	}