ajaxdaoimpl.java

来自「自己做的一个火车票售票网站是课程设计 用的是servlet+jsp 数据库是m」· Java 代码 · 共 38 行

package com.daoImpl;

import java.sql.PreparedStatement;

import com.dao.AjaxDAO;
import com.jdbc.DataBaseConnection;

public class AjaxDAOImpl implements AjaxDAO{
   public Integer deleteChepiao(String temp,String temp1,String temp2){
	   int i=0;
	   DataBaseConnection dbc = new DataBaseConnection();
	   PreparedStatement psmt =null;
	   String sql =null;
	   try{
		   
		   sql="delete from ajax where number=? and name=? and number1=?";
		   psmt =dbc.getConnection().prepareStatement(sql);
		   psmt.setString(1,temp);
		   psmt.setString(2,temp1);
		   psmt.setString(3,temp2);
		    i=psmt.executeUpdate();
	   }
	   catch(Exception e){
		   e.printStackTrace();
	   }
	   finally{
		   try{
			   psmt.close();
		   }
		   catch(Exception e){
			   
		   }
		   dbc.close();
	   }
	   return i;
   }
}