GUI界面连接Mysql数据库

                                                   GUI界面连接Mysql数据库

GUI程序不仅界面美观，而且使用方便，各种软件的操作上也可统一，本实验通过Java来编写GUI程序。Java提供了编写GUI程序所需要的各种类，其中在本次实验中用到了java swing 用来设计登录、注册、修改密码、删除用户等界面，其中还用到了ActionListener接口来监听界面内的组件事件，用来触发事件作出反应。其中在本实验中我给主框的背景设置了绿色背景，并且增加了一个重复密码框，为了保证信息的安全性。button设计了不同的功能，如弹出dialog对话框、调用新的JFrame界面，通过GUI程序实现了图形化界面，然后在本实验中利用Mysql数据库，建立了数据库通过JDBC实现了GUI界面连接数据库，并对数据库中的内容进行查询等操作。

源码如下：

——————————————————————————ZJdbcs——————————

package chunlan;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.swing.JOptionPane;

public class ZJdbcs {

         Connection con = null;

         Statement statement = null;

         ResultSet res = null;

         String driver = "com.mysql.jdbc.Driver";

         String url  = "jdbc:mysql://localhost:3306/zhangchunlan";

         String name = "root";

         String passwd = "123456";        

         public ZJdbcs() {

                   try{

                   Class.forName(driver).newInstance();

                   con = DriverManager.getConnection(url,name,passwd);

                   statement = con.createStatement();

                   }

                   catch(ClassNotFoundException e){

                            System.out.println("对不起，找不到这个Driver");

                            e.printStackTrace();

                            e.printStackTrace();

                   }

                   catch(Exception e){

                            e.printStackTrace();

                   }

                  

         }

         public boolean update(String username,String password1,String newpassword ){

                   boolean judge = false;

                   boolean s = compare(username,password1);

             if(s){

                      String sql = "update user set password=\""+newpassword+"\"where username=\""+username+"\"";

                      try{

                                int a = statement.executeUpdate(sql);

                               

                                if(a==1){

                                          JOptionPane.showMessageDialog(null,"密码修改成功！");

                                          judge = true;   

                                }

                               

                      }

                      catch (SQLException e){

                                JOptionPane.showMessageDialog(null, "用户不存在！");

                      }

             }

             else{         

                      JOptionPane.showMessageDialog(null, "修改失败");  

             }

                   return judge;

         }

         public void delete(String username,String password){

                   if(compare(username,password)){

                            JOptionPane.showMessageDialog(null, "已经完成删除");

                   }

                   else{

                            return ;

                   }

                   String sql="delete from user where username=\""+username+"\"";

             try{

                      int a=statement.executeUpdate(sql);

                     

             }

                   catch(SQLException e){