package?socket.conn;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

public?class?ConnOracle?{
	??private?static?Connection?getConn（）?{
	????????String?driver?=?“oracle.jdbc.driver.OracleDriver“;
	????????String?url?=?“jdbc:oracle:thin:@192.168.209.132:1521:orcl“;
	????????String?username?=?“system“;
	????????String?password?=?“tiger“;
	????????Connection?conn?=?null;
	????????try?{
	????????????Class.forName（driver）;
	????????????//?new?oracle.jdbc.driver.OracleDriver（）;
	????????????conn?=?DriverManager.getConnection（url?username?password）;
	????????}
	????????catch?（ClassNotFoundException?e）?{
	????????????e.printStackTrace（）;
	????????}
	????????catch?（SQLException?e）?{
	????????????e.printStackTrace（）;
	????????}

	????????return?conn;
	????}
	????private?static?int?insert（String?username?String?password）?{
	????????Connection?conn?=?getConn（）;
	????????int?i?=?0;
	????????String?sql?=?“insert?into?users?（usernamepassword）?values（??）“;
	????????PreparedStatement?pstmt;
	????????try?{
	????????????pstmt?=?conn.prepareStatement（sql）;
	????????????pstmt.setString（1?username）;
	????????????pstmt.setString（2?password）;
	????????????i?=?pstmt.executeUpdate（）;
	????????????System.out.println（“resutl:?“?+?i）;
	????????????pstmt.close（）;
	????????????conn.close（）;
	????????}
	????????catch?（SQLException?e）?{
	????????????e.printStackTrace（）;
	????????}
	????????return?i;
	????}

	????public?static?String?query（String?ccode）?{
	????????Connection?conn?=?getConn（）;
	????????String?sql?=?“select?*?from?coordinate?where?user_id?=“+?ccode;
	????????String?nname?=?““;
	????????PreparedStatement?pstmt;
	????????try?{
	????????????pstmt?=?conn.prepareStatement（sql）;
	????????????ResultSet?rs?=?pstmt.executeQuery（）;
	????????????while?（rs.next（））?{
	????????????????System.out.println（“user_id:?“?+?rs.getString（“user_id“）
	????????????????????????+?“?\ticon_path:?“?+?rs.getString（“icon_path“））;
	????????????????nname=rs.getString（“icon_path“）+“|“+rs.getString（“x_point“）+“|“+rs.getString（“y_point“）;
	????????????}
	????????????rs.close（）;
	????????????pstmt.close（）;
	????????????conn.close（）;
	????????}
	????????catch?（SQLException?e）?{
	????????????e.printStackTrace（）;
	????????}
	????????return?nname;
	????}
	????private?static?int?update（String?oldName?String?newPass）?{
	????????Connection?conn?=?getConn（）;
	????????int?i?=?0;
	????????String?sql?=?“update?users?set?password=‘“?+?newPass
	????????????????+?“‘?where?username=‘“?+?oldName?+?“‘“;
	????????PreparedStatement?pstmt;
	????????try?{
	????????????pstmt?=?conn.prepareStatement（sql）;
	????????????i?=?pstmt.executeUpdate（）;
	????????????System.out.println（“resutl:?“?+?i）;
	????????????pstmt.close（）;
	????????????conn.close（）;
	????????}
	????????catch?（SQLException?e）?{
	????????????e.printStackTrace（）;
	???

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-07-12?18:11??socket\
?????文件????????1164??2017-07-15?09:56??socket\.classpath
?????文件????????1331??2017-07-12?18:15??socket\.project
?????目錄???????????0??2017-07-21?15:22??socket\.settings\
?????文件?????????522??2017-07-12?18:11??socket\.settings\.jsdtscope
?????文件?????????101??2017-07-21?15:22??socket\.settings\com.genuitec.eclipse.core.prefs
?????文件?????????364??2017-07-12?18:11??socket\.settings\org.eclipse.jdt.core.prefs
?????文件?????????477??2017-07-12?18:11??socket\.settings\org.eclipse.wst.common.component
?????文件?????????414??2017-07-12?18:11??socket\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-07-12?18:11??socket\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-07-12?18:11??socket\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-07-28?15:27??socket\WebRoot\
?????文件?????????898??2017-07-28?15:45??socket\WebRoot\ClickMap.html
?????文件????????3332??2017-07-18?15:55??socket\WebRoot\Html1.html
?????目錄???????????0??2017-07-12?18:11??socket\WebRoot\meta-INF\
?????文件??????????39??2017-07-12?18:11??socket\WebRoot\meta-INF\MANIFEST.MF
?????文件????????4899??2017-07-30?14:42??socket\WebRoot\MapTest.html
?????目錄???????????0??2017-07-12?18:11??socket\WebRoot\WEB-INF\
?????目錄???????????0??2017-08-01?09:39??socket\WebRoot\WEB-INF\classes\
?????目錄???????????0??2017-08-01?09:39??socket\WebRoot\WEB-INF\classes\socket\
?????目錄???????????0??2017-08-01?09:39??socket\WebRoot\WEB-INF\classes\socket\conn\
?????文件????????3863??2017-08-01?09:39??socket\WebRoot\WEB-INF\classes\socket\conn\ConnOracle.class
?????文件????????1214??2017-08-01?09:39??socket\WebRoot\WEB-INF\classes\socket\conn\EchoEndpoint.class
?????文件????????3966??2017-08-01?09:39??socket\WebRoot\WEB-INF\classes\socket\conn\JsonConnOracle.class
?????文件????????3309??2017-08-01?09:39??socket\WebRoot\WEB-INF\classes\socket\conn\MyWebSocket.class
?????文件????????2110??2017-08-01?09:39??socket\WebRoot\WEB-INF\classes\socket\conn\WSServer.class
?????目錄???????????0??2017-07-25?14:55??socket\WebRoot\WEB-INF\lib\
?????文件??????188671??2017-07-25?11:04??socket\WebRoot\WEB-INF\lib\commons-beanutils-1.7.0.jar
?????文件??????559366??2017-07-25?11:04??socket\WebRoot\WEB-INF\lib\commons-collections-3.1.jar
?????文件??????279193??2017-07-25?11:04??socket\WebRoot\WEB-INF\lib\commons-lang-2.5.jar
?????文件???????60686??2017-07-25?11:04??socket\WebRoot\WEB-INF\lib\commons-logging-1.1.1.jar
............此處省略20個文件信息