行业知识
【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); }}
下一篇:服务器服务里怎么添加?