JDBC增删改

即事随缘

于 2021-06-15 13:50:01 发布

阅读量145

点赞数

文章标签： jdbc

本文链接：https://blog.csdn.net/qq_48692860/article/details/117922902

版权

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
//PreparedStatement插入
public class JDBC
{
    public static void main(String[] args)
	{
        connection conn = null ;
        PreparedStatement ps = null ;
        try{
            //1、注册驱动
            class.forName("com.mysql.jdbc.Driver");
            //2、获取连接
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/lsj","root","333");
            //3、获取预编译的数据库操作对象
            String sql = "insert into dept(deptno,dname,loc) values(?,?,?)";
            ps = conn.prepareStatement(sql);
            ps.setInt(1,60);
            ps.setString(2,"销售部");
            ps.setString(3,"上海");
            //4、执行SQL
            int count = ps.executeUpdate();
            System.out.println(count);
        }catch(Exception e)
        {
            e.printStackTrace();
        }finally{
            //6、释放资源
            if(ps != null)
            {
                try{
                    ps.close();
                }catch(SQLException e){
                    e.printStackTrace();
                }
            }
            if(conn != null)
            {
                try{
                    conn.close();
                }catch(SQLException e){
                    e.printStackTrace();
                }
            }
        }
    }
}

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
//PreparedStatement更新
public class JDBC
{
    public static void main(String[] args)
	{
        connection conn = null ;
        PreparedStatement ps = null ;
        try{
            //1、注册驱动
            class.forName("com.mysql.jdbc.Driver");
            //2、获取连接
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/lsj","root","333");
            //3、获取预编译的数据库操作对象
            String sql = "update dept set dname = ? , loc = ? where deptno = ?";
            ps = conn.prepareStatement(sql);
            ps.setString(1,"研发一部");
            ps.setString(2,"北京");
            ps.setInt(3,60);
            //4、执行SQL
            int count = ps.executeUpdate();
            System.out.println(count);
        }catch(Exception e)
        {
            e.printStackTrace();
        }finally{
            //6、释放资源
            if(ps != null)
            {
                try{
                    ps.close();
                }catch(SQLException e){
                    e.printStackTrace();
                }
            }
            if(conn != null)
            {
                try{
                    conn.close();
                }catch(SQLException e){
                    e.printStackTrace();
                }
            }
        }
    }
}

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
//PreparedStatement删除
public class JDBC
{
    public static void main(String[] args)
	{
        connection conn = null ;
        PreparedStatement ps = null ;
        try{
            //1、注册驱动
            class.forName("com.mysql.jdbc.Driver");
            //2、获取连接
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/lsj","root","333");
            //3、获取预编译的数据库操作对象
            String sql = "delete from dept where deptno = ?";
            ps = conn.prepareStatement(sql);
            ps.setInt(1,60);
            //4、执行SQL
            int count = ps.executeUpdate();
            System.out.println(count);
        }catch(Exception e)
        {
            e.printStackTrace();
        }finally{
            //6、释放资源
            if(ps != null)
            {
                try{
                    ps.close();
                }catch(SQLException e){
                    e.printStackTrace();
                }
            }
            if(conn != null)
            {
                try{
                    conn.close();
                }catch(SQLException e){
                    e.printStackTrace();
                }
            }
        }
    }
}