歌曲信息管理系统实现代码：类：package com.pojo;public class Gequ {public Integer getGqid() {return gqid;}public void setGqid(Integer gqid) {this.gqid = gqid;}public String getGqname() {return gqname;}public void setGqname(String gqname) { this.gqname = gqname;}public String getGqlx() {return gqlx;}public void setGqlx(String gqlx) {this.gqlx = gqlx;}public String getYcz() {return ycz;}public void setYcz(String ycz) {this.ycz = ycz;}public String getTc() {return tc;}public void setTc(String tc) {this.tc = tc;}public String getZq() {return zq;}public void setZq(String zq) {this.zq = zq;}public String getSszj() {return sszj;}public void setSszj(String sszj) {this.sszj = sszj;}public String getGqsc() {return gqsc;}public void setGqsc(String gqsc) {this.gqsc = gqsc;}private Integer gqid;private String gqname;private String gqlx;private String ycz;private String tc;private String zq;private String sszj;private String gqsc;}Dbservice:package com.dbservice;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;import com.pojo.Gequ;public class DbService {private static Stringdriver="com.microsoft.sqlserver.jdbc.SQLServerDrive r";private static Stringurl="jdbc:sqlserver://localhost:1433;databasename= music";private static String user="sa";private static String pw="123456";private static Connection getconn(){Connection conn=null;try {Class.forName(driver);try {conn=DriverManager.getConnection(url, user, pw);} catch (SQLException e) {e.printStackTrace();}} catch (ClassNotFoundException e) {e.printStackTrace();}return conn;} public static int executesql(String sql){int result=-100;Connection conn=getconn();try {Statementsm=conn.createStatement();result=sm.executeUpdate(sql);} catch (SQLException e) {e.printStackTrace();}return result;}public static List<Map<String,String>> executeSelect(String sql){List<Map<String, String>> result=new ArrayList<Map<String,String>>();ResultSet rs=null;Connection conn=getconn();Statement sm;try {sm = conn.createStatement();rs=sm.executeQuery(sql);ResultSetMetaDatarmd=rs.getMetaData();while(rs.next()){Map<String,String> map=new HashMap<String,String>();for(intii=1;ii<=rmd.getColumnCount();ii++){map.put(rmd.getColumnName(ii),rs.getString(rmd.ge tColumnName(ii)));}result.add(map);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return result;}public static int executetransSql(List<String> list){int result=-100;Connection conn=getconn();try {conn.setAutoCommit(false);Statement sm=conn.createStatement();for(String sql:list){result=result+sm.executeUpdate(sql);}mit();} catch (SQLException e) {e.printStackTrace();try {conn.rollback();} catch (SQLException e1) {e1.printStackTrace();}}return result;}public static void main(String [] args){List<Gequ> res = new ArrayList();List<Map<String,String>> list = executeSelect("select * from gequ");for(Map map:list){Gequ gequ=new Gequ();gequ.setGqid(Integer.parseInt(map.get("gqid"). toString()));gequ.setGqname(map.get("gqname").toString() );gequ.setGqlx(map.get("gqlx").toString());gequ.setYcz(map.get("ycz").toString());gequ.setTc(map.get("tc").toString());gequ.setZq(map.get("zq").toString());gequ.setSszj(map.get("sszj").toString());gequ.setGqsc(map.get("gqsc").toString());res.add(gequ);}System.out.println(res);}}DAO:package com.gequ.dao;import java.util.List;import com.pojo.Gequ;public interface IGequDao {public int save(Gequ gequ);public int delete(Gequ gequ);public int modify(Gequ gequ);public List<Gequ> getgequ(String where);}实现DAO:import java.util.ArrayList;import java.util.List;import java.util.Map;import com.gequ.dao.IGequDao;import com.pojo.Gequ;import com.dbservice.DbService;public class GequDao implements IGequDao {@Overridepublic int save(Gequ gequ) {String sql="insert intogequ(gqid,gqname,gqlx,ycz,tc,zq,sszj,gqsc) values(";sql=sql+"'"+gequ.getGqid()+"',";sql=sql+"'"+gequ.getGqname()+"',";sql=sql+"'"+gequ.getGqlx()+"',";sql=sql+"'"+gequ.getYcz()+"',";sql=sql+"'"+gequ.getTc()+"',";sql=sql+"'"+gequ.getZq()+"',";sql=sql+"'"+gequ.getSszj()+"',";sql=sql+"'"+gequ.getGqsc()+"')";return DbService.executesql(sql);}@Overridepublic int delete(Gequ gequ) {String sql="delete from gequ wheregqid='"+gequ.getGqid()+"'";System.out.println("del:"+sql);return DbService.executesql(sql);}@Overridepublic int modify(Gequ gequ) {String sql="update gequ set ";sql=sql+"gqname='"+gequ.getGqname()+"',";sql=sql+"gqlx='"+gequ.getGqlx()+"',";sql=sql+"ycz='"+gequ.getYcz()+"',";sql=sql+"tc='"+gequ.getTc()+"',";sql=sql+"zq='"+gequ.getZq()+"',";sql=sql+"sszj='"+gequ.getSszj()+"',";sql=sql+"gqsc='"+gequ.getGqsc()+"' where gqid="+gequ.getGqid();System.out.println("upsql"+sql);return DbService.executesql(sql);}@Overridepublic List<Gequ> getgequ(String where) {List<Gequ> result=new ArrayList<Gequ>();String sql="select * from gequ";if(!"".equals(where)){sql=sql+" where "+where;}System.out.println("sql:"+sql);List<Map<String, String>>list=DbService.executeSelect(sql);System.out.println("list"+list);for(Map map:list){Gequ gequ=new Gequ();gequ.setGqid(Integer.parseInt(map.get("gqid"). toString()));gequ.setGqname(map.get("gqname").toString() );gequ.setGqlx(map.get("gqlx").toString());gequ.setYcz(map.get("ycz").toString());gequ.setTc(map.get("tc").toString());gequ.setZq(map.get("zq").toString());gequ.setSszj(map.get("sszj").toString());gequ.setGqsc(map.get("gqsc").toString());result.add(gequ);}return result;}}Service:import com.pojo.Gequ;public interface IGequService {public int add(Gequ gequ);public int del(Integer gqid);public int up(Gequ gequ);public Gequ getgequ(Integer gqid);public List<Gequ> getlsit(String where);}Service实现：import java.util.List;import com.gequ.service.IGequService; import com.pojo.Gequ;import com.gequ.dao.IGequDao;import com.gequ.dao.impl.GequDao;public class GequService implements IGequService {private IGequDao gqDao=new GequDao();@Overridepublic int add(Gequ gequ) {return this.gqDao.save(gequ);}@Overridepublic int del(Integer gqid) {returnthis.gqDao.delete(this.getgequ(gqid));}@Overridepublic int up(Gequ gequ) {return this.gqDao.modify(gequ);}@Overridepublic Gequ getgequ(Integer gqid) { returnthis.getlsit("gqid='"+gqid+"'").get(0);}@Overridepublic List<Gequ> getlsit(String where) {returnthis.gqDao.getgequ(where);}}Sevlet:package com.controller;import java.io.IOException;import java.io.PrintWriter;import java.util.List;import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; importjavax.servlet.http.HttpServletRequest; importjavax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession;import com.pojo.Gequ;import com.gequ.service.IGequService; importcom.gequ.service.impl.GequService;public class GequManagerServlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {this.doPost(request, response);}public voiddoPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {HttpSessionsession=request.getSession(true);IGequService gqService=new GequService();List<Gequ> list=gqService.getlsit("");request.setAttribute("list", list);request.getRequestDispatcher("gequm anager.jsp").forward(request, response);}}Jsp:<body><center><table border="1"width="90%" cellpadding="0"cellspacing="0"><tr><td colspan="9"align="center" bgcolor=#89CFF0><h3>音乐信息管理</h3></td></tr><tr><td colspan="9"align="right" height="47px"bgcolor=#89CFF0><a href="addgequ.jsp">新增音乐信息</a></td></tr><tr><th>歌曲编号</th><th>歌曲名称</th><th>歌曲类型</th><th>演唱者</th><th>填词</th><th>作曲</th><th>所属专辑</th><th>歌曲时长</th><th>操作</th></tr><%for (Gequ gequ : list) {%><tr><td align="center"height="37px"><%=gequ.getGqid()%></td><tdalign="center"><%=gequ.getGqname()%></td><tdalign="center"><%=gequ.getGqlx()%></td><tdalign="center"><%=gequ.getYcz()%></td><tdalign="center"><%=gequ.getTc()%></td><tdalign="center"><%=gequ.getZq()%></td><tdalign="center"><%=gequ.getSszj()%></td><tdalign="center"><%=gequ.getGqsc()%></td><td align="center"><ahref="FindGequServlet?gqid=<%=gequ.getGqid()%>">修改</a><ahref="DelGequServlet?gqid=<%=gequ.getGqid() %>">删除</a></td></tr><%}%></table></center></body>。