package?com.chinasofti.ssm.biz;
import?org.apache.mahout.cf.taste.common.TasteException;
import?org.apache.mahout.cf.taste.impl.model.jdbc.MySQLJDBCDataModel;
import?org.apache.mahout.cf.taste.impl.model.jdbc.ReloadFromJDBCDataModel;
import?org.apache.mahout.cf.taste.impl.neighborhood.NearestNUserNeighborhood;
import?org.apache.mahout.cf.taste.impl.similarity.EuclideanDistanceSimilarity;
import?org.apache.mahout.cf.taste.model.DataModel;
import?org.apache.mahout.cf.taste.model.JDBCDataModel;
import?org.apache.mahout.cf.taste.neighborhood.UserNeighborhood;
import?org.apache.mahout.cf.taste.similarity.UserSimilarity;

import?com.mysql.cj.jdbc.MysqlDataSource;

import?java.sql.*;
import?java.util.ArrayList;
import?java.util.Map;

public?class?JdbcTest?{
????String?driver?=?“com.mysql.cj.jdbc.Driver“;
????String?host?=?“127.0.0.1“;
????String?user?=?“root“;
????String?password?=?“Cgsl@1234“;
????String?databasename?=?“mysql?serverTimezone=UTC“;
????String?url?=?“jdbc:mysql://localhost:3306/mysql?serverTimezone=UTC“;
????public?DataModel?getDataModel（）?throws?ClassNotFoundException?TasteException?{
????????Class.forName（driver）;
????????MysqlDataSource?dataSource?=?new?MysqlDataSource（）;
????????dataSource.setServerName（host）;
????????dataSource.setUser（user）;
????????dataSource.setPassword（password）;
????????dataSource.setDatabaseName（databasename）;
????????JDBCDataModel?jdbcDataModel?=?new?MySQLJDBCDataModel（dataSource
????????????????“usersong“?“userid“?“musicid“?“preference“?null）;
????????ReloadFromJDBCDataModel?model?=?new?ReloadFromJDBCDataModel（
????????????????jdbcDataModel）;
????????DataModel?dataModel?=?model;
????????return?dataModel;
????}
????public?Connection?getConnection（）?throws?ClassNotFoundException?SQLException?{
????????Class.forName（driver）;
????????Connection?conn?=?DriverManager.getConnection（urluserpassword）;
????????return?conn;
????}
????public?void?getUser（）?throws?SQLException?ClassNotFoundException?{
????????Connection?conn?=?getConnection（）;
????????String?sql?=?“select?*?from?test_user?where?id?=1?“;
????????Statement?stat?=?conn.createStatement（）;
????????ResultSet?rs?=?null;
????????rs?=?stat.executeQuery（sql）;
????????while（rs.next（））{
????????????String?username?=?rs.getString（“username“）;
????????????String?password?=?rs.getString（“password“）;
????????????System.out.print（“username:“+username+“password:“+password）;
????????}
????}
????public?ArrayList?getUserIds（）?throws?SQLException?ClassNotFoundException?{
????????Connection?conn?=?getConnection（）;
????????Statement?stat?=?conn.createStatement（）;
????????String?sql?=?“select?DISTINCT?userid?id?from?usersong“;
????????ResultSet?rs?=?stat.executeQuery（sql）;
????????ArrayList?ids?=?new?ArrayList（）;
????????while?（rs.next（））{
????????????if（rs.getString（“id“）?==?null）{
????????????????break;
????????????}
????????????String?id?=?rs.getString（“id“）;
????????????ids.add（id）;
????????}
????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-04-20?09:39??musicsystem\
?????目錄???????????0??2020-04-20?09:39??musicsystem\ssm_login\
?????文件????????1654??2020-04-26?17:09??musicsystem\ssm_login\.classpath
?????文件????????1218??2017-12-09?14:44??musicsystem\ssm_login\.project
?????目錄???????????0??2020-04-26?17:09??musicsystem\ssm_login\.settings\
?????文件?????????575??2017-12-09?12:25??musicsystem\ssm_login\.settings\.jsdtscope
?????文件??????????62??2020-04-16?23:25??musicsystem\ssm_login\.settings\org.eclipse.core.resources.prefs
?????文件?????????430??2017-12-09?14:44??musicsystem\ssm_login\.settings\org.eclipse.jdt.core.prefs
?????文件??????????90??2017-12-09?12:25??musicsystem\ssm_login\.settings\org.eclipse.m2e.core.prefs
?????文件?????????668??2020-04-16?23:37??musicsystem\ssm_login\.settings\org.eclipse.wst.common.component
?????文件?????????171??2020-04-26?17:09??musicsystem\ssm_login\.settings\org.eclipse.wst.common.project.facet.core.prefs.xml
?????文件?????????300??2020-04-26?17:09??musicsystem\ssm_login\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-12-09?12:25??musicsystem\ssm_login\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-12-09?12:25??musicsystem\ssm_login\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????????50??2017-12-09?12:25??musicsystem\ssm_login\.settings\org.eclipse.wst.validation.prefs
?????文件????????5365??2020-04-26?17:09??musicsystem\ssm_login\pom.xml
?????目錄???????????0??2020-04-20?09:39??musicsystem\ssm_login\src\
?????目錄???????????0??2020-04-20?09:39??musicsystem\ssm_login\src\main\
?????目錄???????????0??2020-04-20?09:39??musicsystem\ssm_login\src\main\java\
?????目錄???????????0??2020-04-20?09:39??musicsystem\ssm_login\src\main\java\com\
?????目錄???????????0??2020-04-20?09:39??musicsystem\ssm_login\src\main\java\com\chinasofti\
?????目錄???????????0??2020-04-27?20:30??musicsystem\ssm_login\src\main\java\com\chinasofti\ssm\
?????目錄???????????0??2020-04-27?20:27??musicsystem\ssm_login\src\main\java\com\chinasofti\ssm\biz\
?????目錄???????????0??2020-04-20?09:39??musicsystem\ssm_login\src\main\java\com\chinasofti\ssm\biz\impl\
?????文件????????3089??2020-04-26?17:29??musicsystem\ssm_login\src\main\java\com\chinasofti\ssm\biz\impl\MusicBizImpl.java
?????文件????????4975??2020-04-27?20:46??musicsystem\ssm_login\src\main\java\com\chinasofti\ssm\biz\impl\UserBizImpl.java
?????文件????????3027??2020-04-27?20:27??musicsystem\ssm_login\src\main\java\com\chinasofti\ssm\biz\JdbcTest.java
?????文件????????1262??2020-04-26?17:28??musicsystem\ssm_login\src\main\java\com\chinasofti\ssm\biz\MusicBiz.java
?????文件????????1051??2020-04-27?20:28??musicsystem\ssm_login\src\main\java\com\chinasofti\ssm\biz\UserBiz.java
?????目錄???????????0??2020-04-20?09:39??musicsystem\ssm_login\src\main\java\com\chinasofti\ssm\controller\
?????文件????????8067??2020-04-26?17:31??musicsystem\ssm_login\src\main\java\com\chinasofti\ssm\controller\MusicController.java
............此處省略218個文件信息