修改数据库内容和添加删除内容
Statement ps = conn.createStatement(); int rs = ps.executeUpdate(sql);
package jdbc2;
import org.junit.Test;
import java.sql.*;
public class demo2 {
@Test
public void lianxi2()throws Exception{
String url = "jdbc:mysql://localhost:3306/db1";
// String url = "jdbc:mysql:///db1?useSSL=false";
String username = "root";
String password = "***";
Connection conn = DriverManager.getConnection(url,username,password);
String sql ="insert into tb_brand (brand_name, company_name, ordered, description, status) VALUES('小黑','小黑公司',30,'nonono',1)";
PreparedStatement ps = conn.prepareStatement(sql);
int rs = ps.executeUpdate(sql);
if (rs>0){
System.out.println("true");
}else {
System.out.println("false");
}
conn.close();
ps.close();
}
}
查看数据库内容 (需要构造函数) PreparedStatement pr = conn.prepareStatement(sql); ResultSet rs = pr.executeQuery();
package jdbc2;
import org.junit.Test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
public class demo1 {
@Test
public void lianxi() throws Exception{
String url = "jdbc:mysql://localhost:3306/db1";
// String url = "jdbc:mysql:///db1?useSSL=false";
String username = "root";
String password = "***";
Connection conn = DriverManager.getConnection(url,username,password);
String sql ="select * from tb_brand";
PreparedStatement pr = conn.prepareStatement(sql);
ResultSet rs = pr.executeQuery();
List<jdbc1> list = new ArrayList<>();
while (rs.next()) {
Integer id = rs.getInt("id");
String brand_name = rs.getString("brand_name");
String company_name = rs.getString("company_name");
Integer ordered = rs.getInt("ordered");
String description = rs.getString("description");
String status = rs.getString("status");
jdbc1 jd = new jdbc1();
jd.setId(id);
jd.setBrand_name(brand_name);
jd.setCompany_name(company_name);
jd.setOrdered(ordered);
jd.setDescription(description);
jd.setStatus(status);
list.add(jd);
}
System.out.println(list);
// if (rs.next()){
// System.out.println("true");
// }else {
// System.out.println("false");
// }
conn.close();
pr.close();
rs.close();
}
}