package?com.scme.db;

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

import?javax.servlet.jsp.jstl.sql.Result;
import?javax.servlet.jsp.jstl.sql.ResultSupport;


public?class?DbHelp?
{
	private?static?final?String?DRIVER=“com.microsoft.sqlserver.“?+
			“jdbc.SQLServerDriver“;?
	private?static?final?String?URL=
			“jdbc:sqlserver://localhost:1433;DatabaseName=AndroidCloudNotes“;
	private?static?Statement?statement;
	public?static?Connection?getConnection（）
	{
	?????Connection?con=null;
	?????try{
	????	?Class.forName（DRIVER）;
	????	?con=DriverManager.getConnection（URL“sa““scce“）;
	?????}
	?????catch（Exception?e）
	?????{
	????	?e.printStackTrace（）;
	?????}
	?????return?con;
	}
	//運行有結果.無參數的SQL語句
	public?static?Result?runSelectSql（String?sql）
	{
		Connection?con=null;
		PreparedStatement?ps=null;
		ResultSet?res=null;
		Result?result=null;
		try{
			con=getConnection（）;
			ps=con.prepareStatement（sql）;
			res=ps.executeQuery（）;
			result=ResultSupport.toResult（res）;
		}
		catch（Exception?e）
		{
			e.printStackTrace（）;
		}
		finally
		{
			try
			{
				res.close（）;
				ps.close（）;
				con.close（）;
			}
			catch（Exception?e）
			{
				e.printStackTrace（）;
			}
		}
		return?result;
	}
	//運行有結果.有參數的SQL語句
	public?static?Result?runSelectSql（String?sqlobject[]?params）
	{
		Connection?con=null;
		PreparedStatement?ps=null;
		ResultSet?res=null;
		Result?result=null;
		try{
			con=getConnection（）;
			ps=con.prepareStatement（sql）;
			
			for（int?i=0;i			{
				ps.setobject（i+1?params[i]）;
			}
			res=ps.executeQuery（）;
			result=ResultSupport.toResult（res）;
		}
		catch（Exception?e）
		{
			e.printStackTrace（）;
		}
		finally
		{
			try
			{
				res.close（）;
				ps.close（）;
				con.close（）;
			}
			catch（Exception?e）
			{
				e.printStackTrace（）;
			}
		}
		return?result;
	}
	/**
	?*?運行無結果.無參數的SQL語句
	?*?@return?SQL語句執行狀態?-1執行失敗?>0執行成功
	?*?*/
	public??static?int?runUpdateSql（String?sql）?throws?SQLException
	{
		Connection?con=null;
		//PreparedStatement?ps=null;	
		int?i;
		try{
			con=getConnection（）;
//			ps=con.prepareStatement（sql）;
//			ps.executeQuery（）;
			statement=con.createStatement（）;
			i=statement.executeUpdate（sql）;
			return?i;
		}
		catch（Exception?e）
		{
			e.printStackTrace（）;
			return?-1;
		}
		finally
		{
			try
			{
				statement.close（）;
				con.close（）;
			}
			catch（Exception?e）
			{
				e.printStackTrace（）;
			}
		}
		
	}
	//運行無結果.有參數的SQL語句
	public?static?boolean?runUpdateSql（String?sqlobject[]?params）
	{
		Connection?con=null;
		PreparedStatement?ps=null;
		try{
			con=getConnection（）;
			ps=con.prepareStatement（sql）;
			for（int?i=0;i			{
				ps.setobject（i+1?params[i]）;
			}
			ps.executeUpdate（）;
			return?true;

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????445??2014-04-22?19:59??AndroidCloudNotesProject\CloudNoteServer\.classpath

?????文件????????391??2014-04-22?19:57??AndroidCloudNotesProject\CloudNoteServer\.project

?????文件????????598??2014-04-22?19:58??AndroidCloudNotesProject\CloudNoteServer\.settings\org.eclipse.jdt.core.prefs

?????文件???????4286??2014-04-22?19:59??AndroidCloudNotesProject\CloudNoteServer\bin\com\scme\db\DbHelp.class

?????文件???????1412??2014-04-22?19:59??AndroidCloudNotesProject\CloudNoteServer\bin\com\scme\db\DBQuerySql.class

?????文件???????2952??2014-04-22?19:59??AndroidCloudNotesProject\CloudNoteServer\bin\com\scme\main\MainSocketServer$StartListener$1.class

?????文件???????1067??2014-04-22?19:59??AndroidCloudNotesProject\CloudNoteServer\bin\com\scme\main\MainSocketServer$StartListener.class

?????文件???????3147??2014-04-22?19:59??AndroidCloudNotesProject\CloudNoteServer\bin\com\scme\main\MainSocketServer$ThreadServer.class

?????文件???????3005??2014-04-22?19:59??AndroidCloudNotesProject\CloudNoteServer\bin\com\scme\main\MainSocketServer.class

?????文件???????1828??2014-04-22?19:59??AndroidCloudNotesProject\CloudNoteServer\bin\com\scme\model\TableNotes.class

?????文件???????1203??2014-04-22?19:59??AndroidCloudNotesProject\CloudNoteServer\bin\com\scme\model\TableUser.class

?????文件???????3862??2014-04-22?21:14??AndroidCloudNotesProject\CloudNoteServer\bin\com\scme\server\NotesServer.class

?????文件???????3230??2014-04-22?20:32??AndroidCloudNotesProject\CloudNoteServer\bin\com\scme\server\ServerTools.class

?????文件???????2785??2014-04-22?21:05??AndroidCloudNotesProject\CloudNoteServer\bin\com\scme\server\UserServer.class

?????文件????????854??2014-04-22?19:59??AndroidCloudNotesProject\CloudNoteServer\bin\com\scme\util\GetDate.class

?????文件???????3283??2014-04-08?09:47??AndroidCloudNotesProject\CloudNoteServer\src\com\scme\db\DbHelp.java

?????文件????????947??2014-04-08?09:40??AndroidCloudNotesProject\CloudNoteServer\src\com\scme\db\DBQuerySql.java

?????文件???????5638??2014-04-22?15:59??AndroidCloudNotesProject\CloudNoteServer\src\com\scme\main\MainSocketServer.java

?????文件???????1364??2014-04-03?15:44??AndroidCloudNotesProject\CloudNoteServer\src\com\scme\model\TableNotes.java

?????文件????????880??2014-04-03?15:44??AndroidCloudNotesProject\CloudNoteServer\src\com\scme\model\TableUser.java

?????文件???????3242??2014-04-22?21:14??AndroidCloudNotesProject\CloudNoteServer\src\com\scme\server\NotesServer.java

?????文件???????2739??2014-04-22?20:32??AndroidCloudNotesProject\CloudNoteServer\src\com\scme\server\ServerTools.java

?????文件???????2308??2014-04-22?21:05??AndroidCloudNotesProject\CloudNoteServer\src\com\scme\server\UserServer.java

?????文件????????751??2014-04-06?22:41??AndroidCloudNotesProject\CloudNoteServer\src\com\scme\util\GetDate.java

?????文件???????9142??2014-04-22?22:55??AndroidCloudNotesProject\DBNotes.sql

?????文件????????475??2014-04-03?17:06??AndroidCloudNotesProject\NotesAndroidClient\.classpath

?????文件????????854??2014-04-03?17:06??AndroidCloudNotesProject\NotesAndroidClient\.project

?????文件?????????87??2014-04-06?13:21??AndroidCloudNotesProject\NotesAndroidClient\.settings\org.eclipse.core.resources.prefs

?????文件???????2161??2014-04-22?22:13??AndroidCloudNotesProject\NotesAndroidClient\AndroidManifest.xml

?????文件???????2161??2014-04-22?22:13??AndroidCloudNotesProject\NotesAndroidClient\bin\AndroidManifest.xml

............此處省略208個文件信息