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

public boolean updateUser(UserBean userBean{ dbUtil = new DBUtils(;

String sql = \int row = dbUtil.excete(sql, new

Object[]{userBean.getYx(,userBean.getZy(,userBean.getAge(,userBean.getDh(,userBean.getQq(,userBean.getSex(,userBean.getId(}; if(row>0 { return true; }

return false; } }

package com.util;

import java.sql.Date;

import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.mysql.jdbc.Connection; import com.mysql.jdbc.Statement; public class DBUtils {

private static Connection conn=null; private Statement st=null; private ResultSet rs = null; private PreparedStatement ps; static{ try {

Class.forName(\

conn = (Connection

DriverManager.getConnection(\acterEncoding=UTF-8\} catch (ClassNotFoundException e { e.printStackTrace(; } catch (SQLException e { e.printStackTrace(; } } /** *

* @Title: exceteSQl

* @Description: TODO(执行不带参数的sql语句 * @param sql * @return ResultSet * @throws */

public ResultSet exceteSQl(String sql { try {

st =(Statement conn.createStatement(; rs = st.executeQuery(sql; } catch (SQLException e { e.printStackTrace(; } return rs; } /** *

* @Title: exceteSQl

* @Description: TODO(执行带参数的sql语句 * @param sql * @param obj * @return ResultSet * @throws */

public ResultSet exceteSQl(String sql, Object[] obj {

int length = obj.length; try {

ps = conn.prepareStatement(sql; preparStateSql(obj, length; rs = ps.executeQuery(; } catch (SQLException e { e.printStackTrace(; } return rs; } /** *

* @Title: excete

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

public int excete(String sql{ int row =0; try {

st = (Statement conn.createStatement(; row = st.executeUpdate(sql;