javabean数据库增删改通用基本代码

package 包名; import java.sql.*; public class 类名 { private Connection conn =null; private Statement stmt; ResultSet rs = null; String url=“jdbc:sqlserver://localhost:1433;DatabaseName=Webfinal”;//数据库名 String username = “sa”;//数据库账号 String password = “root”;//密码 int n; public int executeDelete(String delete) { try { Class.forName(“com.microsoft.jdbc.sqlserver.SQLServerDriver”); } catch (ClassNotFoundException ex1) { } try{ conn = DriverManager.getConnection(url,username,password); stmt = conn.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); n = stmt.executeUpdate(delete); }catch (SQLException ex){ System.err.println(“sql_data.executeQuery:” + ex.getMessage()); } return n; } public void close(){ try{ stmt.close(); conn.close(); rs.close(); }catch(Exception ex){ System.out.println(ex.toString()); } } }

// servlet新增实例 //servlet文件 package myproject; import java.io.; import javax.servlet.; import javax.servlet.http.*;

public class add_servlet extends HttpServlet {

delete delete_bean = new delete();

public void init() throws ServletException {
	
}
public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{
	response.setHeader("Content-type","text/html; charset=UTF-8");
	PrintWriter out = response.getWriter();
	String update = "INSERT INTO dbo.u_user(id,username,password,email) VALUES(";
	
	request.setCharacterEncoding("UTF-8");
	update+=request.getParameter("add1");
	update+=",";
	update+=request.getParameter("add2");
	update+=",";
	update+=request.getParameter("add3");
	update+=",";
	update+=request.getParameter("add4");
	update+=");";
	System.out.println(update);
	
	delete_bean.executeDelete(update);
	String script = "<script language="JavaScript">+alert("添加成功!");window.location.href=index.jsp</script>";
	out.println(script);
}

}