Java操作MySQL数据库示例

准备：

1. NetBeans IDE

2. MySQL

3. NetBeans IDE连接好MySQL服务

4. 在NetBeans IDE中新建一个项目，并在该项目引用的库中添加mysql-connector-java的jar包

5. java项目代码如下：

package mysql_test;

import com.mysql.jdbc.Driver;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;

/**
 *
 * @author Administrator
 */
public class MySQL_Test {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
        Connection conn=null;
        String sql;
        String url="jdbc:mysql://localhost:3306/users?user=root&password=admin&useUnicode=true&charaterEncoding=UTF8";
        try {
            Class.forName("com.mysql.jdbc.Driver");
            //com.mysql.jdbc.Driver driver = new com.mysql.jdbc.Driver();
            //new com.mysql.jdbc.Driver();
            conn=DriverManager.getConnection(url);
            System.out.println("成功加载MySQL驱动程序");
            Statement stmt=conn.createStatement();
            //插入新数据
            sql="INSERT INTO userinformation (username,password) VALUES ('UFO PERSON','PASSWORD YOU DONT KNOW')";
            int result=stmt.executeUpdate(sql);
            if(result!=-1){
                System.out.println("插入数据成功");
            }else{
                System.out.println("插入数据不成功");
            }
            sql="SELECT * FROM userinformation";
            ResultSet rs=stmt.executeQuery(sql);
            System.out.println("id\tusername\tpassword\tlevel\t\n");
            String rsMessage="";
            //显示记录数据
            while(rs.next()){       
                rsMessage+=rs.getInt(1)+" \n";
                System.out.println(rs.getInt(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getInt(4)+"\t");
            } 
            JOptionPane.showMessageDialog(null,rsMessage); 
            //删除记录数据
            sql="DELETE FROM userinformation WHERE id>20";
            result=stmt.executeUpdate(sql);
            if(result!=-1){
                System.out.println("删除成功");
            }else{
                System.out.println("删除不成功");
            }
            
        } catch (SQLException | ClassNotFoundException ex) {
            Logger.getLogger(MySQL_Test.class.getName()).log(Level.SEVERE, null, ex);
        }
        
    }
    
}