java程序实现的留言板

import java.applet.*; import java.awt.*; import java.awt.event.*; import java.sql.*; class MyFrame extends Frame implements ActionListener{ String emot[]=new String[3]; Label lab1=new Label("留言板",1); Label lab2=new Label("你"); Label lab3=new Label("地说："); Button btn1=new Button("清屏"); Button btn2=new Button("至顶"); Button btn3=new Button("至底"); Button btn4=new Button("提交"); TextArea tacontent=new TextArea("留言内容:\n"); TextField input; Choice emotion; public MyFrame(String str){ super(str); setSize(640,480); this.setLayout(new BorderLayout()); lab1.setBackground(new Color(230,230,230)); this.add("North",lab1); Panel p1=new Panel(); p1.setLayout(new GridLayout(6,1,40,40)); p1.add(btn1); p1.add(btn2); p1.add(btn3); this.add("East",p1); tacontent.setBackground(new Color(0xff,0xff,0xff)); tacontent.setEditable(false); this.add("Center",tacontent); Panel p2=new Panel(); p2.setBackground(new Color(230,230,230)); p2.setLayout(new FlowLayout()); p2.add(lab2); emotion=new Choice(); readFace(); for(int i=0;i<emot.length;i++){ emotion.add(emot[i]); } p2.add(emotion); p2.add(lab3); input=new TextField(40); input.addKeyListener(new KeyAdapter(){ public void keyPressed(KeyEvent e){ if(e.getKeyChar()=='\n'){ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url= "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=Faces.mdb"; Connection con=DriverManager.getConnection(url,"",""); Statement stmt5=con.createStatement(); Statement stmt6=con.createStatement(); int a=emotion.getSelectedIndex(); String content2=input.getText(); if(!input.getText().isEmpty()){ stmt5.executeUpdate("insert into Msg(Msg_FaceID,Msg_content)values('"+a+"','"+content2+"')"); ResultSet rs5=stmt5.executeQuery("select * from Msg order by Msg_Time desc"); rs5.next(); ResultSet rs6=stmt6.executeQuery("select Face_Text from Face where Face_ID="+(1+rs5.getInt("Msg_FaceID"))+""); while(rs6.next()){ String Showcontent="\n"+rs5.getString("Msg_Time")+""+lab2.getText()+rs6.getString("Face_Text")+lab3.getText()+rs5.getString("Msg_content")+"\n"; tacontent.insert(Showcontent,5); input.setText(""); } } stmt5.close(); stmt6.close(); con.close(); }catch(Exception a){ System.out.println(a.getMessage()); a.printStackTrace(); } } } }); p2.add(input); p2.add(btn4); this.add("South",p2); btn1.addActionListener(this); btn2.addActionListener(this); btn3.addActionListener(this); btn4.addActionListener(this); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url= "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=Faces.mdb"; Connection con=DriverManager.getConnection(url,"",""); Statement stmt3=con.createStatement(); Statement stmt4=con.createStatement(); ResultSet rs3=stmt3.executeQuery("select * from Msg"); while(rs3.next()){ ResultSet rs4=stmt4.executeQuery("select Face_Text from Face where Face_ID="+(1+rs3.getInt("Msg_FaceID"))+""); while(rs4.next()){ String content1="\n"+rs3.getString("Msg_Time")+""+lab2.getText()+rs4.getString("Face_Text")+lab3.getText()+rs3.getString("Msg_content")+"\n"; tacontent.insert(content1,5); } } stmt3.close(); stmt4.close(); con.close(); }catch(Exception a){ System.out.println(a.getMessage()); a.printStackTrace(); } this.addWindowListener(new WindowAdapter(){ public void windowClosing(WindowEvent e){ System.exit(0); } }); } public void readFace(){ int i=0; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=Faces.mdb"; Connection con=DriverManager.getConnection(url,"",""); Statement stmt1=con.createStatement(); String sql1="select * from Face"; ResultSet rs1=stmt1.executeQuery(sql1); while(rs1.next()){ emot[i]=rs1.getString("Face_Text"); i++; } rs1.close(); stmt1.close(); con.close(); }catch(Exception e){ System.out.println(e.getMessage()); e.printStackTrace(); } } public void actionPerformed(ActionEvent e){ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url= "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=Faces.mdb"; Connection con=DriverManager.getConnection(url,"",""); Statement stmt=con.createStatement(); Statement stmt2=con.createStatement(); if(e.getSource()==btn4){ if(!input.getText().isEmpty()){ int k=emotion.getSelectedIndex(); String content=input.getText(); stmt.executeUpdate("insert into Msg(Msg_FaceID,Msg_content)values('"+k+"','"+content+"')"); ResultSet rs2=stmt.executeQuery("select * from Msg order by Msg_Time desc"); rs2.next(); ResultSet r=stmt2.executeQuery("select Face_Text from Face where Face_ID="+(1+rs2.getInt("Msg_FaceID"))+""); while(r.next()){ String Showcontent="\n"+rs2.getString("Msg_Time")+""+lab2.getText()+r.getString("Face_Text")+lab3.getText()+rs2.getString("Msg_content")+"\n"; tacontent.insert(Showcontent,5); input.setText(""); } } } if(e.getSource()==btn1){ tacontent.setText("留言内容："); stmt.executeUpdate("delete * from Msg"); } if(e.getSource()==btn2){ tacontent.setCaretPosition(0); } if(e.getSource()==btn3){ tacontent.setCaretPosition(tacontent.getText().length()); } stmt.close(); stmt2.close(); con.close(); }catch(Exception a){ System.out.println(a.getMessage()); a.printStackTrace(); } } } class Msgboard{ public static void main(String args[]){ MyFrame fr = new MyFrame("留言板"); fr.setVisible(true); } }