package kr.co.moak;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
//import org.sqlite.*;
public class MainFirst {
String DBFileName = "d:\\address.db";
public MainFirst() {}
public Connection getConn() {
Connection conn = null;
try {
Class.forName("org.sqlite.JDBC");
//SQLiteConfig config = new SQLiteConfig();
conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);//, config.toProperties())
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public boolean insert(String name, String email) {
boolean ok = false;
Connection conn = null;
PreparedStatement ps = null;
try {
conn = getConn();
String sql = "INSERT INTO taddr(last_name, email) VALUES(?, ?);";
ps = conn.prepareStatement(sql);
ps.setString(1, name);
ps.setString(2, email);
int r = ps.executeUpdate();
conn.close();
if(r > 0) {
System.out.println("저장 성공");
}
else {
System.out.println("저장 실패");
}
} catch(Exception e) {
e.printStackTrace();
}
return ok;
}
public String getEmail(String name) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
String email = "";
try {
conn = getConn();
String sql = "SELECT * FROM taddr where last_name=?;";
ps = conn.prepareStatement(sql);
ps.setString(1, name);
rs = ps.executeQuery();
if(rs.next()) {
email = rs.getString("email");
}
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return email;
}
public static void main(String[] args) {
// TODO Auto-generated method stub
MainFirst m = new MainFirst();
m.insert("hong", "hong22@jj.ac.kr");
System.out.println(m.getEmail("hong"));
}
}