jtds/jdbc driver na SQL server 2005 Java/Android ??Code:
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.tabhost_kupci);
try {
getKupci();
} catch (SQLException e) {
// TODO Auto-generated catch block
Log.e("",e.toString());
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
Log.e("",e.toString());
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
Log.e("",e.toString());
} catch (InstantiationException e) {
// TODO Auto-generated catch block
Log.e("",e.toString());
}
}
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.tabhost_kupci);
try {
getKupci();
} catch (SQLException e) {
// TODO Auto-generated catch block
Log.e("",e.toString());
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
Log.e("",e.toString());
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
Log.e("",e.toString());
} catch (InstantiationException e) {
// TODO Auto-generated catch block
Log.e("",e.toString());
}
}
Mene interesuje sam URL. Znam da u C# postoje i drugi parametri ("Data Source=mssql.sezamhosting.com;Initial Catalog=trbarok;Integrated Security=False;Persist Security Info=True;User ID=trbarok;Password=***********;Connect Timeout=25"). Nigde na netu ne mogu naci potpunu dokumentaciju tj. jedan primer gde su zastupljenui svi argumenti za primer Jtds driver.
Code:
public void getKupci() throws SQLException, ClassNotFoundException, IllegalAccessException, InstantiationException{
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver://mssql.sezamhosting.com;User=trbarok;Password=nnnnnnnnn");
String SQL = "SELECT * FROM tKUPCI";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(SQL);
while (rs.next()) {
TvTest.append(rs.getString("PIB"));
}
con.setAutoCommit(false);
rs.close();
stmt.close();
con.close();
}
public void getKupci() throws SQLException, ClassNotFoundException, IllegalAccessException, InstantiationException{
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver://mssql.sezamhosting.com;User=trbarok;Password=nnnnnnnnn");
String SQL = "SELECT * FROM tKUPCI";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(SQL);
while (rs.next()) {
TvTest.append(rs.getString("PIB"));
}
con.setAutoCommit(false);
rs.close();
stmt.close();
con.close();
}
Jednu stvar:"Skoro sam presao sa C# na Javu tj. i dalje radim ali nisam bas expert za Javu! :) ". Pa molim malo strpljenja (treba mi malo vise vremena). :)))).
[Ovu poruku je menjao borcha dana 27.03.2012. u 11:59 GMT+1]
