JAVA JDBC 连接步骤
- 导入驱动包
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.15</version>
</dependency>
- 加载驱动
Class.forName("com.mysql.cj.jdbc.Driver");
- 创建连接
//java10是数据库的名字
String url="jdbc:mysql://localhost:3306/java10?useSSL=false&serverTimezone=UTC";
//登录数据库用户名
String username="root";
//登录数据库密码
String pwd="Java20190713*yy";
Connection conn = DriverManager.getConnection(url,username,pwd);
- 创建Statement,执行sql
Statement st=conn.createStatement();
- 关闭连接
rs.close();
st.close();
conn.close();
完整代码
package com.base.day8;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCTest {
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
Class.forName("com.mysql.cj.jdbc.Driver");
//java10是数据库的名字
String url="jdbc:mysql://localhost:3306/java10?useSSL=false&serverTimezone=UTC";
//登录数据库用户名
String username="root";
//登录数据库密码
String pwd="Java20190713*yy";
Connection conn = DriverManager.getConnection(url,username,pwd);
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select name,id,score,subject from student");
while(rs.next()){
System.out.println("名字"+rs.getString("name"));
System.out.println("分数"+rs.getString("score"));
}
rs.close();
st.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
执行结果:
JDBC 增删改查
package com.base.day8;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCTest2 {
public static void main(String[] args) {
// TODO Auto-generated method stub
JDBCTest2 jdbc=new JDBCTest2();
Student student=new Student();
student.setName("JDBC");
student.setScore(100);
student.setSubject("数学");
student.setTeam_id(1);
jdbc.insert(student);
}
//增
public boolean insert(Student s){
boolean f=false;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
//java10是数据库的名字
String url="jdbc:mysql://localhost:3306/java10?useSSL=false&serverTimezone=UTC";
//登录数据库用户名
String username="root";
//登录数据库密码
String pwd="Java20190713*yy";
Connection conn = DriverManager.getConnection(url,username,pwd);
Statement st=conn.createStatement();
String sql="insert into student (name,score,subject,team_id) values('"+s.getName()+"',"+s.getScore()+",'"+s.getSubject()+"',"+s.getTeam_id()+")";
int rs=st.executeUpdate(sql);
if(rs>0){
f=true;
}
st.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return f;
}
}