javaWeb-连接mysql数据库增删改查（精）(6)

} catch (SQLException e { e.printStackTrace(; }finally{ close(; } return row; } /** *

* @Title: excete

* @Description: TODO(此方法适用带参数的修改，删除，增加 * @param sql * @param obj * @return int * @throws */

public int excete(String sql, Object[] obj { int row =0;

int length = obj.length; try {

ps = conn.prepareStatement(sql; preparStateSql(obj, length; row = ps.executeUpdate(; } catch (SQLException e {

e.printStackTrace(; }finally{ close(; } return row; } /** *

* @Title: preparStateSql

* @Description: TODO(参数赋值 * @param obj * @param length

* @throws SQLException void * @throws */

private void preparStateSql(Object[] obj, int length throws SQLException { for(int i=0;i {

if(obj[i].getClass(==String.class {

ps.setString(i+1, obj[i].toString(; }else if(obj[i].getClass(==Integer.class {

ps.setInt(i+1, (Integerobj[i];

}else if(obj[i].getClass(==Double.class

{

ps.setDouble(i+1, (Doubleobj[i];

}else if(obj[i].getClass(==Date.class//java.sql.Date {

ps.setDate(i+1, (Dateobj[i];

} } } /** *

* @Title: close

* @Description: TODO(数据库连接关闭 void * @throws */

public void close( { if(rs!=null { try { rs.close(;

} catch (SQLException e { e.printStackTrace(; } } if(st!=null { try { st.close(;

} catch (SQLException e {

e.printStackTrace(; } } if(ps!=null { try { ps.close(;

} catch (SQLException e { e.printStackTrace(; } } }

public static void main(String[] args { DBUtils db = new DBUtils(; String sql = \ResultSet rr = db.exceteSQl(sql; try { while(rr.next( { int i =1;

System.out.print(rr.getInt(i+++\System.out.print(rr.getString(i+++\System.out.print(rr.getString(i+++\System.out.print(rr.getInt(i+++\System.out.print(rr.getString(i+++\System.out.print(rr.getString(i+++\System.out.println(rr.getString(i++; }

} catch (SQLException e {

// TODO Auto-generated catch block

e.printStackTrace(; }finally{ db.close(; }

//String sql = \软件\\\测试\\\女\\\

/* String sql = \

int row = db.excete(sql, new Object[]{\软件\测试\女\//int row = db.excete(sql; if(row>0 {

System.out.println(\增加成功\}*/

/*String sql = \int row = db.excete(sql, new Object[]{\计通\if(row>0 {

System.out.println(\修改成功\}*/ } }

所需要的驱动包：

Web.xml配置：

xml version=\ encoding=\?>

xmlns=\

xmlns:xsi=\