医院科研管理系统

CREATE DATABASE research_management;

USE research_management;

CREATE TABLE users (

user_id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(50) NOT NULL,

password VARCHAR(50) NOT NULL,

email VARCHAR(50)

);

CREATE TABLE projects (

project_id INT AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(100) NOT NULL,

description TEXT,

实习就业管理系统

start_date DATE,

end_date DATE,

user_id INT,

FOREIGN KEY (user_id) REFERENCES users(user_id)

);

]]>

@Configuration

@EnableWebSecurity

public class SecurityConfig extends WebSecurityConfigurerAdapter {

@Override

protected void configure(HttpSecurity http) throws Exception {

http

.authorizeRequests()

.antMatchers("/login").permitAll()

.anyRequest().authenticated()

.and()

.formLogin()

.loginPage("/login")

.permitAll()

.and()

.logout()

.permitAll();

}

@Autowired

public void configureGlobal(AuthenticationManagerBuilder auth) throws Exception {

auth.inMemoryAuthentication()

.withUser("admin").password("{noop}password").roles("ADMIN");

}

}

]]>