歌曲信息管理系统

歌曲信息管理系统实现代码：

类：

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 String

driver="com.microsoft.sqlserver.jdbc.SQLServerDrive r";

private static String

url="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 {

Statement

sm=conn.createStatement();

result=sm.executeUpdate(sql);

} catch (SQLException e) {

e.printStackTrace();

}

return result;

}

public static List> executeSelect(String sql){

List> result=new ArrayList>();

ResultSet rs=null;

Connection conn=getconn();

Statement sm;

try {

sm = conn.createStatement();

rs=sm.executeQuery(sql);

ResultSetMetaData

rmd=rs.getMetaData();

while(rs.next()){

Map map=new HashMap();

for(int

ii=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 block

e.printStackTrace();

}

return result;

}

public static int executetransSql(List list){

int result=-100;

Connection conn=getconn();

try {

conn.setAutoCommit(false);

Statement sm=conn.createStatement();

for(String sql:list){

result=result+sm.executeUpdate(sql);

}

https://www.360docs.net/doc/0317137637.html,mit();

} catch (SQLException e) {

e.printStackTrace();

try {

conn.rollback();

} catch (SQLException e1) {

e1.printStackTrace();

}

}

return result;

}

public static void main(String [] args){

List res = new ArrayList();

List> 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 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 {

@Override

public int save(Gequ gequ) {

String sql="insert into

gequ(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);

}

@Override

public int delete(Gequ gequ) {

String sql="delete from gequ where

gqid='"+gequ.getGqid()+"'";

System.out.println("del:"+sql);

return DbService.executesql(sql);

}

@Override

public 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);

}

@Override

public List getgequ(String where) {

List result=new ArrayList();

String sql="select * from gequ";

if(!"".equals(where)){

sql=sql+" where "+where;

}

System.out.println("sql:"+sql);

List>

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 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();

@Override

public int add(Gequ gequ) {

return this.gqDao.save(gequ);

}

@Override

public int del(Integer gqid) {

return

this.gqDao.delete(this.getgequ(gqid));

}

@Override

public int up(Gequ gequ) {

return this.gqDao.modify(gequ);

}

@Override

public Gequ getgequ(Integer gqid) { return

this.getlsit("gqid='"+gqid+"'").get(0);

}

@Override

public List getlsit(String where) {

return

this.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; import

javax.servlet.http.HttpServletRequest; import

javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession;

import com.pojo.Gequ;

import com.gequ.service.IGequService; import

com.gequ.service.impl.GequService;

public class GequManagerServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

this.doPost(request, response);

}

public void

doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

HttpSession

session=request.getSession(true);

IGequService gqService=new GequService();

List list=gqService.getlsit("");

request.setAttribute("list", list);

request.getRequestDispatcher("gequm anager.jsp").forward(request, response);

}

}

Jsp:

<%

for (Gequ gequ : list) {

%>

align="center"><%=gequ.getGqname()%>

align="center"><%=gequ.getGqlx()%>

align="center"><%=gequ.getYcz()%>

align="center"><%=gequ.getTc()%>

align="center"><%=gequ.getZq()%>

align="center"><%=gequ.getSszj()%>

align="center"><%=gequ.getGqsc()%>

<%

}

%>

音乐信息管理
新增音乐信息
歌曲编号	歌曲名称	歌曲类型	演唱者	填词	作曲	所属专辑	歌曲时长	操作
height="37px"><%=gequ.getGqid()%>	href="FindGequServlet?gqid=<%=gequ.getGqid()%>">修改 href="DelGequServlet?gqid=<%=gequ.getGqid() %>">删除