#JDBC未运用:封装、Dao、配置文件properties之前的基本操作:
增加、删除、查询、修改
package JDBCDemo04;
import org.junit.Test;
import java.sql.*;
public class Demo04 {
//添加
@Test
public void jdbcAdd() throws Exception{
//1、加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2、创建连接数据库的对象
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?characterEncoding=utf-8",
"root", "root");
//3、创建操作数据库的对象,同时写sql语句(添加数据)
PreparedStatement pst=conn.prepareStatement( //预编译
"insert into student08(s_name,s_sex,s_birthday,s_class) " +
"values(?,?,?,?)");
//4、追加设置数据到value
pst.setString(1,"余兵");
pst.setString(2,"男");
Date date=new Date(new java.util.Date().getTime());
pst.setDate(3, date);
pst.setString(4,"K9501");
int i=pst.executeUpdate(); //添加数据为单个对象(一条记录),故为整型,以i作判断
if (i>0){
System.out.println("添加成功!");
}
//释放资源
pst.close();
conn.close();
}
//删除
@Test
public void jdbcDel() throws Exception{
Class.forName("com.mysql.jdbc.Driver"); //加载驱动
Connection conn=DriverManager.getConnection( //创建连接对象
"jdbc:mysql://localhost:3306/test?characterEncoding=utf-8",
"root","root"
);
String sql="delete from student08 where s_id=?";
PreparedStatement pst=conn.prepareStatement(sql);
pst.setInt(1,118);
pst.executeUpdate();
conn.close();
}
//修改
@Test
public void jdbcUpdate() throws Exception{
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/test?characterEncoding=utf-8",
"root", "root"
);
PreparedStatement pst=conn.prepareStatement("update student08 set s_name=? where s_id=?");
pst.setString(1,"李文豪");
pst.setInt(2,123);
pst.executeUpdate();
conn.close();
}
//查询
@Test
public void jdbcQuery() throws Exception{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection(
"jdbc:mysql://localhost:3306/test?characterEncoding=utf-8",
"root","root"
);
PreparedStatement pst=conn.prepareStatement("SELECT s_id,s_name,s_sex,s_birthday,s_class from student08");
ResultSet rs = pst.executeQuery();
while (rs.next()){
int id = rs.getInt(1);
String name = rs.getString(2);
String sex = rs.getString(3);
Date date = rs.getDate(4);
String s_class = rs.getString(5);
System.out.println(id+","+name+","+sex+","+date+","+s_class);
}
conn.close();
}
}