import java.io.*;
import java.sql.*;
public class Demo {
public static void main(String[] args) {
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String source="jdbc:odbc:Grade";
try{
Class.forName(driver);
}catch(ClassNotFoundException exc){
System.out.print("没有发现驱动\n");
exc.printStackTrace();
System.exit(1);
}
try{
Connection con=DriverManager.getConnection(source);
SQLWarning warn=con.getWarnings();
while(warn!=null){
System.out.println(warn.getMessage());
warn=warn.getNextWarning();
}
String sql="SELECT * FROM Student WHERE num=?";
PreparedStatement pStm=con.prepareStatement(sql);
pStm.setInt(1, 104021000);
ResultSet rs=pStm.executeQuery();
while(rs.next())
System.out.println(rs.getString("name"));
String sql1="UPDATE Student SET name=Jimmy WHERE num=104021000";
Statement stm=con.createStatement();
stm.executeQuery(sql1);
}catch(SQLException exc){
System.out.println("在执行数据库时发生错误");
exc.printStackTrace();
}
}
}
==============================================================
程序如上,一个查询操作,一个更新操作,查询结果正确,更新出现异常Eclispse控制台输出为:java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
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.executeQuery(Unknown Source)
at Demo.main(Demo.java:64)
林文龙
在执行数据库时发生错误
=======================================================
这是什么意识啊,什么 参数不足,期待是 1啊这里 String sql1="UPDATE Student SET name=Jimmy WHERE num=104021000";
Statement stm=con.createStatement();
stm.executeQuery(sql1);
看不出什么错误啊,
还有那个Unknown Source是不是数据源啊,数据源已经设置了啊,查询都正确的?????????????????????
import java.sql.*;
public class Demo {
public static void main(String[] args) {
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String source="jdbc:odbc:Grade";
try{
Class.forName(driver);
}catch(ClassNotFoundException exc){
System.out.print("没有发现驱动\n");
exc.printStackTrace();
System.exit(1);
}
try{
Connection con=DriverManager.getConnection(source);
SQLWarning warn=con.getWarnings();
while(warn!=null){
System.out.println(warn.getMessage());
warn=warn.getNextWarning();
}
String sql="SELECT * FROM Student WHERE num=?";
PreparedStatement pStm=con.prepareStatement(sql);
pStm.setInt(1, 104021000);
ResultSet rs=pStm.executeQuery();
while(rs.next())
System.out.println(rs.getString("name"));
String sql1="UPDATE Student SET name=Jimmy WHERE num=104021000";
Statement stm=con.createStatement();
stm.executeQuery(sql1);
}catch(SQLException exc){
System.out.println("在执行数据库时发生错误");
exc.printStackTrace();
}
}
}
==============================================================
程序如上,一个查询操作,一个更新操作,查询结果正确,更新出现异常Eclispse控制台输出为:java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
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.executeQuery(Unknown Source)
at Demo.main(Demo.java:64)
林文龙
在执行数据库时发生错误
=======================================================
这是什么意识啊,什么 参数不足,期待是 1啊这里 String sql1="UPDATE Student SET name=Jimmy WHERE num=104021000";
Statement stm=con.createStatement();
stm.executeQuery(sql1);
看不出什么错误啊,
还有那个Unknown Source是不是数据源啊,数据源已经设置了啊,查询都正确的?????????????????????
===========================================================================
改成这样后:
林文龙
在执行数据库时发生错误
java.sql.SQLException: No ResultSet was produced
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at Demo.main(Demo.java:64)
=================================================================
???我在UPDATE Student SET name='Jimmy' WHERE num=104021000这句sql语句不会错啊
但是UPDATE Student SET name='Jimmy' WHERE num=104021000这句执行后,Student表里的name里的内容根本没变,上面用104021000找到的是“林文龙”,UPDATE后数据库里还是“林文龙”
难道UPDATE Student SET name='Jimmy' WHERE num=104021000这句有错吗,我怎么都看不出来
我用的是Access 没sql Server没发用查询分析器看,但那句怎么看都没错啊
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.SQLWarning;
import java.sql.Statement;public class Demo {
public static void main(String[] args) { String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String source = "jdbc:odbc:Grade";
try {
Class.forName(driver);
} catch (ClassNotFoundException exc) {
System.out.print("没有发现驱动\n");
exc.printStackTrace();
System.exit(1);
}
try {
Connection con = DriverManager.getConnection(source);
SQLWarning warn = con.getWarnings();
while (warn != null) {
System.out.println("warning:"+warn.getMessage());
warn = warn.getNextWarning();
}
String sql = "SELECT * FROM Student WHERE num=?";
PreparedStatement pStm = con.prepareStatement(sql);
pStm.setInt(1, 104021000);
ResultSet rs = pStm.executeQuery();
while (rs.next())
System.out.println(rs.getString("name"));
String sql2 = "UPDATE Student SET name='Jimmy' WHERE num=104021000";
Statement stm = con.createStatement();
stm.executeUpdate(sql2);
stm = con.createStatement();
rs = stm.executeQuery("SELECT * FROM Student WHERE num=104021000");
while (rs.next())
System.out.println(rs.getString("name"));
rs.close();
con.close();
} catch (SQLException exc) {
System.out.println("在执行数据库时发生错误");
exc.printStackTrace();
}
}}result in console:
Jimmy
Jimmyno problem