【标题】：jsp实现歌曲管理
【关键字】：jsp
【来源】：http://blog.csdn.net/zouzongfang/archive/2007/04/14/1564530.aspx

jsp实现歌曲管理

写javaBean DBhelper.java

package yjf;
import java.sql.*;

public class DBhelper
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:Music";
public Connection connect = null;
ResultSet rs = null;
public DBhelper()
{
  try
  {
   Class.forName(sDBDriver);
  }
  catch(java.lang.ClassNotFoundException e)
  {
   System.err.println( e.getMessage());
  }
}
public ResultSet executeQuery(String sql)
{
  try
  {
   connect = DriverManager.getConnection(sConnStr);
   Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
   rs = stmt.executeQuery(sql);
  }
  catch(SQLException ex)
  {
   System.err.println(ex.getMessage());
  }
  return rs;
}
public int execute(String sql)
{
  int result = 0;
  try
  {
   connect = DriverManager.getConnection(sConnStr);
   Statement stmt = connect.createStatement();
   result = stmt.executeUpdate(sql);
   connect.close();
  }
  catch(SQLException ex)
  {
   System.err.println(ex.getMessage());
  }
  return result;
}
}

然后写Song.jsp

<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="DB" class="yjf.DBhelper" scope="page" />

<%
ResultSet result=DB.executeQuery("select cMusicName,cMusicType,cSinger from song");
%>

<table width="513">
<%
while(result.next())
{
String MusicName=result.getString(1);
String MusicType=result.getString(2);
String Songer=result.getString(3);
%>
<tr> </tr>
<tr>
    <td width="130"><a href="play.jsp?MusicName=<%= MusicName%>.<%= MusicType%>" onclick="return ot(this);"><%= MusicName%></a></td>
    <td><%= MusicType%></td>
    <td width="95"><%= Songer%></td>
    <td width="95" align="center"><a href="play.jsp?MusicName=<%= MusicName%>.<%= MusicType%>" onclick="return ot(this);"><img src="%7B95D64E02-3E48-4217-84C2-1697891BB334%7D.BMP" alt="试听" border="0" /></a></td>
    <td><a href="doLook.jsp?MusicName=<%= MusicName%>&&MusicType=<%= MusicType%>&&Songer=<%= Songer%>" onclick="return ot(this);">收藏</a></td>
</tr>

<% } %>
</table>

<br><br>
<center>
<a href="lookMySong.jsp">我的音乐盒</a>
</center>

play.jsp

<%@ page contentType="text/html;charset=GBK" %>
<%
request.setCharacterEncoding("GBK");
String MusicName=request.getParameter("MusicName");
%>

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<embed src="<%= MusicName%>" loop=true width=200 height=50>
欢迎收听<%= MusicName%>
</embed>
</body>
</html>

lookMySong.jsp

<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="DB" class="yjf.DBhelper" scope="page" />

<%
ResultSet result=DB.executeQuery("select * from friend");
%>

<tr>
    <td width="98"><center><%= ID%></center></td>
    <td width="116"><a href="play.jsp?MusicName=<%= MusicName%>.<%= MusicType%>" onclick="return ot(this);"><%= MusicName%></a></td>
    <td width=90><%= MusicType%></td>
    <td width="80"><%= Songer%></td>
    <td width="100"><a href="play.jsp?MusicName=<%= MusicName%>.<%= MusicType%>" onclick="return ot(this);"><img src="%7B95D64E02-3E48-4217-84C2-1697891BB334%7D.BMP" alt="试听" border="0" /></a></td>
    <td width="50"><a href="delectSong.jsp?MusicName=<%= MusicName%>&&MusicType=<%= MusicType%>&&Songer=<%= Songer%>" onclick="return ot(this);">删除</a></td>
</tr>

<% } %>
</table>

doLook.jsp

<%@ page language="java" import="java.sql.*"%>
<%@page contentType="text/html;charset=GBK"%>
<% request.setCharacterEncoding("GBK"); %>
<jsp:useBean id="DB" class="yjf.DBhelper" scope="page" />

<%
   request.setCharacterEncoding("GBK");
   String MusicName=request.getParameter("MusicName");
   String MusicType=request.getParameter("MusicType");
   String Songer=request.getParameter("Songer");
   String SQL="insert into friend (cMusicName,cMusicType,cSonger)values('"+MusicName+"','"+MusicType+"','"+Songer+"')";
   DB.execute(SQL);

%>
添加成功

delectSong.jsp

<%@ page language="java" import="java.sql.*"%>
<%@page contentType="text/html;charset=GBK"%>
<% request.setCharacterEncoding("GBK"); %>
<jsp:useBean id="DB" class="yjf.DBhelper" scope="page" />

<%
   request.setCharacterEncoding("GBK");
   String MusicName=request.getParameter("MusicName");
   String MusicType=request.getParameter("MusicType");
   String Songer=request.getParameter("Songer");
   String SQL="delete * from friend where cMusicName='"+MusicName+"' and cMusicType='"+MusicType+"' and cSonger='"+Songer+"'";
   DB.execute(SQL);

%>
删除成功

{95D64E02-3E48-4217-84C2-1697891BB334}.BMP是一张图片作为超连接

Music.mdb是access数据库文件　需要读者自己创建并配置好数据源

在数据库里的歌曲在文件里需要读者自己添加

　　备注：

　　　　　在我自己的电脑上不能播放中文命名的歌曲，但在老师的电脑上可以播放，不知道在读者那可以播放不，自己试试吧！

java的反射机制（含数组参数）：【上一篇】
Web服务搜索与执行引擎二——相关技术的介绍：【下一篇】

【相关文章】

JSP中显示中文

struts框架生成的jsp中图像和flash动画的显示

JSP生成中文图片验证码

JSP/Servlet的重定向技术综述

jsp页面中加入flash