【Java开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了Java开源代码-ModelDAO.java的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
//---------------------------------------------------------
// Application: Equipment of System
// Author : eSingle
// File : ModelDAO.java
//
// Copyright 2002 LandSoft Corp.
// Generated at Mon Nov 18 20:14:24 CST 2002
// Created by caoguangxin
// mailto:3710167@qq.com.edu.cn
//---------------------------------------------------------
package com.landsoft.equipment.dao;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.sql.*;
import com.landsoft.equipment.model.*;
import com.landsoft.equipment.util.CacheManager;
public class ModelDAO extends DAO {
public ModelDAO(DataSource ds) {
super(ds);
}
public void insert(Model model) throws SQLException {
String sql;
sql = "INSERT INTO model (modename) VALUES (?)";
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = ds.getConnection();
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, model.getModename());
pstmt.executeUpdate();
pstmt.close();
conn.commit();
} catch (SQLException sqle) {
close(rs);
close(pstmt);
rollback(conn);
sqle.printStackTrace();
throw sqle;
} finally {
close(conn);
}
}
public void update(Model model) throws SQLException {
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = ds.getConnection();
String sql = "UPDATE model SET WHERE modename=?";
pstmt = conn.prepareStatement(
sql);
pstmt.setString(1, model.getModename());
pstmt.executeUpdate();
close(pstmt);
conn.commit();
} catch (SQLException e) {
close(pstmt);
rollback(conn);
e.printStackTrace();
} finally {
close(conn);
}
}
public void delete(String modename) throws SQLException {
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = ds.getConnection();
String sql = "DELETE FROM model WHERE modename=?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, modename);
pstmt.executeUpdate();
close(pstmt);
conn.commit();
} catch (SQLException e) {
close(pstmt);
rollback(conn);
e.printStackTrace();
} finally {
close(conn);
}
String[] objKeys = {"Model", String.valueOf(modename)};
String objKey = CacheManager.createKey(objKeys);
DAOCacheManager.invalidate(objKey);
}
public Model retrieve(String modename) throws SQLException {
String[] objKeys = {"Model", String.valueOf(modename)};
String objKey = CacheManager.createKey(objKeys);
Model model = (Model) DAOCacheManager.getCache(objKey);
if (model != null)
return model;
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = ds.getConnection();
String sql = "SELECT * FROM model WHERE modename=?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, modename);
rs = pstmt.executeQuery();
if (rs.next()) {
model = new Model();
populate(model, rs);
}
close(rs);
close(pstmt);
} catch (SQLException e) {
close(rs);
close(pstmt);
rollback(conn);
e.printStackTrace();
} finally {
close(conn);
}
DAOCacheManager.putCache(model, objKey, 1);
return model;
}
public List list() throws SQLException {
String[] objKeys = {"Model", "list"};
String objKey = CacheManager.createKey(objKeys);
ArrayList list = (ArrayList) DAOCacheManager.getCache(objKey);
if (list != null)
return list;
list = new ArrayList();
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = ds.getConnection();
String sql = "SELECT modename FROM model";
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next()) {
Model model = new Model();
populate(model, rs);
list.add(model);
}
close(rs);
close(pstmt);
} catch (SQLException e) {
close(rs);
close(pstmt);
rollback(conn);
e.printStackTrace();
} finally {
close(conn);
}
DAOCacheManager.putCache(list, objKey, 1);
return list;
}
public List list(int offset, int limit) throws SQLException {
String[] objKeys = {"Model", "list", String.valueOf(offset), String.valueOf(limit)};
String objKey = CacheManager.createKey(objKeys);
ArrayList list = (ArrayList) DAOCacheManager.getCache(objKey);
if (list != null)
return list;
list = new ArrayList();
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = ds.getConnection();
String sql = "SELECT modename FROM model";
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
if(offset > 0) rs.ab