`
jianson_wu
  • 浏览: 62818 次
  • 性别: Icon_minigender_1
  • 来自: 广州
社区版块
存档分类
最新评论

小练日期处理方法_DAO

阅读更多
package com.jianson.DATE;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import com.jianson.DATE.Student;

public class DAO {
DBManager dbManager = new DBManager();
Student student = new Student();
public boolean save(Student student){
DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
String sql =
"insert into student values(" +
"" + student.getStuId() + "," +
" '" + student.getStuName() + "'," +
" '" + df.format(student.getStubth()) + "')";
dbManager.save(sql);
return true;
}
public Student findById(int id){
Student student = new Student();
String sql =
"select stuId, stuName, stubth from student where stuId=" + id;
ResultSet rs = dbManager.query(sql);
try {
while(rs.next()){
System.out.println("stuId=" + rs.getInt(1));
System.out.println("stuName=" + rs.getString(2));
System.out.println("stubth=" + rs.getString(3));
}
} catch (SQLException e) {
e.printStackTrace();
}
return student;
}
public Student findAll(){
Student student = new Student();
String sql =
"select stuId, stuName, stubth from student";
ResultSet rs = dbManager.query(sql);
try {
while(rs.next()){
System.out.println("stuId=" + rs.getInt(1));
System.out.println("stuName=" + rs.getString(2));
System.out.println("stubth=" + rs.getString(3));
}
} catch (SQLException e) {
e.printStackTrace();
}
return student;
}    
}
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics