public class MemberVO { private String name;private int height;private int age;private int weight;private String gender; public MemberVO() {}public MemberVO(String name, int age,int height, int weight, String gender) {setName(name);setHeight(height);setAge(age);setWeight(weight);setGender(gender);} public void setName( String name){this.name = name;}public void setHeight( int height){this.height..
import java.sql.*; public class MemberDAO {private static final String DRIVER = "oracle.jdbc.driver.OracleDriver" ;//private static final String url = "jdbc:oracle:thin:@192.168.1.199:1521:orcl";private static final String USER = "scott";private static final String PWD = "tiger";private static final int DEFAULT_MIN_CONN = 5;private static final int DEFAULT_MAX_CONN = 20;private ConnectionPool cp..
import java.awt.*;import java.awt.event.*; public class Manager{Frame frame;Panel []panel;Label lblTitle,lblName,lblHeight,lblSex,lblAge,lblWeight,lblLogin,lblDialog;TextField tfName,tfHeight,tfAge,tfWeight,tfLogin;Button btnSave,btnSearch,btnDelete,btnReset,btnUpdate,btnLogin,btnDialog;Dialog login,dialog;List list;Checkbox chMale, chFemale;CheckboxGroup chGroup;String server;//support lineMemb..
import java.sql.DriverManager;import java.sql.Driver;import java.sql.Connection;import java.sql.SQLException;import java.util.List;import java.util.LinkedList;import java.util.Map;import java.util.HashMap;import java.util.Iterator; /** * This class defines a pooling mechanism for JDBC Connection objects. * * * This class provides the user with a great deal of flexibility. * The user can: * * spe..
//Filename : SelectUpDown.javaimport java.sql.*;import java.util.Properties;public class SelectUpDown {public static void main(String args[]) {try { Statement stmt; ResultSet rs; // JDBC 드라이버를 로드한다. Class.forName("oracle.jdbc.driver.OracleDriver"); // 데이터베이스에 접속한다. 적절한 JDBC URL 설정한다. Connection con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL", "javatest", "javatest"); st..
import java.sql.*;import java.util.*; class ResultApp { public static void main(String args[]) { try {Class.forName("oracle.jdbc.driver.OracleDriver"); // 데이터베이스에 접속한다. 적절한 JDBC URL 설정한다. Connection con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL", "javatest", "javatest"); Statement statement = con.createStatement(); String sql = "SELECT * FROM student"; ResultSet rs = s..
import java.sql.SQLException;public class OraCon {public static String toDB( String uni20 )throws SQLException { if ( uni20 == null ) return null; int len = uni20.length(); char[] out = new char[len]; for( int i = 0; i < len; i++ ) { char c = uni20.charAt(i); if ( c < 0xac00 || 0xd7a3 < c ) { out[i] = c; } else { // 유니코드 2.0 한글 영역 try { byte[] ksc = String.valueOf(c).getBytes("KSC5601"); if ( ks..
// Filename : JdbcTestSelectError.javaimport java.sql.*; import java.util.*; class JdbcTestSelectError { public static void main (String args []) { // JDBC 드라이버를 로드한다. try {Class.forName("oracle.jdbc.driver.OracleDriver");} catch(java.lang.ClassNotFoundException e) { System.err.print("오류 -> ClassNotFoundException: "); System.err.println(e.getMessage());System.exit(1);}try { // 데이터베이스에 접속한다. 적절한 ..
// Filename : InsertBatch.javaimport java.sql.*;import java.util.*;public class InsertBatch { public static void main(String args[]) {try { Statement stmt; ResultSet rs; // JDBC 드라이버를 로드한다.Class.forName("oracle.jdbc.driver.OracleDriver");// 데이터베이스에 접속한다. 적절한 JDBC URL 설정한다. Connection con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL", "javatest", "javatest"); stmt = con.cr..