JAVA2015. 2. 5. 14:28

package kr.laby.postgresql.controller;


import java.sql.Connection;

PostgreSQL_Sample.zip


import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import java.util.Properties;


import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;


@Controller

public class Test {

@RequestMapping("/test")

public String test() {

try {

//Loading the Driver

Class.forName("org.postgresql.Driver");

String url = "jdbc:postgresql://10.211.55.12/wonword";

Properties props = new Properties();

props.setProperty("user", "postgres");

props.setProperty("password", "qlalf");

//Connecting to the Database

Connection conn = DriverManager.getConnection(url, props);

Statement st = conn.createStatement();

// ResultSet rs = st.executeQuery("SELECT * FROM test");

// while (rs.next()) {

//    System.out.println(rs.getString(1));

// }

// rs.close();

int r;

for (int i=0 ; i<1000 ; i++){

r = st.executeUpdate("INSERT INTO TEST (ID) VALUES (" + i + ");");

System.out.println(r);

}

st.close();

//Closing the Connection

conn.close();

} catch (Exception e) {

// TODO: handle exception

System.out.println(e);

}

return "test";

}

}



Posted by 원찬식