employeedao.java~2~

数据库应用程序.它比较全面的含盖了JAVA应用程序与数据库之间通讯的全过程.本程序在JBUILDER2005上开发运行.

package chapter25.db;
import java.sql.*;
public class EmployeeDAO
{
    private Connection conn;
    public EmployeeDAO(Connection conn) {
        this.conn = conn;
    }
    public Employee findById(String id) throws SQLException
    {
        String sqlStr = "select * from employee where id ='"+id+"'";
        Statement stat = conn.createStatement();
        ResultSet rs = stat.executeQuery(sqlStr);
        if (rs.next()) {
            return new Employee(id,rs.getString("name"),rs.getInt("age"));
        }else{
           return null;
        }
    }
}