import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import org.junit.Test;
import com.utils.JDBCUtil;
public class CRUD {
static Connection con;
static {
con = JDBCUtil.getConn();
}
@Test
public void query() throws Exception {
Statement statement = con.createStatement();
String sql = "select * from students";
ResultSet query = statement.executeQuery(sql);
while(query.next()){
String id = query.getString("id");
String name = query.getString("name");
String clazz = query.getString("clazz");
System.out.println(id + " " + name + " " + clazz);
}
}
@Test
public void insert() throws Exception {
Statement statement = con.createStatement();
String sql = "insert into students(id, name, clazz) values ('160341238', '赵承阳', '160341B')";
int row = statement.executeUpdate(sql);
}
@Test
public void update() throws Exception {
Statement statement = con.createStatement();
String sql = "update students set id = 'helloworld' where id = '160341237'";
int row = statement.executeUpdate(sql);
}
@Test
public void delete() throws Exception {
Statement statement = con.createStatement();
String sql = "delete from students where id = '160341238'";
//返回处理的行数
int row = statement.executeUpdate(sql);
}
}
JDBC - CURD(02)
最新推荐文章于 2024-03-17 18:58:21 发布