一、数据库内操作
1.搜索栏内输入cmd,以管理员身份运行。
2.登入MySQL
3.创建数据库和表
二、java内部操作
1.使用Java命令查询数据库操作
2.右击——点击“Build Path”——选择第四个——找到包的位置——导入成功
3.创建java项目
三、连接数据库
1.注册驱动
public void getConnection() throws SQLException{
DriverManager.registerDriver(new Driver());
2.获取链接
coonection = DriverManager.getConnection("jdbc:mysql://localhost:3306/school_java","root","1234");
3.获取statment对象
PreparedStatement prepareStatedment = coonection.prepareStatement("insert into course values (?,?)");
4. 执行SQL语句返回结果集
ResultSet resultSet=prepareStatedment.executeQuery();
5.遍历结果集
while(resultSet.next()) {
System.out.print(resultSet.getInt("id"));
System.out.println(resultSet.getString("name"));
}
6.关闭连接释放资源
```java
resultSet.close();
prepareStatedment.close();
```
private void close() throws SQLException{
coonection.close();
}
7.整体代码
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.cj.jdbc.Driver;
public class JDBCDemo {
Connection coonection;
public static void main(String[] args) throws SQLException{
JDBCDemo jdbcdemo= new JDBCDemo();
jdbcdemo.getConnection();
jdbcdemo.selectAll();
jdbcdemo.add(4,"WEB");
jdbcdemo.selectAll();
jdbcdemo.close();
}
public void add(int id, String name) throws SQLException {
PreparedStatement prepareStatedment = coonection.prepareStatement("insert into course values (?,?)");
prepareStatedment.setInt(1, id);
prepareStatedment.setString(2, name);
prepareStatedment.executeUpdate();
}
public void getConnection() throws SQLException{
DriverManager.registerDriver(new Driver());
coonection = DriverManager.getConnection("jdbc:mysql://localhost:3306/school_java","root","1234");
}
public void selectAll() throws SQLException{
PreparedStatement prepareStatedment = coonection.prepareStatement("insert into course values (?,?)");
ResultSet resultSet=prepareStatedment.executeQuery();
while(resultSet.next()) {
System.out.print(resultSet.getInt("id"));
System.out.println(resultSet.getString("name"));
}
resultSet.close();
prepareStatedment.close();
}
private void close() throws SQLException{
coonection.close();
}
}