JDBC

http://blog.naver.com/seungbeomi?Redirect=Log&logNo=50031284060

package com.samsung.xoa.test.xml;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

public class TestDB

{

    Connection conn;

    public TestDB() throws Exception

    {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection("jdbc:mysql://10.88.196.248:3306/xoadb?user=xoauser&password=xoa123");

    }

    public void shutdown() throws SQLException

    {

Statement st = conn.createStatement();

st.execute("SHUTDOWN");

conn.close();

    }

    public synchronized ResultSet query(String ｅxpression) throws SQLException

    {

Statement st = null;

ResultSet rs = null;

st = conn.createStatement();

rs = st.executeQuery(ｅxpression);

return rs;

    }

    public synchronized void update(String ｅxpression) throws SQLException

    {

Statement st = null;

st = conn.createStatement();

int i = st.executeUpdate(ｅxpression);

if (i == -1)

{

   System.out.println("db error : " + ｅxpression);

}

st.close();

    }

    public static void dump(ResultSet rs) throws SQLException

    {

ResultSetMetaData meta = rs.getMetaData();

int colmax = meta.getColumnCount();

int i;

Object o = null;

for (; rs.next();)

{

   for (i = 0; i < colmax; ++i)

   {

o = rs.getObject(i + 1);

System.out.print(o.toString() + " ");

   }

   System.out.println(" ");

}

    }

}