mob7.java

来自「用来发短信的。通过它你可以写出发短信的一系列程序 呵呵很好的哦」· Java 代码 · 共 187 行

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 oracle.jdbc.driver.*;
import javax.swing.*;
import javax.swing.event.*;

//import test0207.CarPayment;

public class Mob7 extends JFrame {
	
	private JLabel lmob;
	private JLabel lname;
	private JLabel lidcard;
	private JLabel ltel;
	private JTextField mob1;
	private JTextField mob2;
	private JTextArea sms;
	private JButton submit1;
	
	public  Mob7()
	{
		Container contentPane = getContentPane();
		contentPane.setLayout( null );
		//lmob
		lmob = new JLabel();
		lmob.setBounds( 20, 24, 80, 21 );
		lmob.setText( "本机号码" );
		contentPane.add( lmob );
		//lmob
//		lname
		lname = new JLabel();
		lname.setBounds( 20, 50, 80, 21 );
		lname.setText( "对方号码:" );
		contentPane.add( lname );
		//lname


		mob1 = new JTextField();
		mob1.setBounds( 80, 24, 120, 21 );
		mob1.setHorizontalAlignment( JTextField.RIGHT ); 
		contentPane.add( mob1 );
		   
	    mob2 = new JTextField();
	    mob2.setBounds( 80, 50, 120, 21 );
	    mob2.setHorizontalAlignment( JTextField.RIGHT ); 
	    contentPane.add( mob2 );
	    
	    
//	  search
//	  set up calculateJButton and register its event handler
	    submit1 = new JButton();
	    submit1.setBounds( 110, 128, 100, 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
	    sms= new JTextArea();
	    sms.setBounds( 28, 168, 232, 90 );
	    //sms.setEditable( false );
	    contentPane.add( sms );
	    
	    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:@sxj401:1521:maomao"; 
		String user="s58"; 
		String password="s58"; 
		Connection conn;//建立数据库连接
	    try {
			conn = DriverManager.getConnection(url,user,password);
			Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); //建立数据库查询对象
		       String mob1a=mob1.getText();//发送方手机号码
		       String mob2a=mob2.getText();//接受方手机号码
		       String smsa=sms.getText();
		    String sql="select * from users where mob='"+mob1a+"'";
		    ResultSet rs=stmt.executeQuery(sql);
		    rs.last();
		    int a=rs.getRow();
		    if(a>0)
		    {
		    	//发送方存在
		    	String mob3=mob2a.substring(0,3);
		    	int mob4=1;//如果为0表示内网,如果是1表示外网
		    	if(mob3.equals("135"))
		    	{
		    		mob4=0;
		    	}
		    	if(mob3.equals("136"))
		    	{
		    		mob4=0;
		    	}
		    	if(mob3.equals("137"))
		    	{
		    		mob4=0;
		    	}
		    	if(mob3.equals("138"))
		    	{
		    		mob4=0;
		    	}
		    	if(mob3.equals("139"))
		    	{
		    		mob4=0;
		    	}
		    	if(mob3.equals("159"))
		    	{
		    		mob4=0;
		    	}
		        if(mob4<1)
		    	sql="insert into sms(id,mob1,mob2,readio,stime1,stime2,sms) values(xl.nextval,'"+mob1a+"','"+mob2a+"',0,sysdate,null,'"+smsa+"')";
		        else
		        sql="insert into sms(id,mob1,mob2,readio,stime1,stime2,sms) values(xl.nextval,'"+mob1a+"','"+mob2a+"',0,sysdate,sysdate,'"+smsa+"')";
		        stmt.executeUpdate(sql);
		        double charge=0.0;
		        if(mob4<1)
		        	charge=0.1;
		        else
		        	charge=0.15;
		        sql="update money set bla=bla-"+charge+" where mob='"+mob1a+"'";
		        stmt.executeUpdate(sql);
		        mob1.setText("发送成功");
		    }
		    else
		    {
		    	//发送方不存在
		    	mob1.setText("发送方不存在");
		    }
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	    
			
	        
	       
	    
	        
			
	     
	       
	      
	       
		
		
		}
//	searchname
	public static void main( String[] args )
	{
	   Mob7 application = new Mob7();
	   application.setDefaultCloseOperation( JFrame.EXIT_ON_CLOSE );

	} 

	}