- jdbc基础知识
- jdbc增加数据
package step2;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class AddData {
public void run() throws SQLException, ClassNotFoundException {
Connection connection = this.getConnection();
Statement statement = connection.createStatement();
String sql = "INSERT INTO `company`.`staff` (`id`, `name`, `sex`, `age`) VALUES ('5', '李敏', '女', '21')";
statement.executeUpdate(sql);
statement.close();
connection.close();
}
public Connection getConnection() throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.cj.jdbc.Driver");
String username = "root";
String password = "123123";
String url = "jdbc:mysql://localhost:3306/company?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true";
return DriverManager.getConnection(url, username, password);
}
}
- jdbc删除数据
package step3;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class DelData {
public void run() throws SQLException, ClassNotFoundException {
Connection connection = this.getConnection();
Statement statement = connection.createStatement();
String sql = "delete from staff where id = 4";
statement.executeUpdate(sql);
statement.close();
connection.close();
}
public Connection getConnection() throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.cj.jdbc.Driver");
String username = "root";
String password = "123123";
String url = "jdbc:mysql://localhost:3306/company?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true";
return DriverManager.getConnection(url, username, password);
}
}
- jdbc修改数据
package step4;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class EditData {
public void run() throws SQLException, ClassNotFoundException {
Connection connection = this.getConnection();
Statement statement = connection.createStatement();
String sql = "update staff set sex = '男' where id = 3";
statement.executeUpdate(sql);
statement.close();
connection.close();
}
public Connection getConnection() throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.cj.jdbc.Driver");
String username = "root";
String password = "123123";
String url = "jdbc:mysql://localhost:3306/company?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true";
return DriverManager.getConnection(url, username, password);
}
}
- jdbc查询数据
package step5;
import java.sql.*;
public class QuerryData {
public static void main(String[] args) throws SQLException, ClassNotFoundException {
QuerryData querryData = new QuerryData();
try{
Connection conn = querryData.getConnection();
Statement sta = conn.createStatement();
String sql = "SELECT id, name, sex, age from staff";
ResultSet rs = sta.executeQuery(sql);
while(rs.next()){
int id = rs.getInt("id");
String name = rs.getString("name");
String sex = rs.getString("sex");
String age = rs.getString("age");
System.out.print(id+",");
System.out.print(name+",");
System.out.print(sex+",");
System.out.println(age);
}
rs.close();
sta.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
public Connection getConnection() throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.cj.jdbc.Driver");
String username = "root";
String password = "123123";
String url = "jdbc:mysql://localhost:3306/company?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true";
return DriverManager.getConnection(url, username, password);
}
}