[Microsoft][ODBC SQL Server Driver][SQL Server]对象名 'cutomers2' 无效。
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]对象名 'cu
tomers2' 无效。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:2
53)
at Test.main(Test.java:24)
请按任意键继续. . .源程序:
import java.sql.*;
public class Test{
public static void main(String []args)
{
String url="jdbc:odbc:student";
String name,age,address,email,str;
ResultSet sr;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url,"sa","19861105");
Statement st=con.createStatement();
str="CREATE TABLE customers2 (cName VARCHAR(10),cAge SMALLINT,cAddress VARCHAR(20))";
st.executeUpdate(str);
str="ALTER TABLE customers2 ADD cEmail VARCHAR(20)";
st.executeUpdate(str);
//str="INSERT INTO customers2(cName,cAge,cAdderss)values('zhangsan',21,'chaohuxueyuan')";
//st.executeUpdate(str);
//str="INSERT INTO customers2(cName,cAge,cAdderss)values('zhangsan',26,'chaohuxueyuan')";
//st.executeUpdate(str);
str="INSERT INTO customers2(cName,cAge,cAddress,cEmail)values('zhangsan',27,'chaohuxueyuan','[email protected]')";
st.executeUpdate(str);
str="INSERT INTO customers2(cName,cAge,cAddress,cEmail)values('zhangsan',99,'chaohuxueyuan','[email protected]')";
st.executeUpdate(str);
sr=st.executeQuery("SELECT*FROM cutomers2");
while(sr.next())
{
name=sr.getString("cName");
age=sr.getString("cAge");
address=sr.getString("cAddress");
email=sr.getString("cEmail");
System.out.println(name+" "+age+" "+address+" "+email);
}
con.close();
}
catch(Exception ex){
System.out.println(ex.getMessage());
ex.printStackTrace();
}
}
}
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]对象名 'cu
tomers2' 无效。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:2
53)
at Test.main(Test.java:24)
请按任意键继续. . .源程序:
import java.sql.*;
public class Test{
public static void main(String []args)
{
String url="jdbc:odbc:student";
String name,age,address,email,str;
ResultSet sr;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url,"sa","19861105");
Statement st=con.createStatement();
str="CREATE TABLE customers2 (cName VARCHAR(10),cAge SMALLINT,cAddress VARCHAR(20))";
st.executeUpdate(str);
str="ALTER TABLE customers2 ADD cEmail VARCHAR(20)";
st.executeUpdate(str);
//str="INSERT INTO customers2(cName,cAge,cAdderss)values('zhangsan',21,'chaohuxueyuan')";
//st.executeUpdate(str);
//str="INSERT INTO customers2(cName,cAge,cAdderss)values('zhangsan',26,'chaohuxueyuan')";
//st.executeUpdate(str);
str="INSERT INTO customers2(cName,cAge,cAddress,cEmail)values('zhangsan',27,'chaohuxueyuan','[email protected]')";
st.executeUpdate(str);
str="INSERT INTO customers2(cName,cAge,cAddress,cEmail)values('zhangsan',99,'chaohuxueyuan','[email protected]')";
st.executeUpdate(str);
sr=st.executeQuery("SELECT*FROM cutomers2");
while(sr.next())
{
name=sr.getString("cName");
age=sr.getString("cAge");
address=sr.getString("cAddress");
email=sr.getString("cEmail");
System.out.println(name+" "+age+" "+address+" "+email);
}
con.close();
}
catch(Exception ex){
System.out.println(ex.getMessage());
ex.printStackTrace();
}
}
}
解决方案 »
- 我毕业后做的是IBM大型机软件开发,做了半年,觉得没啥意思,都是维护,或是些很简单的开发
- java布局中如何使控件从上到下先排好
- 这段代码帮忙分析一下
- 打开网页的时候,IE总是提示"为帮助保护您的安全, Internet Explorer已经限制此文件显示可能访问您的计算机的活动内容.请击此处查看选项"
- 急啊!!后天就要考试了,大家来帮帮忙吧,在线等
- 用structs+hibernate向mysql数据库添加数据出错
- 超难问题,不信你来瞧!!!!一百分等你拿!!!!!!!!!!!!!!!!!!!!!分不够再加!
- 请教,关于jtree的问题!!!!谢了
- 正则高手进
- 我的毕业设计是用JAVA来做一个小型绘图软件
- 大家来讨论下Java多态的实现吧!
- 接口、继承;什么时候使用接口?什么时候使用继承?为什么要使用接口?为什么要使用继承?
。
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]在关键字 '
COLUMN' 附近有语法错误。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:
288)
at Test.main(Test.java:15)
请按任意键继续. . .
import java.sql.*;
public class Test{
public static void main(String []args)
{
String url="jdbc:odbc:student";
String name,age,address,email,str;
ResultSet sr;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url,"sa","19861105");
Statement st=con.createStatement();
str="CREATE TABLE customers2 (cName VARCHAR(10),cAge SMALLINT,cAddress VARCHAR(20))";
st.executeUpdate(str);
str="ALTER TABLE customers2 ADD COLUMN cEmail VARCHAR(20)";
st.executeUpdate(str);
//str="INSERT INTO customers2(cName,cAge,cAdderss)values('zhangsan',21,'chaohuxueyuan')";
//st.executeUpdate(str);
//str="INSERT INTO customers2(cName,cAge,cAdderss)values('zhangsan',26,'chaohuxueyuan')";
//st.executeUpdate(str);
str="INSERT INTO customers2(cName,cAge,cAddress,cEmail)values('zhangsan',27,'chaohuxueyuan','[email protected]')";
st.executeUpdate(str);
str="INSERT INTO customers2(cName,cAge,cAddress,cEmail)values('zhangsan',99,'chaohuxueyuan','[email protected]')";
st.executeUpdate(str);
sr=st.executeQuery("SELECT*FROM cutomers2");
while(sr.next())
{
name=sr.getString("cName");
age=sr.getString("cAge");
address=sr.getString("cAddress");
email=sr.getString("cEmail");
System.out.println(name+" "+age+" "+address+" "+email);
}
con.close();
}
catch(Exception ex){
System.out.println(ex.getMessage());
ex.printStackTrace();
}
}
}