实训记录——Day1
学习如何创建一个Maven项目;
学习数据库连接的两种方法;
1.创建一个Maven项目
配置环境
IDEA
JDK1.8
Mysql
navicat
1.1替换阿里云镜像
找到.m2文件夹下settings.xml更改镜像
<mirror>
<id>alimaven</id>
<name>aliyun maven</name>
<url>http://maven.aliyun.com/nexus/content/groups/public/</url>
<mirrorOf>central</mirrorOf>
</mirror>
1.2.开始创建
选择Maven;…webapp
添加配置,使项目从本地仓库中的插件进行创建
为项目添加依赖,替换选中代码
完成创建
2.传统方式连接数据库
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class jdbc_test {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
//获取数据库连接对象
Connection connection = DriverManager.getConnection
("jdbc:mysql://localhost:3306/jdbc_test?useSSL=false","root","******");
//定义SQL语句
String sql = "update user set name = '略略略' where id = 2";
//获取执行sql的对象
Statement stmt = connection.createStatement();
//执行sql,并接受返回结果
int count = stmt.executeUpdate(sql);
//处理结果
System.out.println(count);
//释放结果
stmt.close();
connection.close();
}
}
3.使用properties配置文件进行数据库连接
创建properties配置文件——jdbc.properties
url=jdbc:mysql://localhost:3306/jdbc_test?useSSL=false
user=root
password=******
driver=com.mysql.jdbc.Driver
创建JDBCUtils类
import java.io.FileReader;
import java.io.IOException;
import java.net.URL;
import java.sql.*;
import java.util.Properties;
public class JDBCUtils {
private static String url;
private static String user;
private static String password;
private static String driver;
//读取文件
static {
try {
//创建Properies集合类
Properties pro = new Properties();
ClassLoader classLoader = JDBCUtils.class.getClassLoader();
URL res = classLoader.getResource("jdbc.properties");
String path = res.getPath();
System.out.println(path);
//加载文件
pro.load(new FileReader(path));
//获取数值
url = pro.getProperty("url");
user = pro.getProperty("user");
password = pro.getProperty("password");
driver = pro.getProperty("driver");
Class.forName(driver);
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
//获取连接
public static Connection getConnection()throws SQLException{
return DriverManager.getConnection(url,user,password);
}
//释放资源
public static void close(ResultSet rs, Statement stmt,Connection conn){
if (rs!=null){
try{
rs.close();
}catch (SQLException e){
e.printStackTrace();
}
}
if (stmt!=null){
try {
stmt.close();
}catch (SQLException e){
e.printStackTrace();
}
}
if (conn!=null){
try {
conn.close();
}catch (SQLException e){
e.printStackTrace();
}
}
}
}
新建测试类
import java.sql.*;
import java.util.Scanner;
public class jdbc_test {
public static void main(String[] args){
Scanner sc = new Scanner(System.in);
System.out.println("请输入用户名:");
String username = sc.nextLine();
System.out.println("请输入密码:");
String password = sc.nextLine();
boolean loginFlag = new jdbc_test().login(username,password);
if(loginFlag){
System.out.println("登录成功");
}else {
System.out.println("登录失败");
}
}
//登录方法
public boolean login(String username,String password){
if (username == null || password == null){
return false;
}
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
conn = JDBCUtils.getConnection();
//定义sql
String sql = "select * from user where name = '"
+ username + "'and password = '" + password +"'";
//执行获取sql对象
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
return rs.next();
}catch (SQLException e){
e.printStackTrace();
}finally {
JDBCUtils.close(rs,stmt,conn);
}
return false;
}
}
测试连接成功