insertdao.java

基于j2ee中structs写软件

package com.DAO;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.util.DB;

public class InsertDAO {
	Connection conn=null;
	Statement sm=null;
	ResultSet rs=null;
	boolean flag=false;
	DB db=new DB();
	public boolean update(String condition){
		try{
			conn=db.getConnection();
			sm=conn.createStatement();
			int s=sm.executeUpdate(condition);
			if(s!=0){
				flag=true;
			}
			else
				flag=false;
			conn.close();
		}catch(SQLException e){
			System.out.print(e);
		}
		
		return flag;
	}
	public int maxid(String condition){
		int max=0;
		try{
			conn=db.getConnection();
			sm=conn.createStatement();
			rs=sm.executeQuery(condition);
			if(rs.next()){
				max=rs.getInt(1);
			}
			conn.close();
		}catch(SQLException e){
			System.out.print(e);
		}
		return max;
	}


}