Java操作MySQL数据库示例

来源：互联网发布：广东红松网络怎么样编辑：程序博客网时间：2024/06/05 15:10

准备：

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);        }            }    }

0 0