introducedao.java

来自「java web网络编程示例,原代码资源」· Java 代码 · 共 60 行

package edu.liusong.dao;

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

import edu.liusong.common.DBConnect;
import edu.liusong.mo.Introduce;

public class IntroduceDAO {
	private DBConnect conn;

	private ResultSet rs;

	public Introduce get(String id) {
		Introduce intro = null;
		try {
			conn = new DBConnect();
			String sql = "select * from introduce where id=?";
			String[] values = { id };
			rs = conn.executeQuery(sql, values);
			if (rs.next()) {
				intro = new Introduce();
				intro.setId(rs.getString(1));
				intro.setName(rs.getString(2));
				intro.setContent(rs.getString(3));
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}

		return intro;
	}

	public void update(Introduce intro){
		try {
			conn=new DBConnect();
			String sql="update introduce set content=? where id=?";
			String []values={intro.getContent(),intro.getId()};
			conn.executeUpdate(sql, values);
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			if(conn!=null){
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}
	}
}