小工具知识网

当前位置: 首页 > 行业知识 > 【Spring】idea连接mysql数据库

行业知识

【Spring】idea连接mysql数据库

2026-11-19 01:29:31 来源:互联网转载

1 MySQL安装

下载地址:https://dev.mysql.com/downloads/installer/

安装server only选项,之后的可以选择默认安装选项

2 MySQL登录并创建数据

-- 创建数据库create databases spring_db;use spring_db;-- 创建表create table users (    id INT AUTO_INCREMENT PRIMARY KEY,    name VARCHAR(255) NOT NULL,    age INT);-- 插入数据INSERT INTO users (id, name, age) VALUES (1, 'Alice', 25);-- 删除数据DELETE FROM users WHERE id = 1;-- 更新数据UPDATE users SET age = 26 WHERE name = 'Alice';-- 查询数据SELECT id, name, age FROM users WHERE age > 20;

3 idea连接MySQL数据库

选择右侧栏,依次选择Data Source->MySQL;

完成设置后右侧可以看到spring_db数据库中的内容可以查看

4 使用java显示数据

以下为黑马课程代码

B站视频地址

4.1 config包下的三个配置文件

package com.itheima.config;import com.alibaba.druid.pool.DruidDataSource;import org.springframework.beans.factory.annotation.Value;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import javax.sql.DataSource;public class JdbcConfig {    @Value("${jdbc.driver}")    private String driver;    @Value("${jdbc.url}")    private String url;    @Value("${jdbc.username}")    private String userName;    @Value("${jdbc.password}")    private String password;    @Bean    public DataSource dataSource(){        DruidDataSource ds = new DruidDataSource();        ds.setDriverClassName(driver);        ds.setUrl(url);        ds.setUsername(userName);        ds.setPassword(password);        return ds;    }}
package com.itheima.config;import org.mybatis.spring.SqlSessionFactoryBean;import org.mybatis.spring.mapper.MapperScannerConfigurer;import org.springframework.context.annotation.Bean;import javax.sql.DataSource;public class MybatisConfig {    //定义bean,SqlSessionFactoryBean,用于产生SqlSessionFactory对象    @Bean    public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource){        SqlSessionFactoryBean ssfb = new SqlSessionFactoryBean();        ssfb.setTypeAliasesPackage("com.itheima.domain");        ssfb.setDataSource(dataSource);        return ssfb;    }    //定义bean,返回MapperScannerConfigurer对象    @Bean    public MapperScannerConfigurer mapperScannerConfigurer(){        MapperScannerConfigurer msc = new MapperScannerConfigurer();        msc.setBasePackage("com.itheima.dao");        return msc;    }}
package com.itheima.config;import org.springframework.context.annotation.ComponentScan;import org.springframework.context.annotation.Configuration;import org.springframework.context.annotation.Import;import org.springframework.context.annotation.PropertySource;@Configuration@ComponentScan("com.itheima")//@PropertySource:加载类路径jdbc.properties文件@PropertySource("classpath:jdbc.properties")@Import({JdbcConfig.class,MybatisConfig.class})public class SpringConfig {}

4.2 dao包下的AccoutDao

package com.itheima.dao;import com.itheima.domain.Account;import org.apache.ibatis.annotations.Delete;import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Select;import org.apache.ibatis.annotations.Update;import org.springframework.stereotype.Repository;import java.util.List;@Repositorypublic interface AccountDao {    @Insert("insert into users(name,age)values(#{name},#{age})")    void save(Account account);    @Delete("delete from users where id = #{id} ")    void delete(Integer id);    @Update("update users set name = #{name} , age = #{age} where id = #{id} ")    void update(Account account);    @Select("select * from users")    List findAll();    @Select("select * from users where id = #{id} ")    Account findById(Integer id);}

4.3 domain下的Account

package com.itheima.domain;import java.io.Serializable;public class Account implements Serializable {    private Integer id;    private String name;    private Double age;    public Integer getId() {        return id;    }    public void setId(Integer id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public Double getAge() {        return age;    }    public void setAge(Double age) {        this.age = age;    }    @Override    public String toString() {        return "Account{" +                ", name='" + name + '\'' +                ", age=" + age +                '}';    }}

4.4 Service下的

package com.itheima.service;import com.itheima.domain.Account;import java.util.List;public interface AccountService {    void save(Account account);    void delete(Integer id);    void update(Account account);    List findAll();    Account findById(Integer id);}
package com.itheima.service.impl;import com.itheima.dao.AccountDao;import com.itheima.domain.Account;import com.itheima.service.AccountService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import java.util.List;@Servicepublic class AccountServiceImpl implements AccountService {    @Autowired    private AccountDao accountDao;    public void save(Account account) {        accountDao.save(account);    }    public void update(Account account){        accountDao.update(account);    }    public void delete(Integer id) {        accountDao.delete(id);    }    public Account findById(Integer id) {        return accountDao.findById(id);    }    public List findAll() {        return accountDao.findAll();    }}

4.5 主程序

import com.itheima.config.SpringConfig;import com.itheima.domain.Account;import com.itheima.service.AccountService;import org.springframework.context.ApplicationContext;import org.springframework.context.annotation.AnnotationConfigApplicationContext;public class App2 {    public static void main(String[] args) {        ApplicationContext ctx = new AnnotationConfigApplicationContext(SpringConfig.class);        AccountService accountService = ctx.getBean(AccountService.class);        Account ac = accountService.findById(1);        System.out.println(ac);    }}

上一篇:Domoai下载指南,一键获取使用教程,轻松上手!

下一篇:服务器服务里怎么添加?