jdbc框架第三篇，方便以后使用

package com.zfsoft.setup.dao.impl;


import java.sql.ResultSet;
import java.sql.SQLException;




import com.zfsoft.setup.intil.pojo.SchoolBasicPojo;
import com.zfsoft.setup.intl.commons.jdbc.HsqlBaseDao;
import com.zfsoft.setup.intl.commons.jdbc.ResultObjectCall;




public class HsqlSchoolBasicSetDaoImpl  extends HsqlBaseDao<SchoolBasicPojo>{
public SchoolBasicPojo doSelect() {
String sql = "SELECT SCHOOLTITLE,SIMPLIFY,VERSION,SCHOOLTITLEDESC,DOMAIN,IPADDRESS FROM SCHOOLBASICSET";
SchoolBasicPojo schoolBasicPojo = this.executeQuery(sql, null,
new ResultObjectCall<SchoolBasicPojo>() {
public SchoolBasicPojo getResultObject(ResultSet rs)
throws SQLException {
SchoolBasicPojo schoolBasicPojo = new SchoolBasicPojo();
schoolBasicPojo.setSchoolTitle(rs.getString("SCHOOLTITLE"));
schoolBasicPojo.setSimplify(rs.getString("SIMPLIFY"));
schoolBasicPojo.setVersion(rs.getString("VERSION"));
schoolBasicPojo.setSchoolTitleDesc(rs.getString("SCHOOLTITLEDESC"));
schoolBasicPojo.setDomain(rs.getString("DOMAIN"));
schoolBasicPojo.setIpAddress(rs.getString("IPADDRESS"));
return schoolBasicPojo;
}
});
return schoolBasicPojo;
}


public void doUpdate(SchoolBasicPojo schoolBasicPojo) {
String sql = "update SCHOOLBASICSET set SCHOOLTITLE='"+schoolBasicPojo.getSchoolTitle()
+"',SIMPLIFY='"+schoolBasicPojo.getSimplify()+"',VERSION='"+schoolBasicPojo.getVersion()
+"',SCHOOLTITLEDESC='"+schoolBasicPojo.getSchoolTitleDesc()+"',DOMAIN='"+schoolBasicPojo.getDomain()
+"',IPADDRESS='"+schoolBasicPojo.getIpAddress()+"'";
this.executeUpdate(sql);
}

public void doInsert(SchoolBasicPojo schoolBasicPojo) {
String sql = "insert into SCHOOLBASICSET(SCHOOLTITLE,SIMPLIFY,VERSION,SCHOOLTITLEDESC,DOMAIN,IPADDRESS)values('"+
schoolBasicPojo.getSchoolTitle()+"','"+schoolBasicPojo.getSimplify()+"','"+schoolBasicPojo.getVersion()
+"','"+schoolBasicPojo.getSchoolTitleDesc()+"','"+schoolBasicPojo.getDomain()+"','"+schoolBasicPojo.getIpAddress()+"')";
this.executeInsert(sql);
}

public static void main(String[] args) {
HsqlSchoolBasicSetDaoImpl hsqlSchoolBasicSetDaoImpl = new HsqlSchoolBasicSetDaoImpl();
SchoolBasicPojo schoolBasicPojo = hsqlSchoolBasicSetDaoImpl.doSelect();
System.out.println(schoolBasicPojo.getSchoolTitle());
System.out.println(schoolBasicPojo.getSimplify());
System.out.println(schoolBasicPojo.getVersion());
System.out.println(schoolBasicPojo.getDomain());
}
}