插入
package com.kuang.lesson02;
import com.kuang.lesson02.utils.jdbcUtils;
import java.sql.*;
public class TestInsert {
public static void main(String[] args) {
Connection con=null;
Statement st=null;
ResultSet rs=null;
try {
con=jdbcUtils.getConnection (); //获取连接
st=con.createStatement ();
String sql="INSERT INTO users (id,name,password,email,birthday)"+
"VALUES(4,'yyf','123456','23456@qq,com','2020-03-03')";
int n=st.executeUpdate (sql);
if(n>0){
System.out.println ("插入成功");
}
}
catch (SQLException throwables) {
throwables.printStackTrace ();
}
finally {
jdbcUtils.release (con,st,rs);
}
}
}