od stub
sql="insert into t1(name,password) values('lisi','1234')"; //创建sql语句
mysqldao.doSql(sql); //执行sql语句
i=mysqldao.getUpCount(); //获取影响行数
if(i!=-1){
System.out.println("数据插入成功！");
}else{
System.out.println("数据插入失败！");
}
mysqldao.close(); //关闭连接
}
/*
* 删除数据
* */
@Test
public void delete() {
// TODO Auto-generated method stub
sql="delete from t1 where id=6";
mysqldao.doSql(sql);
i=mysqldao.getUpCount();
if(i!=-1){
System.out.println("数据删除成功！");
}else{
System.out.println("数据删除失败！");
}
mysqldao.close();
}
/*
* 修改数据
* */
@Test
public void update() {
// TODO Auto-generated method stub
sql="update t1 set name='wangwu' where id=1";
mysqldao.doSql(sql);
i=mysqldao.getUpCount();
if(i!=-1){
System.out.println("数据更新成功！");
}else{
System.out.println("数据更新失败！");
}
mysqldao.close();
}
/*
* 遍历数据
* */
@Test
public void select() throws SQLException {
// TODO Auto-generated method stub
sql="select * from t1";
mysqldao.doSql(sql);
rs=mysqldao.getRs();
if(rs!=null){
rs.last();
i=rs.getRow();
if(i>0){
rs.beforeFirst();
while(rs.next()){
String id=rs.getString("id");
String name=rs.getString("name");
String password=rs.getString("password");
System.out.println("id:"+id+" "+"name:"+name+" password:"+password);
}
}else{
System.out.println("对不起，没有您要查询的信息！");
}
}else{
System.out.println("异常...........");
}
mysqldao.close();
}
}
|