timeTable.java
上传用户:qzpk678
上传日期:2021-04-29
资源大小:10k
文件大小:4k
- package src;
- import java.awt.*;
- 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 timeTable extends JFrame
- {
- private static final long serialVersionUID = 1L;
- Connection con;
- Statement sql;
- ResultSet rs;
- JTable t;
- Object o[][];
- Object day[]={"","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"};
- JButton jb1,jb2;
- JLabel jl;
- int rows=5;
- JPanel p1,p2;
- Font font=new Font("Monospaced" ,Font.BOLD,20);
- timeTable(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);
- o=new Object[5][8];
- t=new JTable(o,day);
- t.setRowHeight(35);
- getContentPane().removeAll();
- add(p1,BorderLayout.NORTH);
- add(p2,BorderLayout.SOUTH);
- add(new JScrollPane(t),BorderLayout.CENTER);
- o[0][0]="1~2";
- o[1][0]="3~4";
- o[2][0]="5~6";
- o[3][0]="7~8";
- o[4][0]="9~10";
- 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();
- ResultSet rs;
- rs=sql.executeQuery("SELECT *FROM kechengbiao");
- int i=0;
- while(rs.next()&&i<5)
- {
- o[i][1]=rs.getString(1);
- o[i][2]=rs.getString(2);
- o[i][3]=rs.getString(3);
- o[i][4]=rs.getString(4);
- o[i][5]=rs.getString(5);
- o[i][6]=rs.getString(6);
- o[i][7]=rs.getString(7);
- i++;
- }
- con.close();
- }
- catch(SQLException e1)
- {
- System.out.println(""+e1);
- }
- jb1.addActionListener(new ActionListener(){
- public void actionPerformed(ActionEvent e){
- 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 k0=sql.executeUpdate("INSERT INTO richeng VALUES('"+o[0][1]+"','"+o[0][2]+"','"+o[0][3]+"','"+o[0][4]+"','"+o[0][5]+"','"+o[0][6]+"','"+o[0][7]+"')");
- int k1=sql.executeUpdate("INSERT INTO richeng VALUES('"+o[1][1]+"','"+o[1][2]+"','"+o[1][3]+"','"+o[1][4]+"','"+o[1][5]+"','"+o[1][6]+"','"+o[1][7]+"')");
- int k2=sql.executeUpdate("INSERT INTO richeng VALUES('"+o[2][1]+"','"+o[2][2]+"','"+o[2][3]+"','"+o[2][4]+"','"+o[2][5]+"','"+o[2][6]+"','"+o[2][7]+"')");
- int k3=sql.executeUpdate("INSERT INTO richeng VALUES('"+o[3][1]+"','"+o[3][2]+"','"+o[3][3]+"','"+o[3][4]+"','"+o[3][5]+"','"+o[3][6]+"','"+o[3][7]+"')");
- int k4=sql.executeUpdate("INSERT INTO richeng VALUES('"+o[4][1]+"','"+o[4][2]+"','"+o[4][3]+"','"+o[4][4]+"','"+o[4][5]+"','"+o[4][6]+"','"+o[4][7]+"')");
- if(k0==1&&k1==1&&k2==1&&k3==1&&k4==1)
- {
- JOptionPane.showMessageDialog(new JOptionPane(), "输入日程表成功!!", "成功录入课程表", JOptionPane.INFORMATION_MESSAGE);
- }
- con.close();
- }
- catch(SQLException e1)
- {
- System.out.println(""+e1);
- JOptionPane.showMessageDialog(new JOptionPane(), "输入日程表失败!!", "失败信息", JOptionPane.INFORMATION_MESSAGE);
- }
- }
- });
- jb2.addActionListener(new ActionListener(){
- public void actionPerformed(ActionEvent e){
- new time("查看日程时间表!!");
- }
- });
- validate();
- setResizable(false);
- setBounds(500, 300, 800, 302);
- setVisible(true);
- setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
- }
- }