java课程设计报告-管理系统--记事本.doc

贵州师范大学职业技术学院10计应班Java课程设计报告Java课程设计报告课程名称：java课程设计 设计题目：管理系统 记事本 专业班级：计算机工程系 10计应班姓 名： 学 号：1 指导教师： 设计时间：2011.12.1912.30 目录一、管理信息系统2（一）主要类的设计2（二）功能分析2（三）功能图2（四）源程序代码与运行窗口2（1）登陆界面2（2）注册登陆界面6(3）用户界面9二、记事本11(一) 需求分析11（二）概要设计11（三）源程序代码与运行窗口12（1）记事本主窗口12（2）字体字号18（3）查找21四、聊天室22（一）设计思路22（二）源程序代码与运行端口22三、实训体会与小结28五、附录29一、管理信息系统（一）主要类的设计加载JDBC驱动程序1. 使用Class.forName() 语法：Class.forName(驱动程序名称);2. 使用DriverManager.registerDriver()DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver();DriverManager类 Connection接口 Statement接口 PreparedStatement接口 CallableStatement接口 ResultSet接口 ResultSetMetaData接口 DatabaseMetaData接口（二）功能分析实现从登陆界面连接数据库，登陆、注册（三）功能图打开登录界面连接数据库用户界面注册界面连接数据库写入用户信息（四）源程序代码与运行窗口（1）登陆界面a源代码：/import java.beans.Statement;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class NewJFrame extends javax.swing.JFrame private void initComponents() jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jButton1 = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); jButton3 = new javax.swing.JButton(); jTextField1 = new javax.swing.JTextField(); jTextField2 = new javax.swing.JTextField(); jLabel3 = new javax.swing.JLabel(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jLabel1.setText(用户名：); jLabel2.setText(密码：); jButton1.setText(登陆); jButton1.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent evt) jButton1ActionPerformed(evt); ); jButton2.setText(重置); jButton2.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent evt) jButton2ActionPerformed(evt); ); jButton3.setText(注册); jButton3.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent evt) jButton3ActionPerformed(evt); ); jTextField1.setText(请输入用户名); jTextField2.setText(请输入密码); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane(); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup() .addGap(76, 76, 76) .addComponent(jButton1) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup() .addGap(66, 66, 66) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel2) .addComponent(jLabel1) .addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jTextField2) .addComponent(jTextField1, javax.swing.GroupLayout.DEFAULT_SIZE, 213, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(layout.createSequentialGroup() .addComponent(jButton2) .addGap(38, 38, 38) .addComponent(jButton3) .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 256, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(55, Short.MAX_VALUE) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(61, 61, 61) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel1) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel2) .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(67, 67, 67) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton1) .addComponent(jButton3) .addComponent(jButton2) .addGap(18, 18, 18) .addComponent(jLabel3) .addContainerGap(71, Short.MAX_VALUE) ); pack(); / private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) jTextField1.setText(); jTextField2.setText(); jLabel3.setText(); / TODO add your handling code here: private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch(ClassNotFoundException e) e.printStackTrace(); try Connection con=DriverManager.getConnection(jdbc:odbc:sa); Statement stmt=(Statement) con.createStatement(); String sqlstr=select * from Table1; ResultSet rs=stmt.executeQuery(sqlstr); int a=0; while(rs.next() if(rs.getString(1).trim().equalsIgnoreCase(jTextField1.getText()&rs.getString(2).trim().equalsIgnoreCase(jTextField2.getText() a=1; if(a=1) jLabel3.setText(登录.); this.setVisible(false); new NewJFrame1().setVisible(true); / NewJFrame().setVisible(false); / NewJFrame1().setVisible(true); else jLabel3.setText(你的用户名或密码有误！); con.close(); catch(Exception e) e.printStackTrace(); private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) jLabel3.setText(欢迎进入注册界面。); this.setVisible(false); new NewJFrame2().setVisible(true); public static void main(String args) java.awt.EventQueue.invokeLater(new Runnable() public void run() new NewJFrame().setVisible(true); ); private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JButton jButton3; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JTextField jTextField1; private javax.swing.JTextField jTextField2;b窗口（2）注册登陆界面a.源代码import java.beans.Statement;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;public class NewJFrame2 extends javax.swing.JFrame /* Creates new form NewJFrame2 */ public NewJFrame2() initComponents(); private void initComponents() jButton1 = new javax.swing.JButton(); jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jButton2 = new javax.swing.JButton(); jTextField1 = new javax.swing.JTextField(); jLabel4 = new javax.swing.JLabel(); jPasswordField1 = new javax.swing.JPasswordField(); jPasswordField2 = new javax.swing.JPasswordField(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jButton1.setText(确认); jButton1.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent evt) jButton1ActionPerformed(evt); ); jLabel1.setText(用户名); jLabel2.setText(密码); jLabel3.setText(确认密码); jButton2.setText(返回); jButton2.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent evt) jButton2ActionPerformed(evt); ); jTextField1.setText(用户名由数字，字母组成); jTextField1.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent evt) jTextField1ActionPerformed(evt); ); jPasswordField1.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent evt) jPasswordField1ActionPerformed(evt); ); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane(); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup() .addGap(35, 35, 35) .addComponent(jLabel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup() .addGap(26, 26, 26) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel1) .addComponent(jLabel2) .addComponent(jLabel3) .addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jTextField1, javax.swing.GroupLayout.DEFAULT_SIZE, 211, Short.MAX_VALUE) .addComponent(jPasswordField1) .addComponent(jPasswordField2) .addGroup(layout.createSequentialGroup() .addGap(120, 120, 120) .addComponent(jButton1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton2) .addContainerGap(91, Short.MAX_VALUE) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addGap(43, 43, 43) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel1) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(29, 29, 29) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel2) .addComponent(jPasswordField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(38, 38, 38) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel3) .addComponent(jPasswordField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 49, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton2) .addComponent(jButton1) .addGap(18, 18, 18) .addComponent(jLabel4) .addGap(49, 49, 49) ); pack(); private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) this.setVisible(false); new NewJFrame().setVisible(true); private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) String username=jTextField1.getText().trim(); String userpassword=String.valueOf(jPasswordField1.getPassword(); String userpassword1=String.valueOf(jPasswordField2.getPassword(); try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch(ClassNotFoundException e) e.printStackTrace(); try Connection con=DriverManager.getConnection(jdbc:odbc:sa); java.sql.Statement stmt= con.createStatement(); String sqlstr=select * from Table1; ResultSet rs=stmt.executeQuery(sqlstr); int a=0; while(rs.next() if(rs.getString(1).trim().equalsIgnoreCase(username) a=1; if(a=1) jLabel4.setText(账号已存在！); else if( userpassword.equalsIgnoreCase(userpassword1) String sql=insert Table1 values(+username+,+userpassword+); jLabel4.setText(注册成功！); else jLabel4.setText(上下密码不相同！); con.close(); catch(Exception e) e.printStackTrace(); private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) private void jPasswordField1ActionPerformed(java.awt.event.ActionEvent evt) public static void main(String args) java.awt.EventQueue.invokeLater(new Runnable() public void run() new NewJFrame2().setVisible(true); ); / Variables declaration - do not modify private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JPasswordField jPasswordField1; private javax.swing.JPasswordField jPasswordField2; private javax.swing.JTextField jTextField1; / End of variables declaration b.窗口(3）用户界面a.源代码public class NewJFrame1 extends javax.swing.JFrame public NewJFrame1() initComponents(); SuppressWarnings(unchecked) private void initComponents() jScrollPane1 = new javax.swing.JScrollPane(); jList1 = new javax.swing.JList(); jTextField1 = new javax.swing.JTextField(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jList1.setModel(new javax.swing.AbstractListModel() String strings = Item 1, Item 2, Item 3, Item 4, Item 5 ; public int getSize() return strings.length; public Object getElementAt(int i) return stringsi; ); jScrollPane1.setViewportView(jList1); jTextField1.setText(jTextField1); javax.swing.Grou