insert.java

纯jsp做的人事招聘系统

package com.db;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;

public class Insert {
	Connection conn;
	PreparedStatement ps;
	ResultSet rs;
	String sql;
	
	public boolean newRecord(String com_name, String position, String needs,String quantity){
		
		boolean mark= false;
		
		conn = DBPool.getConnection();
		sql = "insert into employ_message(com_name, position, needs, quantity) values(?,?,?,?)";

		
		try{
			ps = conn.prepareStatement(sql);
			ps.setString(1, com_name);
			ps.setString(2, position);
			ps.setString(3, needs);
			ps.setString(4, quantity);
			
			ps.executeUpdate();
			
			mark= true;
			
		}catch(SQLException ee){
			System.out.println(ee);
		}		
		return mark;
	}
}