Java中对mysql的简单操作

数据库的操作

数据库几大步骤：

//1. 导入外部的驱动包

          //2. 加载驱动

          Class.forName("com.mysql.jdbc.Driver");

          //3. 建立连接     url:全球资源定位

          Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/wang", "root", "123456");

          String sql = "select * from student";

          //4. 创建PreparedStatement对象

          PreparedStatement ps = conn.prepareStatement(sql);

                  //5. 关闭数据库连接

ps.close();

          conn.close();

 

添加数据库时候解决数据库存汉子乱码问题：
在连接时候添加编码方式：

Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/wang?useUnicode=true&characterEncoding=utf-8", "root", "123456");

 

 

 

增加数据：

package com.exp1;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;



public class InsertTest {



     public static void main(String[] args) throws ClassNotFoundException, SQLException {

          //1. 导入外部的驱动包

          //2. 加载驱动

          Class.forName("com.mysql.jdbc.Driver");

          //3. 建立连接     url:全球资源定位

          //Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/wang", "root", "123456");         

          String sql = "insert into student values(?, ?, ?)";

          //4. 创建PreparedStatement对象

          PreparedStatement ps = conn.prepareStatement(sql);

         

          ps.setInt(1, 6);

          ps.setString(2, "傻炎");

          ps.setInt(3, 25);

          int i = ps.executeUpdate();

          System.out.println("添加成功！");

          ps.close();

          conn.close();

     }

}

 

删除数据：

核心代码：

String sql = "delete from student where name = ? ";

          //创建PreparedStatement对象

          PreparedStatement ps = conn.prepareStatement(sql);

          ps.setString(1, "傻炎");

          int i = ps.executeUpdate();

 

查看数据：

package com.exp1;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;



public class Test {



     public static void main(String[] args) throws ClassNotFoundException, SQLException {

          //1. 导入外部的驱动包

          //2. 加载驱动

          Class.forName("com.mysql.jdbc.Driver");

         

          //3. 建立连接     url:全球资源定位

          Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/wang", "root", "123456");

          String sql = "select * from student";

          //4. 创建PreparedStatement对象

          PreparedStatement ps = conn.prepareStatement(sql);

          //5. 执行并获得结果集

          ResultSet rs = ps.executeQuery();

         

          while(rs.next()){

               System.out.println(rs.getInt(1)+"------"+rs.getString(2)+"-----"+rs.getInt(3));

          }

              

          rs.close();

          ps.close();

          conn.close();

     }

}

 

 

修改数据：

核心代码：

String sql = "update student set age = ? where name = ?";

          //创建PreparedStatement对象

          PreparedStatement ps = conn.prepareStatement(sql);

          ps.setInt(1, 58);

          ps.setString(2, "傻炎");

          int i = ps.executeUpdate();

          System.out.println("修改成功！");