employdao.java~6~

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

package chapter25.db;
import java.sql.*;
public class EmployDAO
{
    private Connection conn;
    public EmployDAO(Connection conn) {
        this.conn = conn;
    }

    public Employ findById(String id) throws SQLException
    {
        String sqlStr = "select * from employ where id ='"+id+"'";
        Statement stat = conn.createStatement();
        ResultSet rs = stat.executeQuery(sqlStr);
        if (rs.next()) {
            Employ employ = new Employ(id,rs.getString("name"),rs.getInt("age"));
        }else{
           return null;
        }
    }
}