set.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.*;
- public class set extends JFrame
- {
- private static final long serialVersionUID = 1L;
- JTable t;
- Object o[][]=new Object[1][5];
- 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 set(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();
- 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=sql.executeUpdate("INSERT INTO setMoney VALUES('"+o[0][0]+"','"+o[0][1]+"','"+o[0][2]+"','"+o[0][3]+"','"+o[0][4]+"')");
- int n1=Integer.parseInt(o[0][0].toString());
- int n2=Integer.parseInt(o[0][1].toString());
- int n3=Integer.parseInt(o[0][2].toString());
- int n4=Integer.parseInt(o[0][3].toString());
- int n5=Integer.parseInt(o[0][4].toString());
- int n=n1+n2+n3+n4+n5;
- if(k==1&&n==100)
- JOptionPane.showMessageDialog(new JOptionPane(), "本月支出比例录入成功!!!", "确认信息", JOptionPane.INFORMATION_MESSAGE);
- else
- 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, 156);
- setVisible(true);
- setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
- }
- }