小练日期处理方法_DAO

最新推荐文章于 2025-11-01 10:30:28 发布

原创最新推荐文章于 2025-11-01 10:30:28 发布 · 114 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#SQL #Java #DAO

JAVA基础专栏收录该内容

16 篇文章

订阅专栏

本文介绍了一个简单的学生信息管理系统，该系统使用Java进行开发，能够实现学生信息的保存、查询等功能。通过SQL语句与数据库交互，完成对学生基本信息如ID、姓名及出生日期的数据操作。

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;
}
}