String path=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:OKDataBase");
Statement stmt=con.createStatement();
String sql="SELECT pathway FROM SongSystem WHERE SongName=(SELECT songName FROM ClickedSong WHERE ClickedSongID=0);";
ResultSet url=stmt.executeQuery(sql);
//String tmp;
//tmp = url.getNString( 0 );
//System.out.println( "file" + tmp );
File file = new File(path);
// 获取MIDI音乐的内容流
currentSound = MidiSystem.getSequence(file);
// 获取MIDI音乐的流播放器
player = MidiSystem.getSequencer();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:OKDataBase");
Statement stmt=con.createStatement();
String sql="SELECT pathway FROM SongSystem WHERE SongName=(SELECT songName FROM ClickedSong WHERE ClickedSongID=0);";
ResultSet url=stmt.executeQuery(sql);
//String tmp;
//tmp = url.getNString( 0 );
//System.out.println( "file" + tmp );
File file = new File(path);
// 获取MIDI音乐的内容流
currentSound = MidiSystem.getSequence(file);
// 获取MIDI音乐的流播放器
player = MidiSystem.getSequencer();
{
//songName是varchar
path=url.getString(0);
}
// 获取MIDI音乐的内容流
这个是用来播放音乐的必要的路径。
执行出错误:[Microsoft][ODBC 驱动程序管理器] 无效的描述器索引
ResultSet url=stmt.executeQuery(sql);
while(url.next())
{
//songName是varchar,如果你的数据库中这个songname不是varchar类型 取出来后你在转换下,。。
path=url.getString(0);
}
总算输出了!!!F:\\music\\music.mid
我把pathway这一列放到了第二列。
ResultSet url=stmt.executeQuery(sql);
url.next();
//pathway是varchar
path=url.getString(1);
System.out.println(path);