原users表
(1)insert- 向users添加数据
例2-4 insert.java
import jdbc.example.dao.UserDao;
public class Insert {
//private static final java.sql.Date Date = null;
public static void main(String args[]) throws Exception{
//向users表中插入一个用户信息
UserDao ud=new UserDao();
User user=new User();
user.setId(5);
user.setUsername("chun");
user.setPassword("11111");
user.setEmail("chun@qq.com");
user.setBirthday(new java.sql.Date(0));
//user.setBirthday(new Date());
boolean b=ud.insert(user);
System.out.println(b);
}
}
运行结果:true
(2)删除数据
例2-5 Delete.java
package mysql;
import java.sql.SQLException;
import jdbc.example.dao.UserDao;
public class Delete {
public static void main(String args[]) throws SQLException{
//删除操作
UserDao ud=new UserDao();
boolean b=ud.delete(2);
System.out.println(b);
}
}
运行结果:true
(3)修改update数据
例2-6 Update.java
package mysql;
import jdbc.domain.User;
import jdbc.example.dao.UserDao;
//import java.util.Date;
public class UpdateData {
public static void main(String args[]){
//修改数据
UserDao ud=new UserDao();
User user=new User();
user.setId(4);
user.setUsername("qiu");
user.setPassword("6789");
user.setEmail("no");
user.setBirthday(new java.sql.Date(0));
boolean b=ud.update(user);
System.out.println(b);
}
}
运行结果:true