update.java

来自「纯jsp做的人事招聘系统」· Java 代码 · 共 41 行

package com.db;

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

public class Update {
	
	Connection conn;
	PreparedStatement ps;
	ResultSet rs;
	String sql;
	
	public boolean updatetable(String com_name, String position, String needs, String quantity,String no){
		
		boolean mark= false;
		
		conn = DBPool.getConnection();
		sql = "update employ_message set com_name =?,position=?,needs=?,quantity=? where no=?";		
		
		try{
			ps = conn.prepareStatement(sql);
			ps.setString(1, com_name);
			ps.setString(2, position);
			ps.setString(3, needs);
			ps.setString(4, quantity);
			ps.setString(5, no);
			
			ps.executeUpdate();
			
			mark= true;
			
		}catch(SQLException ee){
		}		
		return mark;
	}
	

}