IT 관련 포스팅

<Connector URIEncoding="UTF-8" connectionTimeout="20000" port="8080" protocol="org.apache.coyote.http11.HttpNioProtocol" redirectPort="8443" useComet="true" />

public class CometServlet extends HttpServlet implements CometProcessor {

public void init(){}

public void destory(){}

public void event(CometEvent event){

HttpServletRequest request = event.getHttpServletRequest();

HttpServletResponse response = event.getHttpServletResponse();

if(event.getType() == CometEvent.EventType.BEGIN){

System.out.println("Begin Comet!");

}else if(event.getType() == CometEvent.EventType.ERROR){

event.close();

}else if(event.getType() == CometEvent.EventType.END){

event.close();

}else if(event.getType() == CometEvent.EventType.READ){

event.close();

}

}

}

<script type="text/javascript" src="/js/jquery-1.10.2.js"></script>

<script type="text/javascript">

function callComet(){

$.ajax({ type:"POST",

url:CometServlet,

data:param,

dataType:"xml",

success:callBack

error:function(xhr,status,error){
    alert("error");

},

complete:function(xhr,status,error){

}

});

}

function callBack(xml){

var data = $(xml).find("data").text();

alert(data);

setTimeout(function(){callComet();},10000};    //loop

}

$(document).ready(function(){

callComet();

});

</javascript>

commons.collections4-4.0.jar

commons.dbcp-1.4.jar

commons.pool-1.6.jar

mysql-connector-java-3.0.17-ga-bin.jar

   commons.collections4-4.0.jar

   commons.dbcp-1.4.jar

   commons.pool-1.6.jar

   mysql-connector-java-3.0.17-ga-bin.jar

<resource-ref>

<description>DB Connection</description>

<res-ref-name>jdbc/test</res-ref-name>

<res-auth>Container</res-auth>

    </resource-ref>

<Context docBase="test" path="/test" .................

<Resource name="jdbc/test" ※ web.xml <res-ref-name>jdbc/test</res-ref-name> 같아야 한다

auth="Container"

type="javax.sql.DataSource"

maxActive="100"

maxIdle="30"

maxWait="10000"

username="root"

password="password"

driverClassName="com.mysql.jdbc.Driver" 

url="jdbc:mysql://localhost:3306/test />

.........</Context>

public static void main(String[] args){

InitialContext ctx = new InitialContext();

DataSource pool = (DataSource)ctx.lookup("java:comp/env/jdbc/test");

if(pool == null) {

System.out.prinltn("Unknown");

return;

}

Connection con = pool.getConnection();

Statement stmt = con.createStatement();

if(stmt != null) System.out.println("Success");

stmt.close();

con.close();

}

JAVA SQL 문법 링크 http://itposting.tistory.com/category/Java