OA.rar_添加项目

package ViewLayout; import java.awt.Color; import java.awt.Dimension; import java.awt.FlowLayout; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.io.File; import java.sql.ResultSet; import javax.swing.BorderFactory; import javax.swing.Icon; import javax.swing.ImageIcon; import javax.swing.JButton; import javax.swing.JFileChooser; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JToolBar; import javax.swing.JTree; import javax.swing.border.Border; import javax.swing.border.TitledBorder; import javax.swing.event.TreeSelectionEvent; import javax.swing.event.TreeSelectionListener; import javax.swing.filechooser.FileFilter; import javax.swing.filechooser.FileNameExtensionFilter; import javax.swing.tree.DefaultMutableTreeNode; import javax.swing.tree.DefaultTreeModel; import javax.swing.tree.TreeNode; import javax.swing.tree.TreePath; import SqlControl.SqlControl; public class UserLayout extends JFrame{ private String username; private String projectMark; private String projectname; //private AddProjectTextPart addproject; //private AddTaskTextPart addTaskTextPart; private JPanel Treepanel = new JPanel(); private JPanel Taskslist = new JPanel(); private JToolBar jToolBar = null; private JTree jTree = new JTree(); private ProjectTextPart projectTextPart = new ProjectTextPart(220,50,0,0); private TaskPart TaskPart = new TaskPart(220,0,0,0); DefaultMutableTreeNode Root,Project,Select,OProjects,LProjects; JButton exit = new JButton(); SqlControl sql = new SqlControl(); String Lselect = "select Project from ProjectsTable where status = 1"; String Oselect = "select Project from ProjectsTable where status = 0"; String usermarkselect = "select ProjectMark from UsersTable where Username = "; String userindentityselect = "select Position from UsersTable where Username = "; //导航栏内容 private JToolBar SetNavigationBar(int x,int y,int w,int h,String username,String realname){ JLabel welcomeText = new JLabel(realname+" 欢迎您的使用"); JButton AddProject = new JButton("添加项目"); JButton AddTask = new JButton("添加任务"); JButton DelectProject = new JButton("删除项目"); JButton DelectTask = new JButton("删除任务"); sql.GetConnection(); String identity = sql.CheckIndetity(userindentityselect+"'"+username+"'"); System.out.print(identity.trim()); if(jToolBar == null){ jToolBar = new JToolBar(); jToolBar.add(welcomeText);jToolBar.addSeparator(); if(identity.trim().equalsIgnoreCase("Admin")){ jToolBar.add(AddProject);jToolBar.addSeparator(); jToolBar.add(AddTask);jToolBar.addSeparator(); jToolBar.add(DelectProject);jToolBar.addSeparator(); jToolBar.add(DelectTask);jToolBar.addSeparator(); } } //添加项目动作 AddProject.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub final AddProjectTextPart addproject = new AddProjectTextPart(projectMark); ////////添加项目的按钮/////////////////// addproject.OkButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub String ProjectText = "insert ProjectsTable(Project,StartTime,OverTime,EnterTime,Description,ProjectMark,Status,Responsible)" +"values('"+addproject.ProjectName.getText().toString()+"'," +"'"+addproject.StartTime.getText()+"'," +"'"+addproject.OverTime.getText()+"',GETDATE()," +"'"+addproject.Description.getText().toString()+"'," +"'"+addproject.projectmark.toString()+"'," +"'"+"1"+"'," + "'"+addproject.ProjectResponsible.getSelectedItem().toString()+"')"; sql.GetConnection(); sql.InsertProject(ProjectText); int flag = JOptionPane.showConfirmDialog(null, "创建新项目成功","确认对话框",JOptionPane.DEFAULT_OPTION); if (flag == 0){ updatetree(); addproject.dispose(); } } }); addproject.CanelButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub addproject.dispose(); } }); //Treepanel.updateUI(); //JOptionPane.showMessageDialog(parentComponent, message, "确认对话框", messageType); } }); //删除项目动作 DelectProject.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent arg0) { // TODO Auto-generated method stub if(JOptionPane.showConfirmDialog(null, "是否删除项目","确认对话框",JOptionPane.OK_CANCEL_OPTION)==0){ DefaultMutableTreeNode Node = (DefaultMutableTreeNode) jTree.getLastSelectedPathComponent(); String selectedNode = Node.toString(); String delectproject = "delete from ProjectsTable where project = " + "'"+selectedNode+"'" +" delete from TasksTable where Projectname = "+"'"+selectedNode+"'"; if(sql.DelectProject(delectproject) == 0){ //删除项目成功后刷新项目列表 updatetree(); JOptionPane.showConfirmDialog(null, "删除项目成功","确认对话框",JOptionPane.DEFAULT_OPTION); } } } }); //添加任务动作 AddTask.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent arg0) { // TODO Auto-generated method stub DefaultMutableTreeNode Node = (DefaultMutableTreeNode) jTree.getLastSelectedPathComponent(); String selectedNode = Node.toString(); ////////添加任务的按钮/////////////////// final AddTaskTextPart addTaskTextPart = new AddTaskTextPart(selectedNode); /////任务添加按钮 addTaskTextPart.OkButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub sql.GetConnection(); sql.InsertTask(addTaskTextPart.TaskName, addTaskTextPart.StartTime, addTaskTextPart.OverTime , addTaskTextPart.EnterTime, addTaskTextPart.Responsible, addTaskTextPart.Posti, addTaskTextPart.picturePath, addTaskTextPart.projectname); int flag = JOptionPane.showConfirmDialog(null, "创建新项目成功","确认对话框",JOptionPane.DEFAULT_OPTION); if (flag == 0){ //添加任务成功后刷新任务列表 TaskPart.getTasksPart(projectname); addTaskTextPart.dispose(); } } }); //取消创建按钮 addTaskTextPart.CanelButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub addTaskTextPart.dispose(); } }); //选择照片按钮 addTaskTextPart.SelectPic.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub JFileChooser fileChooser = new JFileChooser(); // 创建文件对话框 // 创建文件过滤 FileFilter filter = new FileNameExtensionFilter( "图像文件(*.gif;*.jpg;*.jpeg;*.png)", "gif", "jpg", "jpeg", "png"); fileChooser.setFileFilter(filter); // 为文件对话框设置文件过滤器 int returnValue = fileChooser.showOpenDialog(null);// 打开文件选择对话框 if (returnValue =