user用户类
package cn.com.domain;
public class User {
private int id;
private String username;
private String password;
private String yanzhengma;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getYanzhengma() {
return yanzhengma;
}
public void setYanzhengma(String yanzhengma) {
this.yanzhengma = yanzhengma;
}
}
JDBCUtils工具类
连接数据库
package cn.com.utils;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import javax.sql.DataSource;
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;
public class JDBCUtil {
//声明连接池对象
private static DataSource ds;
//静态代码块加载资源
static {
Properties pro = new Properties();
try {
InputStream is = JDBCUtil.class.getClassLoader().getResourceAsStream("druid.properties");
pro.load(is);
//获取连接池对象
try {
ds = DruidDataSourceFactory.createDataSource(pro);
} catch (Exception e) {
e.printStackTrace();
}
} catch (IOException e) {
e.printStackTrace();
}
}
//getds
public static DataSource getDs(){
return ds;
}
}
然后根据用户输入信息查找数据库信息
package cn.com.dao;
import cn.com.domain.User;
import cn.com.utils.JDBCUtil;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;