package kr.laby.postgresql.controller;
import java.sql.Connection;
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";
}
}