package first;
import java.sql.*;
public class Demo123 { /**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection ct=null;
Statement sm=null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
ct=DriverManager.getConnection("jdbc:odbc:mytext");
sm=ct.createStatement();
int i=sm.executeUpdate("delect from 123 where name='aaa'");
if(i==1){
System.out.print("添加成功");
}
else
{
System.out.print("添加失败");
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
finally
{
try {
if(sm!=null)
{
sm.close();
}
if(ct!=null)
{
ct.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}}
提示这样的错误
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]关键字 'from' 附近有语法错误。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)
at first.Demo123.main(Demo123.java:16)
import java.sql.*;
public class Demo123 { /**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection ct=null;
Statement sm=null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
ct=DriverManager.getConnection("jdbc:odbc:mytext");
sm=ct.createStatement();
int i=sm.executeUpdate("delect from 123 where name='aaa'");
if(i==1){
System.out.print("添加成功");
}
else
{
System.out.print("添加失败");
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
finally
{
try {
if(sm!=null)
{
sm.close();
}
if(ct!=null)
{
ct.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}}
提示这样的错误
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]关键字 'from' 附近有语法错误。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)
at first.Demo123.main(Demo123.java:16)
delete from 123这个123是啥?表名?
???谁有啊啊,,发我QQ邮箱里?可以么??、雷锋啊,,谢谢了,出现个雷锋啊。[email protected]
import java.sql.*;
public class Demo123 { /**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection ct=null;
Statement sm=null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
ct=DriverManager.getConnection("jdbc:odbc:mytext");
sm=ct.createStatement();
int i=sm.executeUpdate("insert inte 123 values('ccc','30')");
System.out.print("添加成功");
if(i==1){
System.out.print("添加成功");
}
else
{
System.out.print("添加失败");
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
finally
{
try {
if(sm!=null)
{
sm.close();
}
if(ct!=null)
{
ct.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}}
还是出现这样的错误
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]'123' 附近有语法错误。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)
at first.Demo123.main(Demo123.java:16)
改成
ct=DriverManager.getConnection("jdbc:odbc:mytext","","");