java jdbc实现增删改查实例,如何实现?

KLQ 2020-07-03 14:52:17 java常见问答 8431

你知道java jdbc如何实现增删改查吗?下面要给大家分享的就是这个方面的一个实例,一起来了解一下吧!

jdbc实现增删改查:

增删改操作

package java_web;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
/**
 * jdbc CURD
 * @author Administrator
 *
 */
public class rbacDemo
{
    public final static String URL = "jdbc:mysql://localhost:3306/test";
    public final static String USERNAME = "root";
    public final static String PASSWORD = "";
    public final static String DRIVER = "com.mysql.jdbc.Driver";
    /**
     * 插入
     */
    public static void insert()
    {
        try
        {
            Class.forName(DRIVER);
            Connection conn = (Connection) DriverManager.getConnection(URL, USERNAME, PASSWORD);
            String sql = "insert into test(name,sex)values('fifi2',1),('fifi3',3)";
            Statement state = (Statement) conn.createStatement();
            int result = state.executeUpdate(sql);
            state.close();
            conn.close();
            System.out.println(result + "success");
        }
        catch (ClassNotFoundException e)
        {
            // TODO 自动生成的 catch 块
            e.printStackTrace();
        }
        catch (SQLException e)
        {
            // TODO 自动生成的 catch 块
            e.printStackTrace();
        }
    }
    public static void update()
    {
        try
        {
            Class.forName(DRIVER);
            Connection conn = (Connection) DriverManager.getConnection(URL, USERNAME, PASSWORD);
            String sql = "update test set name='fifi3aaa' where name='fifi3'";
            Statement state = (Statement) conn.createStatement();
            int result = state.executeUpdate(sql);
            state.close();
            conn.close();
            System.out.println(result + "success");
        }
        catch (ClassNotFoundException e)
        {
            // TODO 自动生成的 catch 块
            e.printStackTrace();
        }
        catch (SQLException e)
        {
            // TODO 自动生成的 catch 块
            e.printStackTrace();
        }
    }
    public static void delete()
    {
        try
        {
            Class.forName(DRIVER);
            Connection conn = (Connection) DriverManager.getConnection(URL, USERNAME, PASSWORD);
            String sql = "delete from test where name='fifi3aaa'";
            Statement state = (Statement) conn.createStatement();
            int result = state.executeUpdate(sql);
            state.close();
            conn.close();
            System.out.println(result + "success");
        }
        catch (ClassNotFoundException e)
        {
            // TODO 自动生成的 catch 块
            e.printStackTrace();
        }
        catch (SQLException e)
        {
            // TODO 自动生成的 catch 块
            e.printStackTrace();
        }
    }
    public static void main(String[] args)
    {
        //insert();
        //update();
        delete();
    }
}

查询操作

package java_web;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
public class jdbcQueryDemo
{
    public final static String URL = "jdbc:mysql://localhost:3306/test";
    public final static String USERNAME = "root";
    public final static String PASSWORD = "";
    public final static String DRIVER = "com.mysql.jdbc.Driver";
    public static void query()
    {
        try
        {
            Class.forName(DRIVER);
            Connection conn = (Connection) DriverManager.getConnection(URL, USERNAME, PASSWORD);
            String sql = "select id,name,sex from test where id=3";
            Statement state = (Statement) conn.createStatement();
            ResultSet rs = state.executeQuery(sql);
            while (rs.next())
            {
                //rs.getInt("id");
                int id = rs.getInt(1);
                String name = rs.getString(2);
                int sex = rs.getInt(3);
                //String time=rs.getString("vtime");
                System.out.println(id + "==" + name + "==" + sex + "==");
            }
            rs.close();
            state.close();
            conn.close();
        }
        catch (ClassNotFoundException e)
        {
            // TODO 自动生成的 catch 块
            e.printStackTrace();
        }
        catch (SQLException e)
        {
            // TODO 自动生成的 catch 块
            e.printStackTrace();
        }
    }
    public static void main(String[] args)
    {
        // TODO 自动生成的方法存根
        query();
    }
}

java用jdbc编写增删改查的内容你都了解了吗?这个还是比较简单的,更多的java程序代码例子,可以继续通过奇Q工具网来进行了解呢。

推荐阅读:

java jdbc和odbc的区别是什么?jdbc和odbc的关系是怎样的?

mysql数据库增删改查语法有哪些?总结

SQL语句增删改查有哪些方法?要怎么实现?