第十四周课程总结&实验报告

实验报告

源代码

package 十四周;
import javax.swing .*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.awt.event.WindowListener;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
public class text extends JFrame implements ActionListener{
	JFrame frame;
	JTextArea text;
	JScrollPane scr;
	JMenuBar bar;
	JMenu menu;
	JMenu edit;
	JMenuItem newi;
	JMenuItem openi;
	JMenuItem savei;
	JMenuItem closei;
	JMenuItem exiti;
	JMenuItem cut;
	JMenuItem copy;
	JMenuItem paste;
	JMenuItem selectAll;
	ImageIcon image1;
	ImageIcon image2;
	ImageIcon image3;
	ImageIcon image4;
	ImageIcon image5;
	JFileChooser chooser;
	File file;
	FileInputStream fil;
	FileOutputStream fol;
	
public  text() {
	frame = new JFrame("ZG");
    text = new JTextArea();
    scr = new JScrollPane(text);
    
    image1 = new ImageIcon("D:"+File.separator+"Java"+File.separator+"picture图标"+File.separator+"新建.png");
    image2 = new ImageIcon("D:"+File.separator+"Java"+File.separator+"picture图标"+File.separator+"打开.png");
    image3 = new ImageIcon("D:"+File.separator+"Java"+File.separator+"picture图标"+File.separator+"另存为.png");
    image4 = new ImageIcon("D:"+File.separator+"Java"+File.separator+"picture图标"+File.separator+"关闭.jpg");
    image5 = new ImageIcon("D:"+File.separator+"Java"+File.separator+"picture图标"+File.separator+"退出.jpg");
    
    bar = new JMenuBar();
    menu = new JMenu("文件");
    edit = new JMenu("编辑");
    newi = new JMenuItem("新建",image1);
    openi = new JMenuItem("打开",image2);
    savei = new JMenuItem("另存为",image3);
    closei = new JMenuItem("关闭",image4);
    exiti = new JMenuItem("退出",image5);
    cut = new JMenuItem("剪切(T)");
    copy = new JMenuItem("复制(C)");
    paste = new JMenuItem("粘贴(V)");
    selectAll = new JMenuItem("全选(A)");
    
   
    text.setEditable(true);
    frame.getContentPane().add(scr);
    
    newi.setMnemonic('N');
    openi.setMnemonic('O');
    closei.setMnemonic('Z');
    exiti.setMnemonic('E');
    cut.setMnemonic('T');
    copy.setMnemonic('C');
    paste.setMnemonic('V');
    selectAll.setMnemonic('A');
    
    newi.setAccelerator(KeyStroke.getKeyStroke('N',java.awt.Event.CTRL_MASK));
    openi.setAccelerator(KeyStroke.getKeyStroke('O',java.awt.Event.CTRL_MASK));
    savei.setAccelerator(KeyStroke.getKeyStroke('S',java.awt.Event.CTRL_MASK));
    closei.setAccelerator(KeyStroke.getKeyStroke('Z',java.awt.Event.CTRL_MASK));
    exiti.setAccelerator(KeyStroke.getKeyStroke('E',java.awt.Event.CTRL_MASK));
    cut.setAccelerator(KeyStroke.getKeyStroke('T',java.awt.Event.CTRL_MASK));
    copy.setAccelerator(KeyStroke.getKeyStroke('C',java.awt.Event.CTRL_MASK));
    paste.setAccelerator(KeyStroke.getKeyStroke('V',java.awt.Event.CTRL_MASK));
    selectAll.setAccelerator(KeyStroke.getKeyStroke('A',java.awt.Event.CTRL_MASK));
    
    newi.addActionListener(this);
    openi.addActionListener(this);
    savei.addActionListener(this);
    closei.addActionListener(this);
    exiti.addActionListener(this);
    cut.addActionListener(this);
    copy.addActionListener(this);
    paste.addActionListener(this);
    selectAll.addActionListener(this);
    
    
    menu.add(newi);
    menu.add(openi);
    menu.add(savei);
    menu.add(closei);
    menu.add(exiti);
    edit.add(cut);
    edit.add(copy);
    edit.add(paste);
    edit.add(selectAll);
    edit.addSeparator();
    bar.add(menu);
    bar.add(edit);
    
    frame.addWindowListener(new MyWindowAdapter());
    
    frame.setJMenuBar(bar);
    
    frame.setSize(600, 500);
    frame.setLocation(300,200);
    frame.setVisible(true);
}
@Override
public void actionPerformed(ActionEvent e) {
    file =null;
    Object obj = e.getSource();
    if(obj instanceof JMenuItem) {
        JMenuItem item = (JMenuItem)obj;
        if(item == newi) {
            new text();
        }else if(item == openi) {
            chooser = new JFileChooser();
            chooser.showSaveDialog(null);
            file = chooser.getSelectedFile();
            try {
                fil = new FileInputStream(file);
                byte[] b = new byte[fil.available()];
                fil.read(b);
                String str = new String(b);
                text.append(str);
                fil.close();
            } catch (FileNotFoundException e1) {
                e1.printStackTrace();
            } catch (IOException e1) {
                e1.printStackTrace();
            }
        }else if(item == savei) {
            chooser = new JFileChooser();
            chooser.showSaveDialog(null);
            file = chooser.getSelectedFile();
            
                try {
                    if(!file.exists()) {
                       file.createNewFile();
                    }
                    fol = new FileOutputStream(file);
                    byte[] b = text.getText().getBytes();
                    fol.write(b);
                    fol.close();
                } catch (IOException e1) {
                    e1.printStackTrace();
                }
            
        }else if(item == closei){
            System.exit(1);
        }else if(item==cut) {
            text.cut();
        }else if(item==copy) {
            text.copy();
        }else if(item==paste) {
            text.paste();
        }else if(item==selectAll) {
            text.selectAll();
        }
    }
    
}

}

运行结果

新建

打开

另存为

编辑功能

课程总结

一、什么是JDBC:

.JDBC全称Java Database Connectivity
.JDBC可以通过载入不同的数据库的“驱动程序”而与不同的数据库进行连接。

二、JDBC的使用：

1.导入对应数据库的驱动类:

.在对应的数据库厂商网站获取对应的jar包
.将对应的jar包添加到引用。

2.加载驱动：

public static final String DBDRIVER = "org.gjt.mm.mysql.Driver"; 
Class.forName(DBDRIVER);  

3.获取连接：

Connection conn = null;
conn = DriverManager.getConnetion()；

4.执行SQL语句：

.使用Statement执行sql语句

5.关闭连接：

.后开启的需要先关闭，Statement、Connection、ResultSet都是需要关闭的
.注意：关闭之前需要留心检查是否为null