jsp - jdbc insert문 이용하기

<목차로 돌아가기>

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

Connection conn = null;
Statement stmt = null;
ResultSet rs = null;

try{
  String jdbcDriver= "jdbc:mysql://localhost:3306/testdb?useUnicode=true&characterEncoding=euckr";
  String dbuser = "testuser";
  String dbpass = "testpw";

int no = 1;
String name="홍길동";
String testid="test1";
String testpw="1234";

  String query="insert into member(no, testid, testpw, name) values('"+no+"','"+testid+"','"+testpw+"','"+name+"')" ;

  conn = DriverManager.getConnection(jdbcDriver, dbuser, dbpass);
  stmt = conn.createStatement();
  stmt.executeUpdate(query);
}
finally
{
 if (stmt != null) try {stmt.close();} catch(SQLException ex){}
 if (conn != null) try {conn.close();} catch(SQLException ex){}
}
%>

이제 다했다!!
mysql에서 테이블에 잘 들어갔는지 확인해 보자.