基于java和sql的ATM系统

package main; import java.awt.BorderLayout; import java.awt.EventQueue; import javax.swing.JDialog; import javax.swing.JFrame; import javax.swing.JPanel; import javax.swing.border.EmptyBorder; import javax.swing.JLabel; import javax.swing.SwingConstants; import java.awt.Color; import java.awt.Font; 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.JTextField; import javax.swing.JButton; public class MainCha extends JFrame implements ActionListener { private JPanel contentPane; private JTextField getmoney; private String m_Numberno; private JButton btnReturn; /** * Launch the application. */ /** * Create the frame. */ public MainCha(String Numberno) { m_Numberno=Numberno; setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); setBounds(100, 100, 356, 222); contentPane = new JPanel(); contentPane.setBorder(new EmptyBorder(5, 5, 5, 5)); setContentPane(contentPane); contentPane.setLayout(null); getmoney = new JTextField(); getmoney.setBounds(160, 81, 77, 21); contentPane.add(getmoney); getmoney.setColumns(10); JLabel label = new JLabel("\u60A8\u7684\u4F59\u989D:"); label.setHorizontalAlignment(SwingConstants.RIGHT); label.setForeground(Color.RED); label.setBounds(33, 84, 118, 15); contentPane.add(label); btnReturn = new JButton("\u8FD4\u56DE"); btnReturn.setBounds(121, 130, 93, 23); contentPane.add(btnReturn); btnReturn.addActionListener(this); //连接数据库 String JDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver"; String connectDB="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=javaapp"; try{ Class.forName(JDriver); }catch(ClassNotFoundException e1){ System.out.println("加载数据库引擎失败"); System.exit(0); } try{ String user="sa"; String password="123"; Connection con= DriverManager.getConnection(connectDB,user,password); Statement stmt = con.createStatement(); stmt.executeQuery("SELECT * FROM UserCard "); ResultSet rs = stmt.executeQuery("select * from UserCard where Numberno="+m_Numberno); rs.next(); getmoney.setText(rs.getString("Usercash")); }catch(SQLException e2){ e2.printStackTrace(); System.exit(0); } } @Override public void actionPerformed(ActionEvent e) { String JDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver"; String connectDB="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=javaapp"; try{ Class.forName(JDriver); }catch(ClassNotFoundException e1){ System.out.println("加载数据库引擎失败"); System.exit(0); } try{ String user="sa"; String password="123"; Connection con= DriverManager.getConnection(connectDB,user,password); Statement stmt = con.createStatement(); stmt.executeQuery("SELECT * FROM UserCard "); ResultSet rs = stmt.executeQuery("select * from UserCard where Numberno="+m_Numberno); rs.next(); MainD t = new MainD(rs.getString("Numberno")); if(e.getSource()==btnReturn){ t.setDefaultCloseOperation(JDialog.DISPOSE_ON_CLOSE); t.setVisible(true); this.setVisible(false); } }catch(SQLException e2){ e2.printStackTrace(); System.exit(0); } } private String getString(String string) { // TODO Auto-generated method stub return null; } }