怎样让使用代理服务器来访问MYSQL网络数据库

如题所述

第1个回答  2017-03-28
i think this should look like..
applet
jdbc-> lokal server someport

lokal sever someport
get data_for_sqlserver
embed data_for_sqlserver -> post_http_data_for_sqlserver
socket port 80-> http://yourwebserver/servlet
send post_http_data_for_sqlserver (use POST)

is this ok for u ?

remote server with servlet
getPost post_http_data_for_sqlserver
unwrap post_http_data_for_sqlserver -> data_for_sqlserver
socket-> mysql on right port
send data_for_sqlserver

receive data_from_sqlserver
embed data_from_sqlserver -> http_response_data_from_sqlserver
sendResponse http_response_data_from_sqlserver

lokal server someport
receive http_response_data_from_sqlserver
unwrap http_response_data_from_sqlserver -> data_from_sqlserver
send data_from_sqlserver

applet
jdbc.get data_from_sqlserver -> ResultSet

as you can see this is a lot of work and im not sure if you can open a
serverport in untrusted applets.
so if you can connect to port 80 without a runing webserver you can
write your own jdbc-redirect-proxy

applet
jdbc-> your jdbcproxy on port 80

jdbcproxy
get data_to_sqlserver
socket-> mysql on right port
send data_to_sqlserver
get response -> data_from_sqlserver
send data_from_sqlserver

applet
jdbc.get data_from_sqlserver -> ResultSet本回答被网友采纳