菜鸟学步之石器时代jspMVC数据操作

package com.sss.util;
import java.sql.*;public class DB {public static Connection getConn() {Connection conn &＃61; null;try {Class.forName("com.mysql.jdbc.Driver");conn &＃61; DriverManager.getConnection("jdbc:mysql://localhost:3306/smud","root","root");} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}return conn;}public static PreparedStatement prepare(Connection conn, String sql) {PreparedStatement pstmt &＃61; null; try {if(conn !&＃61; null) {pstmt &＃61; conn.prepareStatement(sql);}} catch (SQLException e) {e.printStackTrace();}return pstmt;}public static PreparedStatement prepare(Connection conn, String sql, int autoGenereatedKeys) {PreparedStatement pstmt &＃61; null; try {if(conn !&＃61; null) {pstmt &＃61; conn.prepareStatement(sql, autoGenereatedKeys);}} catch (SQLException e) {e.printStackTrace();}return pstmt;}public static Statement getStatement(Connection conn) {Statement stmt &＃61; null; try {if(conn !&＃61; null) {stmt &＃61; conn.createStatement();}} catch (SQLException e) {e.printStackTrace();}return stmt;}/*public static ResultSet getResultSet(Connection conn, String sql) {Statement stmt &＃61; getStatement(conn);ResultSet rs &＃61; getResultSet(stmt, sql);close(stmt);return rs;}*/public static ResultSet getResultSet(Statement stmt, String sql) {ResultSet rs &＃61; null;try {if(stmt !&＃61; null) {rs &＃61; stmt.executeQuery(sql);}} catch (SQLException e) {e.printStackTrace();}return rs;}public static void executeUpdate(Statement stmt, String sql) {try {if(stmt !&＃61; null) {stmt.executeUpdate(sql);}} catch (SQLException e) {e.printStackTrace();}}public static void close(Connection conn) {try {if(conn !&＃61; null) {conn.close();conn &＃61; null;}} catch (SQLException e) {e.printStackTrace();}}public static void close(Statement stmt) {try {if(stmt !&＃61; null) {stmt.close();stmt &＃61; null;}} catch (SQLException e) {e.printStackTrace();}}public static void close(ResultSet rs) {try {if(rs !&＃61; null) {rs.close();rs &＃61; null;}} catch (SQLException e) {e.printStackTrace();}}public static void close(ResultSet rs,Statement stmt,Connection conn) {try {if(rs !&＃61; null) {rs.close();rs &＃61; null;}if(stmt !&＃61; null) {stmt.close();stmt &＃61; null;}if(conn !&＃61; null) {conn.close();conn &＃61; null;}} catch (SQLException e) {e.printStackTrace();}}}


添加地图

地图名称&＃xff1a;

地图标签&＃xff1a;

package com.smud.dao.impl;import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;import com.smud.dao.MapDAO;
import com.smud.model.Map;
import com.smud.util.DB;public class MapDAOImpl implements MapDAO {/*** 插入地图信息* * &＃64;param id* &＃64;return*/public int insert(Map map) {int count &＃61; 0;Connection conn &＃61; null;PreparedStatement pst &＃61; null;try {conn &＃61; DB.getConn();pst &＃61; conn.prepareStatement("insert into map(mapName,depict,isRootMap,lable,parentMapID) values(?,?,?,?,?)");pst.setString(1, map.getMapName());pst.setString(2, map.getDepict());pst.setInt(3, map.getIsRootMap());pst.setString(4, map.getLable());pst.setInt(5, map.getParentMapID());count &＃61; pst.executeUpdate();}catch(Exception e){e.printStackTrace();}finally{DB.close(pst);DB.close(conn);}return count;}/*** 根据地图编号查询单个地图信息* * &＃64;param id* &＃64;return*/public Map select(int id) {Map map &＃61; null;Connection conn &＃61; null;PreparedStatement pst &＃61; null;ResultSet rs &＃61; null;try {conn &＃61; DB.getConn();pst &＃61; conn.prepareStatement("select * from map where mapId&＃61;?");pst.setInt(1, id);rs &＃61; pst.executeQuery();if (rs.next()) {map &＃61; new Map();map.setMapId(rs.getInt("mapId"));map.setMapName(rs.getString("mapName"));map.setDepict(rs.getString("depict"));map.setIsRootMap(rs.getInt("isRootMap"));map.setLable(rs.getString("lable"));map.setParentMapID(rs.getInt("parentMapID"));}} catch (Exception e) {e.printStackTrace();} finally {DB.close(rs, pst, conn);}return map;}/*** 查询所有地图信息的方法* &＃64;return*/public List

package com.smud.model;public class Map {private int mapId;private String mapName;//地图名称private String depict;//地图描述private int isRootMap;//是否根地图 1---是 0---否private String lable;//地图标签private int parentMapID;//父地图idprivate String notes1;private String notes2;private String notes3;public String getNotes1() {return notes1;}public void setNotes1(String notes1) {this.notes1 &＃61; notes1;}public String getNotes2() {return notes2;}public void setNotes2(String notes2) {this.notes2 &＃61; notes2;}public String getNotes3() {return notes3;}public void setNotes3(String notes3) {this.notes3 &＃61; notes3;}public int getMapId() {return mapId;}public void setMapId(int mapId) {this.mapId &＃61; mapId;}public String getMapName() {return mapName;}public void setMapName(String mapName) {this.mapName &＃61; mapName;}public String getDepict() {return depict;}public void setDepict(String depict) {this.depict &＃61; depict;}public int getIsRootMap() {return isRootMap;}public void setIsRootMap(int isRootMap) {this.isRootMap &＃61; isRootMap;}public String getLable() {return lable;}public void setLable(String lable) {this.lable &＃61; lable;}public int getParentMapID() {return parentMapID;}public void setParentMapID(int parentMapID) {this.parentMapID &＃61; parentMapID;}}