sara_traveler
شنبه 27 مهر 1392, 11:09 صبح
من یک کلاس دارم که اینطوری تعریف کردم
public class sql {
public void query3(String sql,String sql1)
{
Log.i("Android"," MySQL Connect Example.");
Connection conn = null;
try {
String driver = "net.sourceforge.jtds.jdbc.Driver";
Class.forName(driver).newInstance();
//test = com.microsoft.sqlserver.jdbc.SQLServerDriver.class ;
String connString = "jdbc:jtds:sqlserver://192.168.1.126:1433/jahd6;user=sina;password=1389;";//;instance=SQLExpress
String username = "sina";
String password = "1389";
conn = DriverManager.getConnection(connString,username,pa ssword);
Log.w("Connection","open");
Statement stmt = conn.createStatement();
stmt.execute(sql) ;
ResultSet reset = stmt.executeQuery(sql1);
//Print the data to the console
while(reset.next()){
Log.w("Data:",reset.getString("name"));
//T.setText(T.getText() + " : " + reset.getString("name"));
}
conn.close();
} catch (Exception e)
{
Log.w("Error connection","" + e.toString());
}
}
بعد در صفحه اصلیم وقتی فراخونی میکنم خطا میده
s="insert into a (name) values ('f')";
s1="select * from a ";
sql. query3(s, s1)
الان در خط sql. query3(s, s1) به خطا میخوره
public class sql {
public void query3(String sql,String sql1)
{
Log.i("Android"," MySQL Connect Example.");
Connection conn = null;
try {
String driver = "net.sourceforge.jtds.jdbc.Driver";
Class.forName(driver).newInstance();
//test = com.microsoft.sqlserver.jdbc.SQLServerDriver.class ;
String connString = "jdbc:jtds:sqlserver://192.168.1.126:1433/jahd6;user=sina;password=1389;";//;instance=SQLExpress
String username = "sina";
String password = "1389";
conn = DriverManager.getConnection(connString,username,pa ssword);
Log.w("Connection","open");
Statement stmt = conn.createStatement();
stmt.execute(sql) ;
ResultSet reset = stmt.executeQuery(sql1);
//Print the data to the console
while(reset.next()){
Log.w("Data:",reset.getString("name"));
//T.setText(T.getText() + " : " + reset.getString("name"));
}
conn.close();
} catch (Exception e)
{
Log.w("Error connection","" + e.toString());
}
}
بعد در صفحه اصلیم وقتی فراخونی میکنم خطا میده
s="insert into a (name) values ('f')";
s1="select * from a ";
sql. query3(s, s1)
الان در خط sql. query3(s, s1) به خطا میخوره