package com.ktv.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.ktv.pojo.Song;
public class SongDao {
public static List<Song> SELECTED_SONGS=new ArrayList<Song>();
public boolean checkSongName(Song s){
Connection conn=null;
boolean r=false;
try {
conn=ConnectionUtil.getConnection();
String sql="select * from t_song where title=?";
PreparedStatement pre=conn.prepareStatement(sql);
pre.setString(1,s.getTitle());
ResultSet rs=pre.executeQuery();
if(!rs.next()){
r=true;
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return r;
}
public boolean checkFavSong(int userId,int songId){
Connection conn=null;
boolean r=false;
try {
conn=ConnectionUtil.getConnection();
String sql="select * from t_user_song where user_id=? and song_id=?";
PreparedStatement pre=conn.prepareStatement(sql);
pre.setInt(1,userId);
pre.setInt(2,songId);
ResultSet rs=pre.executeQuery();
if(rs.next()){
r=true;
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return r;
}
//点歌
public void addSong(int id){
if(!SELECTED_SONGS.contains(findBySongId(id))){
SELECTED_SONGS.add(findBySongId(id));
}
}
//根据ID删除已点歌曲
public void delSongById(int id){
SELECTED_SONGS.remove(findBySongId(id));
}
//清除已点歌曲
public void clearSongs(){
SELECTED_SONGS.clear();
}
public static List<Song> getSELECTED_SONGS() {
return SELECTED_SONGS;
}
public static void setSELECTED_SONGS(List<Song> sELECTEDSONGS) {
SELECTED_SONGS = sELECTEDSONGS;
}
public boolean saveSong(Song s){
Connection conn=null;
int rs=0;
try {
conn=ConnectionUtil.getConnection();
String sql="insert into t_song(title,singer,class,language,src) values(?,?,?,?,?)";
PreparedStatement pre=conn.prepareStatement(sql);
pre.setString(1,s.getTitle());
pre.setString(2,s.getSinger());
pre.setInt(3,s.getClassTypeId());
pre.setInt(4,s.getLanguageId());
pre.setString(5,s.getSrc());
rs=pre.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return rs>0?true:false;
}
public int updateSongInfo(Song s){
int r=0;
Connection conn=null;
String sql="update t_song set title=?,singer=?,class=?,language=? where id=?";
try {
conn=ConnectionUtil.getConnection();
PreparedStatement pre=conn.prepareStatement(sql);
pre.setString(1,s.getTitle());
pre.setString(2,s.getSinger());
pre.setInt(3,s.getClassTypeId());
pre.setInt(4,s.getLanguageId());
pre.setInt(5,s.getId());
r=pre.executeUpdate();
if(r>0){
r=4;
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return r;
}
public int delPersonalSong(int userId,int songId){
Connection conn=null;
int rs=0;
try {
conn=ConnectionUtil.getConnection();
String sql="delete from t_user_song where user_id=? and song_id=?";
PreparedStatement pre=conn.prepareStatement(sql);
pre.setInt(1,userId);
pre.setInt(2,songId);
rs=pre.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return rs>0?4:-1;
}
public int addPersonalSong(int userId,int songId){
Connection conn=null;
int rs=0;
try {
conn=ConnectionUtil.getConnection();
if(checkFavSong(userId,songId)){
return 0;
}
String sql="insert into t_user_song(user_id,song_id) values(?,?)";
PreparedStatement pre=conn.prepareStatement(sql);
pre.setInt(1,userId);
pre.setInt(2,songId);
rs=pre.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return rs>0?4:-1;
}
public List<Song> getAllSongs(int id){
Connection conn=null;
List<Song> songs=new ArrayList<Song>();
try {
conn=ConnectionUtil.getConnection();
String sql="select * from t_song";
PreparedStatement pre=conn.prepareStatement(sql);
ResultSet rs=pre.executeQuery();
while(rs.next()){
Song song=new Song();
song.setId(rs.getInt(1));
song.setTitle(rs.getString(2));
song.setSinger(rs.getString(3));
if(rs.getInt(4)==1){
song.setClassType("轻音乐");
}else if(rs.getInt(4)==2){
song.setClassType("摇滚");
}else if(rs.getInt(4)==3){
song.setClassType("卡农");
}else{
song.setClassType("其他");
}
song.setClassTypeId(rs.getInt(4));
if(rs.getInt(5)==1){
song.setLanguage("中文");
}else if(rs.getInt(5)==2){
song.setLanguage("粤语");
}else if(rs.getInt(5)==3){
song.setLanguage("外文");
}else{
song.setLanguage("其他");
}
song.setLanguageId(rs.getInt(5));
song.setSrc(rs.getString(6));
songs.add(song);
List<Song> favSongs=new ArrayList<Song>();
favSongs=findMySongs(id);
for(Song s:songs){
if(SELECTED_SONGS.contains(s)){
s.setSelected(true);
}
if(favSongs.contains(s)){
s.setFav(true);
}
}
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return songs;
}
public List<Song> findMySongs(Integer id){
Connection conn=null;
List<Song> songs=new ArrayList<Song>();
try {
conn=ConnectionUtil.getConnection();
String sql="select * from t_user_song us left join t_song s on us.song_id=s.id where us.user_id=?";
PreparedStatement pre=conn.prepareStatement(sql);
pre.setInt(1,id);
ResultSet rs=pre.executeQuery();
while(rs.next()){
Song song=new Song();
song.setId(rs.getInt(4));
song.setTitle(rs.getString(5));
song.setSinger(rs.getString(6));
if(rs.getInt(7)==1){
song.setClassType("轻音乐");
}else if(rs.getInt(7)==2){
song.setClassType("摇滚");
}else if(rs.getInt(7)==3){
song.setClassType("卡农");
}else{
song.setClassType("其他");
}
song.setClassTypeId(rs.getInt(7));
if(rs.getInt(8)==1){
song.setLanguage("中文");
}else if(rs.getInt(8)==2){
song.setLanguage("粤语");
}else if(rs.getInt(8)==3){
song.setLanguage("外文");
}else{
song.setLanguage("其他");
}
song.setLanguageId(rs.getInt(8));
song.setSrc(rs.getString(9));
songs.add(song);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return songs;
}
public Song findBySongId(Integer id){
Connection conn=null;
Song song=new Song();
try {
conn=ConnectionUtil.getConnection();
String sql="select * from t_song where id=?";
PreparedStatement pre=conn.prepareStatement(sql);
pre.setInt(1,id);
ResultSet rs=pre.executeQuery();
if(rs.next()){
song.setId(rs.getInt(
KTV.rar （62个子文件） 
KTV src com ktv pojo 
Song.java 2KB User.java 484B dao ConnectionUtil.java 766B SongDao.java 10KB UserDao.java 4KB action UserAction.java 2KB BaseAction.java 2KB SongAction.java 4KB struts.xml 3KB .classpath 1KB db ktv.mdf 3MB ktv_log.ldf 1024KB .mymetadata 282B .settings org.eclipse.core.resources.prefs 203B org.eclipse.jdt.core.prefs 330B .myeclipse .project 1KB WebRoot play.jsp 2KB META-INF MANIFEST.MF 36B images 
75.png 11KB 59.png 10KB 68.png 9KB 64.png 8KB 79.png 7KB
test.html 713B titleSong.jsp 3KB langSong.jsp 3KB js images icons-18-black.png 2KB icons-36-white.png 4KB icons-18-white.png 2KB
ajax-loader.gif 8KB icons-36-black.png 4KB jquery-1.8.0.min.js 90KB jquery.mobile-1.3.0.min.js 141KB jquery.mobile-1.3.0.min.css 92KB jquery.mobile.theme-1.3.0.min.css 24KB video.js 62KB video-js.css 17KB index.jsp 5KB singerSong.jsp 3KB selectedSongs.jsp 2KB video 
video_01_mp4.mp4 12.25MB video_01_webm.webm 11.86MB video_01.png 1KB WEB-INF classes com ktv pojo User.class 912B Song.class 3KB dao SongDao.class 10KB ConnectionUtil.class 1KB UserDao.class 5KB action UserAction.class 3KB BaseAction.class 3KB SongAction.class 5KB struts.xml 3KB lib 
xwork-core-2.1.6.jar 1.49MB commons-fileupload-1.2.1.jar 56KB sqljdbc4.jar 571KB struts2-json-plugin-2.1.8.jar 50KB freemarker-2.3.15.jar 859KB struts2-core-2.1.8.jar 738KB struts2-dojo-plugin-2.1.8.jar 1.77MB ognl-2.7.3.jar 234KB commons-io-1.3.2.jar 86KB web.xml 750B
霸气o外漏
- 粉丝: 49
- 资源: 69
最新资源
- 神经网络 使用手写字数据集 实现分割任务 CNN
- 基于maxwell的4极6槽 内转子 11000rpm 输出转矩 156mNm 效率85% 180W 外径 48mm 内径27 轴向长度30mm 直流母线36V 永磁同步电机（永磁直流无刷）模型
- FPGA开发：SDRAM驱动代码，使用串口向sdram写数据，数据环回后被SDRAM送回到串口进行输出，中间使用FIFO进行跨时钟域处理，所用开发板DE2-115，SDRAM型号IS42S16320D
- ZTE C600&C620&C650命令参考
- python-workspace.zip.006
- FX5U FX40SSC 程序 FX5U FX 40SSC运动控制模块程序块 自己整合的针对FX 40SSC模块的功能块，支持点动故障码 状态码 相对定位 绝对定位 直接1指定轴号就可以
- 汽车二、三自由度模型 汽车二、三自由度模型 本人用了三种不同方法搭的汽车线性二自由度simulink模型，文档里包含有具体的车辆数值 适合初学者学习simulink使用(ps.模型输入为前轮转角，输出
- KUKA机器人码垛程序备份
- dbstudio-3.8.5.102.win64 神通数据库连接工具
- 开源TVBox影视盒子 小苹果影视盒子V1.5.7 2025新版
- 基于国产M0核MCU平台，全开源双电阻采样FOC高压 风机量产程序，包含龙博格电机观测器，SVPWM，顺逆风启动，五段式与七段式调制等源码，完全可以移植到别的MCU平台 适合电机算法研究
- 交替迭代法 matlab 无功优化 通过含固态变压器的无功优化算法，形成交替迭代潮流计算，最终计算出符合预期的电压曲线，程序方法包括包括牛拉法 前推回代等，参考性强
- 综合能源耦合微网优化程序matlab 程序基于冷热电联供综合能源耦合模型，采用cchp，并且含有压缩空气储能，采用粒子群优化求解
- DataGrip 2021.3 数据库连接工具
- 考虑碳交易的微网优化模型matlab
- FreeRTOS 是一款开源的、可抢占式的实时操作系统.docx
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
- 1
- 2
- 3
前往页