Aşağıdaki kodda insertMember bir kayit insert ediyor.
Tabi jdbcdbc:test test adında bir odbc kaynağı
yaratmanız gerekir.
import java.sql.*;
public class UpdateTest {
Connection con;
public UpdateTest(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbcdbc:test";
con = DriverManager.getConnection(****
"","");
System.out.println("connected..");
}catch(Exception e){
e.printStackTrace();
}
}
public boolean insertMember(String username,String
password)
throws Exception
{
Statement stmt=con.createStatement();
int result=stmt.executeUpdate("insert into
Members(Username,Password)
values('"+username+"','"+password+"')");
if(result==1){
return true;
}else{
return false;
}
}
public void printMembers()
throws Exception
{
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from
Members");
while(rs.next()){
int id=rs.getInt("MemberId");
String username=rs.getString("Username");
String password=rs.getString("Password");
System.out.println(id+" "+username+"
"+password);
}
}
public static void main(String[] args){
UpdateTest test=new UpdateTest();
try{
boolean
result=test.insertMember("xyz","xyz");
System.out.println(result);
test.printMembers();
}catch(Exception e){
e.printStackTrace()