详细编写：Java面向控台的小案例-----通过jdbc操作数据库（单表）的不同写法

最新推荐文章于 2024-10-05 12:07:50 发布

qq_48914330

最新推荐文章于 2024-10-05 12:07:50 发布

阅读量72

点赞数

文章标签： java Powered by 金山文档

本文链接：https://blog.csdn.net/qq_48914330/article/details/129464946

版权

一、方式一：不进行封装

public class T_userTest {
    public static void main(String[] args) {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            DriverManager.registerDriver(new Driver());
            Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/jdbc1", "root", "123456");
            String sql1="select * from t_user;";
            String sql2="insert into t_user(account,PASSWORD,nickname) values(?,?,?)";
            String  sql3="delete from t_user where id=?;";
            String sql4="update t_user set nickname=? where id=?;";
            PreparedStatement preparedStatement = connection.prepareStatement(sql1);
            PreparedStatement preparedStatement2 = connection.prepareStatement(sql2);
            PreparedStatement preparedStatement3 = connection.prepareStatement(sql3);
            PreparedStatement preparedStatement4 = connection.prepareStatement(sql4);
            //实现查询数据库中数据功能
            ResultSet resultSet = preparedStatement.executeQuery();
            while(resultSet.next()){
                System.out.println(resultSet.getInt("id")+"---"+resultSet.getString("account")+"---"+resultSet.getString("PASSWORD")+"---"+resultSet.getString("nickname"));
            }

            //实现控制台插入数据到数据库的功能
            Scanner scanner = new Scanner(System.in);
            System.out.println("请输入插入的信息：");
            String account = scanner.nextLine();
            String password = scanner.nextLine();
            String nickname = scanner.nextLine();
            preparedStatement2.setObject(1,account);
            preparedStatement2.setObject(2,password);
            preparedStatement2.setObject(3,nickname);
            int i = preparedStatement2.executeUpdate();
            if(i>0){
                System.out.println("插入成功");
            }else{
                System.out.println("插入失败");
            }

            //实现控制台删除数据库中数据的功能
            System.out.println("请输入删除的id号：");
            int id = scanner.nextInt();
            preparedStatement3.setObject(1,id);
            int i1 = preparedStatement3.executeUpdate();
            if(i1>0){
                System.out.println("删除成功");
            }else{
                System.out.println("删除失败");
            }


            //实现控制台修改数据库中数据的功能
            System.out.println("请输入修改的nickname：");
            String newnickname = scanner.nextLine();
            System.out.println("请输入修改的信息id：");
            int id1 = scanner.nextInt();
            preparedStatement4.setObject(1,newnickname);
            preparedStatement4.setObject(2,id1);

            int i2 = preparedStatement4.executeUpdate();
            if(i2>0){
                System.out.println("修改成功");
            }else{
                System.out.println("修改失败");
            }

            System.out.println("最终数据库的数据为：");
            while(resultSet.next()){
                System.out.println(resultSet.getInt("id")+"---"+resultSet.getString("account")+"---"+resultSet.getString("PASSWORD")+"---"+resultSet.getString("nickname"));
            }

        } catch (Exception e) {
            e.printStackTrace();
        }

    }
}

二、方式二：封装连接工具类、封装增、删、查、改等方法进行调用

配置信息文件jdbc.properties

#该文件是一个配置文件
#我们可以在该文件里面完成一些配置信息在通过Java程序
#key=valued的形式配置信息
# 配置数据库连接信息

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/jdbc1
name=root
password=123456

连接工具类

public class JDBC_Utiles_1 {
    private static String user;
    private static String url;
    private static String password;
    static {
        InputStream stream=null;
        Properties properties=null;
        try {
            stream = JDBC_Utiles_1.class.getClassLoader().getResourceAsStream("jdbc.properties");
            properties = new Properties();
            properties.load(stream);
            user = properties.getProperty("user");
            password = properties.getProperty("password");
            url = properties.getProperty("url");
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            try {
                stream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
    public static Connection getConnection(){
        Connection connection=null;
        try {
            connection= DriverManager.getConnection(url, user, password);

        } catch (SQLException e) {
            e.printStackTrace();
        }
        return connection;
    }

    public static void closeAll(Connection connection, PreparedStatement preparedStatement, ResultSet resultSet){
        try {
            if(connection !=null){
                connection.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

            try {
                if(preparedStatement!=null){
                preparedStatement.close();}
            } catch (SQLException e) {
                e.printStackTrace();
            }

        try {
            if(resultSet!=null){
                resultSet.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static void closAll(Connection connection, PreparedStatement preparedStatement){
        try {
            if(connection !=null){
                connection.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

        try {
            if(preparedStatement!=null){
                preparedStatement.close();}
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

增、删、查、改功能的方法

public class Mothed {
    //插入数据
    public void testInster()  {
        Connection connection = getConnection();
        PreparedStatement preparedStatement = null;
        try {
            String sql="insert into t_user(account,PASSWORD,nickname) values(?,?,?)";
            preparedStatement = connection.prepareStatement(sql);
            Scanner scanner = new Scanner(System.in);
            System.out.println("请输入插入的信息：");
            String account = scanner.nextLine();
            String password = scanner.nextLine();
            String nickname = scanner.nextLine();
            preparedStatement.setObject(1,account);
            preparedStatement.setObject(2,password);
            preparedStatement.setObject(3,nickname);
            int i = preparedStatement.executeUpdate();
            if(i>0){
                System.out.println("插入成功");
            }else{
                System.out.println("插入失败");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    
    //修改数据
    public void testUpdate()  {
        Connection connection = getConnection();
        PreparedStatement preparedStatement = null;
        try {

            String sql="update t_user set nickname=? where id=?;";
            Scanner scanner = new Scanner(System.in);
            System.out.println("请输入修改的nickname：");
            String newnickname = scanner.nextLine();
            System.out.println("请输入修改的信息id：");
            preparedStatement = connection.prepareStatement(sql);
            int id1 = scanner.nextInt();
            preparedStatement.setObject(1,newnickname);
            preparedStatement.setObject(2,id1);

            int i2 = preparedStatement.executeUpdate();
            if(i2>0){
                System.out.println("修改成功");
            }else{
                System.out.println("修改失败");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            //关闭资源
            closAll(connection,preparedStatement);
        }

    }
    //删除数据
    public void testDelte() {
        Connection connection = getConnection();

        PreparedStatement preparedStatement = null;
        try {
            String  sql="delete from t_user where id=?;";
            preparedStatement = connection.prepareStatement(sql);
            System.out.println("请输入删除的id号：");
            Scanner scanner = new Scanner(System.in);
            int id = scanner.nextInt();
            preparedStatement.setObject(1,id);
            int i1 = preparedStatement.executeUpdate();
            if(i1>0){
                System.out.println("删除成功");
            }else{
                System.out.println("删除失败");
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            //关闭资源
            closAll(connection,preparedStatement);
        }
    }
    //查看数据
    public void testSelect()  {
        Connection connection = getConnection();

        PreparedStatement preparedStatement = null;
        ResultSet resultSet=null;
        try {
            String sql="select * from t_user;";
            preparedStatement = connection.prepareStatement(sql);
            resultSet = preparedStatement.executeQuery();
            while(resultSet.next()){
                System.out.println(resultSet.getInt("id")+"---"+resultSet.getString("account")+"---"+resultSet.getString("PASSWORD")+"---"+resultSet.getString("nickname"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            //关闭资源
            closeAll(connection,preparedStatement,resultSet);
        }

    }
}

调用方法

public class Test {
    public static void main(String[] args) {
        Mothed mothed = new Mothed();
        //调用查询方法
        mothed.testSelect();
        //调用插入方法
        mothed.testInster();
        //调用修改方法
        mothed.testUpdate();
        //调用删除方法
        mothed.testDelte();
    }
}