Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void main(String[] args) throws Exception {
- Connection connection = getMySqlConnection();
- CallableStatement proc = connection.prepareCall("{ call LCD_GetDispInfoAllTimeTable() }");
- proc.registerOutParameter(1, Types.INTEGER);
- proc.execute();
- int returnValue = proc.getInt(1);
- System.out.println(returnValue + "");
- // conn.close();
- }
- public static Connection getMySqlConnection() throws Exception {
- String driver = "com.mysql.jdbc.Driver";
- String url = "";
- String username = "";
- String password = "";
- Class.forName(driver);
- Connection conn = DriverManager.getConnection(url, username, password);
- return conn;
- }
- }
- Niemstów 07 pętla 10 05:33:00 3673114 11558169 754378 1
- NŻ Niemstów 05 16 05:35:00 3669905 11556510 754379 3
- NŻ Niemstów 03 16 05:37:00 3666969 11555665 754380 3
- CREATE DEFINER=`root`@`%` PROCEDURE `LCD_GetDispInfoAllTimeTable`()
- BEGIN
- SELECT bs.name as bsName, tt.busstoptype as bsType, tt.time as ttTime, bs.longitude as lon, bs.latitude as lat, tt.timetable_id as ttID,
- Bus_Stop_Status_GET( tt.timetable_id, bst.timetable_id, bst.busstate_id ) as bus_stop_status -- 0 zrobiony, 1 - aktualny, 2- pomiędzy, 3 następne
- FROM (SELECT * FROM mpk_currentbusstate ORDER BY changestime desc LIMIT 1 )bst
- join mpk_timetable t ON( bst.timetable_id = t.timetable_id )
- join mpk_timetable tt ON ( t.linelogin_id = tt.linelogin_id AND t.line_id = tt.line_id AND t.brigade = tt.brigade AND t.rate = tt.rate
- and t.schedudle_id = tt.schedudle_id)
- LEFT JOIN mpk_busstop bs ON (bs.busstop_id = tt.busstop_id)
- LEFT JOIN mpk_busstate bt ON( bst.busstate_id = bt.busstate_id );
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement