ofo项目_java_源码

package com.ys.ofo.dao; import com.ys.ofo.pojo.UsersPojo; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; public class FunctionDao { public static List<UsersPojo> selectUsers(){ List<UsersPojo> usersPojoList=new ArrayList<>(); try { Connection connection=ToolsDao.getConnection(); String sql="select * from ofo_users"; PreparedStatement preparedStatement = connection.prepareStatement(sql); ResultSet resultSet=preparedStatement.executeQuery(); while (resultSet.next()){ UsersPojo usersPojo=new UsersPojo(); usersPojo.setId(resultSet.getInt("ofo_users_id")); usersPojo.setName(resultSet.getString("ofo_users_name")); usersPojo.setBalance(resultSet.getFloat("ofo_users_balance")); usersPojo.setMileage(resultSet.getFloat("ofo_users_mileage")); usersPojoList.add(usersPojo); } } catch (SQLException e) { e.printStackTrace(); } return usersPojoList; } public static boolean updateUsers(int id,String name,float balance,float mileage){ try { Connection connection=ToolsDao.getConnection(); String sql="update ofo_users set ofo_users_name=? ,ofo_users_balance=?,ofo_users_mileage=? where ofo_users_id=?"; PreparedStatement preparedStatement=connection.prepareStatement(sql); preparedStatement.setString(1,name); preparedStatement.setFloat(2,balance); preparedStatement.setFloat(3,mileage); preparedStatement.setInt(4,id); int n=preparedStatement.executeUpdate(); if (n>0){ return true; } } catch (SQLException e) { e.printStackTrace(); } return false; } public static boolean deleteUsers(int id){ try { Connection connection=ToolsDao.getConnection(); String sql="delete from ofo_users where ofo_users_id=?"; PreparedStatement preparedStatement=connection.prepareStatement(sql); preparedStatement.setInt(1,id); int n=preparedStatement.executeUpdate(); if(n>0) { return true; } } catch (SQLException e) { e.printStackTrace(); } return false; } public static boolean insertUsers(String name,float balance,float mileage){ try { Connection connection=ToolsDao.getConnection(); String sql="insert into ofo_users (ofo_users_name,ofo_users_balance,ofo_users_mileage)value(?,?,?)"; PreparedStatement preparedStatement=connection.prepareStatement(sql); preparedStatement.setString(1,name); preparedStatement.setFloat(2,balance); preparedStatement.setFloat(3,mileage); int n=preparedStatement.executeUpdate(); if (n>0){ return true; } } catch (SQLException e) { e.printStackTrace(); } return false; } }