PDA

View Full Version : مشکل در ضرب دو ستون دیتابیس اکسس در جاوا



Yama12
سه شنبه 15 شهریور 1390, 13:57 عصر
سلام
من تو جاوا از این کد برای ضرب دو تا ستون در هم استفاده می کنم اما خطای زیر رو میده در حالی که در خود sql جواب درست میده ( اون خطی که با بقیه فاصله داره)




Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String Database="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";

Database += FilePath.trim()+";DriverID=22;READONLY=true}";

Connection con = DriverManager.getConnection(Database, "", "");

Statement st2 =con.createStatement();
st2.execute(" SELECT DISTINCT temp1.vamOwnerAccount," +
" temp1.VamOwner," +
" temp1.LngVamID,"+
" temp1.zamenAccount," +
" temp1.AghsatAghabOftade," +
" temp1.OwnerMobile," +
" temp1.OwnerHomeTell," +
" temp1.OwnerAddress," +
" temp1.MablagheVam," +
" temp1.MablagheGHest," +
" temp1.MandeVam," +
" TblPersonInfo.StrFName AS zamenFname, "+
" TblPersonInfo.StrLName AS zamenLName," +
" TblPersonInfo.StrPhoneMobile AS ZamenMobile,"+
" TblPersonInfo.StrAddressMahallekar AS ZamenAddress,"+
" TblPersonInfo.StrPhoneManzel AS ZamenHomeTell"+
"temp1.AghsatAghabOftade * temp1.MablagheGHest AS Moavagh "+
" INTO SMS"+
" FROM (temp1 INNER JOIN"+
" TblPersonInfo ON temp1.zamenAccount = TblPersonInfo.LngAccountNumber)");



اینم خطا:


java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.