data.java

来自「jsp版图书管理系统」· Java 代码 · 共 56 行

package com.ww.j2ee;

import java.sql.*;
public class Data{
	private Conn con=new Conn();
	private ResultSet rs;
	private Statement st;
	
	public int insert(String sql){
		int count=0;
		st=con.getSt();
		try{
			count=st.executeUpdate(sql);
		}catch(Exception e){
			count=-2;
			System.err.println(e.getMessage());
			e.printStackTrace();
		}finally{
			con.close();
			return count;
		}
	}
	
	public int update(String sql){
		int count=0;
		st=con.getSt();
		try{
			count=st.executeUpdate(sql);
		}catch(Exception e){
			count=-2;
			System.err.println(e.getMessage());
			e.printStackTrace();
		}finally{
			con.close();
			return count;
		}
	}
	
	public int delete(String sql){
		int count=0;
		st=con.getSt();
		try{
			count=st.executeUpdate(sql);
		}catch(Exception e){
			count=-2;
			System.err.println(e.getMessage());
			e.printStackTrace();
		}finally{
			con.close();
			return count;
		}
	}
	
	
}