reality.java
上传用户:qzpk678
上传日期:2021-04-29
资源大小:10k
文件大小:3k
- package src;
- import java.awt.BorderLayout;
- 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.JButton;
- import javax.swing.JFrame;
- import javax.swing.JLabel;
- import javax.swing.JOptionPane;
- import javax.swing.JPanel;
- import javax.swing.JScrollPane;
- import javax.swing.JTable;
- public class reality extends JFrame
- {
- private static final long serialVersionUID = 1L;
- JTable t;
- Object o[][]=new Object[30][6];
- Object fun[]={"日期号","吃饭喝水","买书买报","请同学吃饭","出门坐车","其他支出"};
- JButton jb1,jb2;
- JLabel jl;
- JPanel p1,p2;
- Font font=new Font("Monospaced" ,Font.BOLD,15);
- Connection con;
- Statement sql;
- ResultSet rs;
- public reality(String s)
- {
- setTitle(s);
- jl=new JLabel("请在下面的表格中输入本月资金实际使用情况");
- jl.setForeground(Color.magenta);
- jl.setFont(font);
- jl.setHorizontalAlignment(JLabel.CENTER);
- jb1=new JButton("确定");
- jb2=new JButton("退出");
- p1=new JPanel();
- p1.add(jl);
- p2=new JPanel();
- p2.add(jb1);
- p2.add(jb2);
- t=new JTable(o,fun);
- t.setRowHeight(35);
- getContentPane().removeAll();
- for(int i=0;i<30;i++)
- {
- for(int j=0;j<6;j++)
- {
- o[i][j]=0;
- }
- }
- for(int i=0;i<30;i++)
- {
- o[i][0]=i+1;
- }
- add(p1,BorderLayout.NORTH);
- add(p2,BorderLayout.SOUTH);
- add(new JScrollPane(t),BorderLayout.CENTER);
- jb1.addActionListener(new ActionListener()
- {
- public void actionPerformed(ActionEvent e)
- {
- try
- {
- Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
- }
- catch(ClassNotFoundException e1){System.out.println(""+e1);}
- try
- {
- String uri="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatebaseName=design";
- String user="chenzhi";
- String password="chenzhi";
- con=DriverManager.getConnection(uri,user,password);
- sql= con.createStatement();
- int k=0;
- for(int ii=0;ii<30;ii++)
- {
- k=sql.executeUpdate("INSERT INTO outMoney VALUES('"+o[ii][1]+"','"+o[ii][2]+"','"+o[ii][3]+"','"+o[ii][4]+"','"+o[ii][5]+"')");
- }
- if(k==1)
- JOptionPane.showMessageDialog(new JOptionPane(), "本月实际支出明细录入成功!!!", "确认信息", JOptionPane.INFORMATION_MESSAGE);
- con.close();
- }
- catch(SQLException e1)
- {
- System.out.println(""+e1);
- }
- }
- });
- jb2.addActionListener(new ActionListener(){
- public void actionPerformed(ActionEvent e) {
- dispose();
- System.exit(0);
- }
-
- });
- validate();
- setResizable(false);
- setBounds(500, 300, 500, 560);
- setVisible(true);
- setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
- }
- }