📄 mob4.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 Mob4 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 Mob4()
{
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( 40, 75, 80, 21 );
lidcard.setText( "时间(秒):" );
contentPane.add( lidcard );
//lidcard
// lname
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 );
// 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 )
{
save( 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 save(ActionEvent event)
{
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); //建立数据库查询对象
String mob1=tmob.getText();//主叫号码
String mob2=tname.getText();//被叫号码
String stime=tidcard.getText();//通话时间
int st=Integer.parseInt(stime);
int flag=0;
String mm=mob2.substring(0,3);
switch (Integer.parseInt(mm))
{
case 135: flag=1;break;
case 136: flag=1;break;
case 137: flag=1;break;
case 138: flag=1;break;
case 139: flag=1;break;
case 159: flag=1;break;
}
//如果flag=0表示外网,如果为1表示内网
double total=0.0;
if(flag<1)
{
if((st%60)==0)
{
total=0.3*(st/60);
}
else
{
total=0.3*((st/60)+1);
}
}
else
{
if((st%60)==0)
{
total=0.15*(st/60);
}
else
{
total=0.15*((st/60)+1);
}
}
info.setText("");
info.append("主叫号码:"+mob1+"\n");
info.append("被叫号码:"+mob2+"\n");
info.append("费用合计:"+total+"\n");
String mob=tmob.getText();
String sql="update system.yh set bla=bla- "+total+" where mob='"+mob+"'";
stmt.executeUpdate(sql);
sql="insert into system.dih(id,mob1,mob2,stime,charge)values(system.xulie.nextval,'"+mob1+"','"+mob2+"',"+st+","+total+")";
stmt.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
// searchname
public static void main( String[] args )
{
Mob4 application = new Mob4();
application.setDefaultCloseOperation( JFrame.EXIT_ON_CLOSE );
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -