JavaWeb课程复习资料——idea创建JDBC

墨蓝 2024-02-19 09:14 9阅读 0赞

#### 1、创建空的Java Project ####

![在这里插入图片描述][c27c2599edad40fd8f6ff0625e73d9a6.png_pic_center]

**输入项目名称**  
![在这里插入图片描述][10fc82392b6945eca7f0fb08d1171518.png_pic_center]

**空项目**

![在这里插入图片描述][cb1f2c8916614f7681dd0eabf7aeea2b.png_pic_center]

#### 2、引入jar包步骤 ####

依次点击 File -> Project Structure（快捷键 Ctrl + Alt + Shift + s），点击Project Structure界面左侧的“Modules”如图：

![在这里插入图片描述][b13ee2c7c4894f76a74d21b958bd22d0.png_pic_center]

![在这里插入图片描述][92e293bce3a94c93b1d9d0c849dbcbf7.png_pic_center]

在 【Dependencies】 标签界面下，点击左边的 “+”号，选择第一个选项“JARs or directories…”，选择相应的jar包，点“OK”，jar包添加成功

![在这里插入图片描述][8d0e0fb75da044ec8103d6243aa53657.png_pic_center]  
获取驱动包：  
链接：https://pan.baidu.com/s/1VQvpbcsYska\_i5JVOCMxqg  
提取码：yyds

![在这里插入图片描述][e874c485f2e948a4accd78ab3b0dced5.png_pic_center]

![在这里插入图片描述][eaf74d58806842979170e815459c982e.png_pic_center]

#### 3、驱动位置 ####

【com.mysql.jdbc.Driver】

private static final String URL = "jdbc:mysql://localhost:3306/test?useUnicode&CharacterEncoding=utf-8";
    private static final String USE = "root";
    private static final String PASSWORD = "root";

#### 4、创建【工厂类】的包与类 ####

![在这里插入图片描述][bacf184a71cd4cf5aff454c67c684af8.png_pic_center]

![在这里插入图片描述][8f4902282a054d6090b758cb0c2335ec.png_pic_center]

#### 5、输入链接路径与账号密码 ####

package com.item.jdbc;
    
    /**
     * @author 为一道彩虹
     */
    public class FactoryDB
    {
        
        private static final String URL = "jdbc:mysql://localhost:3306/test?characterEncoding=utf-8";
        private static final String USER = "root";
        private static final String PASSWORD = "root";
    }

#### 6、创建访问数据链接方法 ####

package com.item.jdbc;
    
    import java.sql.*;
    
    /**
     * @author 为一道彩虹
     */
    public class FactoryDB
    {
        
        private static final String URL = "jdbc:mysql://localhost:3306/test?characterEncoding=utf-8";
        private static final String USER = "root";
        private static final String PASSWORD = "root";
    
        //1.加载驱动
        static
        {
        
            try
            {
        
                Class.forName("com.mysql.cj.jdbc.Driver");
            }
            catch (ClassNotFoundException e)
            {
        
                e.printStackTrace();
            }
        }
    
        // 2.获取数据库连接
        public static Connection getConnection()
        {
        
            try
            {
        
                return DriverManager.getConnection(URL, USER, PASSWORD);
            }
            catch (SQLException throwables)
            {
        
                throwables.printStackTrace();
            }
            return null;
        }
    
        // 3.关闭资源
        public static void Close(Connection connection, PreparedStatement preparedStatement, ResultSet resultSet)
        {
        
            try
            {
        
                if (resultSet != null)
                {
        
                    resultSet.close();
                }
                if (preparedStatement != null)
                {
        
                    preparedStatement.close();
                }
                if (connection != null)
                {
        
                    connection.close();
                }
            }
            catch (SQLException e)
            {
        
                e.printStackTrace();
            }
        }
    }

#### 7、创建测试数据表 ####

CREATE TABLE `userinfo` (
      `id` int(8) NOT NULL AUTO_INCREMENT,
      `createDate` datetime NOT NULL,
      `userName` varchar(32) NOT NULL,
      `introduce` varchar(200) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    INSERT INTO userinfo VALUES (0,NOW(),'admin','管理员很厉害');
    INSERT INTO userinfo VALUES (0,NOW(),'zhangsan','张三不认李四');
    INSERT INTO userinfo VALUES (0,NOW(),'lisi','李四都认识');
    INSERT INTO userinfo VALUES (0,NOW(),'wangwu','大刀王五');
    INSERT INTO userinfo VALUES (0,NOW(),'zhaoliu','赵家老六');
    INSERT INTO userinfo VALUES (0,NOW(),'ruanxiaoqi','打鱼的阮小七');
    INSERT INTO userinfo VALUES (0,NOW(),'baxianwang','贤王一名');
    select * from userinfo;

![在这里插入图片描述][ef6329c2b17c45cc863edb2d9ba23860.png_pic_center]

时间我没随机给，比较麻烦，自己改一下也行的哦。

#### 8、创建测试类 ####

包名：【com.item.demo】

类名：【Action】

package com.item.demo;
    
    import com.item.jdbc.FactoryDB;
    
    import java.sql.Connection;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    
    /**
     * @author 为一道彩虹
     */
    public class Action
    {
        
        public static void main(String[] args)
        {
        
            Connection conn = FactoryDB.GetConnection();
            PreparedStatement pre = null;
            ResultSet res = null;
            
            try
            {
        
                pre = conn.prepareStatement("select * from userinfo");
                res = pre.executeQuery();
                while (res.next())
                {
        
                    System.out.print("id："+res.getInt(1)+"\t");
                    System.out.print("createDate："+res.getTime(2)+"\t");
                    System.out.print("userName："+res.getString(3)+"\t");
                    System.out.println("introduce："+res.getString(4));
                }
            }
            catch (SQLException e)
            {
        
                e.printStackTrace();
            }
            finally
            {
        
                FactoryDB.Close(conn,pre,res);
            }
        }
    }

查询成功：  
![在这里插入图片描述][71371f1e68ae4622886c1f5f5a4d0722.png_pic_center]  
**先赞后看，养成习惯！！！^ \_ ^ ❤️ ❤️ ❤️  
码字不易，大家的支持就是我的坚持下去的动力。点赞后不要忘了关注我哦！**

[c27c2599edad40fd8f6ff0625e73d9a6.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/6b56508009974120af1c1ecfaa19ea5c.png
[10fc82392b6945eca7f0fb08d1171518.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/86ca6d8cc44a479a938303944160cacc.png
[cb1f2c8916614f7681dd0eabf7aeea2b.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/b480e7d793c94c41a850f629e605bcb1.png
[b13ee2c7c4894f76a74d21b958bd22d0.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/32c3d61d1952458a9d6fa45a0c0616a6.png
[92e293bce3a94c93b1d9d0c849dbcbf7.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/2e6dfb65fc5546a79304e41524e1258f.png
[8d0e0fb75da044ec8103d6243aa53657.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/95466e45304041cea505b5e425dfe28a.png
[e874c485f2e948a4accd78ab3b0dced5.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/91109a9268574cc98d1bcf5c38e51742.png
[eaf74d58806842979170e815459c982e.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/f1c29f4773fd4ce29f9e0a30797145ea.png
[bacf184a71cd4cf5aff454c67c684af8.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/f8e7609ff9a8470db02177076c36bfa5.png
[8f4902282a054d6090b758cb0c2335ec.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/3597b0b3ca624f31a9d1e94e1b8291b9.png
[ef6329c2b17c45cc863edb2d9ba23860.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/3d725984e02b4f99a498c5dff9e82ae6.png
[71371f1e68ae4622886c1f5f5a4d0722.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/66c48a93e527417994e2f4e1d2d2b132.png