index.jsp代码 <%@ page contentType=“text/html;charset=UTF-8” language=“java” %>
<servlet>
<servlet-name>bb</servlet-name>
<servlet-class>shi.UserServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>bb</servlet-name>
<url-pattern>/aa</url-pattern>
</servlet-mapping>
JdbcUitl.java 代码 package shi;
import java.sql.*;
public class JdbcUitl {
private static String driver=“com.mysql.jdbc.Driver”;
private static String url=“jdbc:mysql://localhost:3306/huang”;
private static String user=“root”;
private static String password="";
private static Connection con=null;
static{
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getCon(){
try {
con= DriverManager.getConnection(url,user,password);
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
public static void close(Connection con, Statement stmt, ResultSet rs){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
} Crud.java 代码 package shi;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Crud extends JdbcUitl{
private static Connection con=null;
private static PreparedStatement pstmt=null;
//添加删除
public boolean insert_del_upt_Crud(String sql,Object[] objects){
boolean b=false;
con=getCon();
try {
pstmt=con.prepareStatement(sql);
if(objects !=null){
for(int i=0;i<objects.length;i++){
pstmt.setObject(i+1,objects[i]);
}
}
int row=pstmt.executeUpdate();
if(row > 0){
b=true;
}
} catch