employdao.java~10~

来自「数据库应用程序.它比较全面的含盖了JAVA应用程序与数据库之间通讯的全过程.本程」· JAVA~10~ 代码 · 共 21 行

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 employee where id ='"+id+"'";
        Statement stat = conn.createStatement();
        ResultSet rs = stat.executeQuery(sqlStr);
        if (rs.next()) {
            return new Employ(id,rs.getString("name"),rs.getInt("age"));
        }else{
           return null;
        }
    }
}