資源簡(jiǎn)介
我是用AndroidStudio寫(xiě)的Android前端,由于項(xiàng)目名稱(chēng)太大,貼不上來(lái),所以我只放了關(guān)鍵的代碼文件src,你使用直接把src里面的代碼文件粘貼到新建的Android文件中即可。后臺(tái)用的是 JavaEE+Tomcat+SQLServer。主要實(shí)現(xiàn)的功能是:Android前端的登錄(注冊(cè)沒(méi)實(shí)現(xiàn),很簡(jiǎn)單的),從后臺(tái)獲取歌曲的全部信息并展示出來(lái),以及邊下邊播(緩存)。詳情見(jiàn):https://blog.csdn.net/qq_37437983/article/details/80723981
代碼片段和文件信息
package?db;
import?java.sql.*;
public?class?DBOper?{
//數(shù)據(jù)庫(kù)驅(qū)動(dòng)配置+帳號(hào)密碼
String?url?=?“jdbc:sqlserver://localhost:1433;DatabaseName=MP3Collection“;
String?user?=?“sa“;
String?password?=?“3312081216ghXYZ“;
private?Connection?con=null;??//鏈接數(shù)據(jù)庫(kù)
private?Statement?st=null;??//可以和數(shù)據(jù)庫(kù)進(jìn)行交互
private?ResultSet?rs=null;??//返回結(jié)果集
public?DBOper()
{
try?{?????//鏈接數(shù)據(jù)庫(kù)
Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver“);
con?=?DriverManager.getConnection(urluserpassword);
}?catch?(Exception?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
public?ResultSet?exeQuery(String?sql)??//執(zhí)行查詢(xún)語(yǔ)句返回結(jié)果集
{
try?{
st?=?con.createStatement();
rs?=?st.executeQuery(sql);
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
return?rs;
}
public?void?exeUpdate(String?sql)??//數(shù)據(jù)庫(kù)內(nèi)容的更新
{
try
{
st?=?con.createStatement();
st.executeUpdate(sql);
}
catch(SQLException?e)
{
e.printStackTrace();
}
}
}
?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????目錄???????????0??2018-06-14?18:11??Mp3\
?????目錄???????????0??2018-05-29?13:10??Mp3\Mp3Manager_JavaEE\
?????文件?????????825??2018-05-29?13:10??Mp3\Mp3Manager_JavaEE\.classpath
?????文件?????????879??2018-05-29?13:10??Mp3\Mp3Manager_JavaEE\.project
?????目錄???????????0??2017-11-20?00:24??Mp3\Mp3_Android\
?????目錄???????????0??2018-06-09?07:57??Mp3\Mp3Manager_JavaEE\WebContent\
?????文件????????2210??2018-06-09?08:28??Mp3\Mp3Manager_JavaEE\WebContent\AddMp3.jsp
?????文件????????1798??2018-06-09?08:43??Mp3\Mp3Manager_JavaEE\WebContent\main.jsp
?????文件?????????101??2018-06-07?13:06??Mp3\Mp3Manager_JavaEE\WebContent\index.jsp
?????文件????????1315??2018-05-31?12:03??Mp3\Mp3Manager_JavaEE\WebContent\Welcome.jsp
?????文件????????1467??2018-06-06?08:42??Mp3\Mp3Manager_JavaEE\WebContent\userMain.jsp
?????文件????????1435??2018-06-06?08:30??Mp3\Mp3Manager_JavaEE\WebContent\addUser.jsp
?????目錄???????????0??2018-05-29?13:10??Mp3\Mp3Manager_JavaEE\build\
?????目錄???????????0??2018-06-07?10:19??Mp3\Mp3Manager_JavaEE\src\
?????目錄???????????0??2018-05-29?13:10??Mp3\Mp3Manager_JavaEE\.settings\
?????文件??????????49??2018-05-29?13:10??Mp3\Mp3Manager_JavaEE\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-05-29?13:10??Mp3\Mp3Manager_JavaEE\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件?????????555??2018-05-29?13:10??Mp3\Mp3Manager_JavaEE\.settings\.jsdtscope
?????文件?????????474??2018-05-29?13:10??Mp3\Mp3Manager_JavaEE\.settings\org.eclipse.wst.common.component
?????文件?????????357??2018-05-29?13:10??Mp3\Mp3Manager_JavaEE\.settings\org.eclipse.jdt.core.prefs
?????文件?????????335??2018-05-29?13:10??Mp3\Mp3Manager_JavaEE\.settings\org.eclipse.wst.common.project.facet.core.xm
?????目錄???????????0??2018-06-13?11:44??Mp3\Mp3_Android\main\
?????文件????????1030??2018-06-13?11:44??Mp3\Mp3_Android\main\AndroidManifest.xm
?????目錄???????????0??2017-11-20?00:24??Mp3\Mp3_Android\test\
?????目錄???????????0??2017-11-20?00:24??Mp3\Mp3_Android\androidTest\
?????目錄???????????0??2018-05-29?13:10??Mp3\Mp3Manager_JavaEE\WebContent\me
?????文件??????????39??2018-05-29?13:10??Mp3\Mp3Manager_JavaEE\WebContent\me
?????目錄???????????0??2018-05-31?13:39??Mp3\Mp3Manager_JavaEE\WebContent\WEB-INF\
?????文件????????2385??2018-06-09?14:35??Mp3\Mp3Manager_JavaEE\WebContent\WEB-INF\web.xm
?????目錄???????????0??2018-06-09?08:01??Mp3\Mp3Manager_JavaEE\WebContent\Mp3\
?????文件????14083326??2018-05-29?13:42??Mp3\Mp3Manager_JavaEE\WebContent\Mp3\zhangcheng-yuqishu.mp3
............此處省略102個(gè)文件信息
評(píng)論
共有 條評(píng)論