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);
}

}