cxy123884
发贴: 5
积分: 0
|
于 2005-09-22 15:00
我的程序如下: import java.sql.*;
public class DemoJDBC{ public static void main(String[] args){ String driver="sun.jdbc.odbc.JdbcOdbcDriver"; String source="jdbc:odbc:phonebook"; try{ Class.forName(driver); }catch(ClassNotFoundException exc){ System.out.println("没有发现驱动程序:"+driver); exc.printStackTrace(); System.exit(1); } try{ Connection connection=DriverManager.getConnection(source,"sa","q0l015"); SQLWarning warn=connection.getWarnings(); while(warn!=null){ System.out.println(warn.getMessage()); warn=warn.getNextWarning(); } String sql="SELECT * FROM person WHERE id=? AND birthday<=?"; PreparedStatement pStm=connection.prepareStatement(sql); pStm.setString(1,new String("leeman")); pStm.setDate(2,new Date(1970,2,2)); ResultSet result=pStm.executeQuery(); while(result.next()){ String id=result.getString("id"); String name=result.getString("name"); String sex=result.getBoolean("sex")?"女":"男"; Date birthday=result.getDate("birthday"); System.out.println(id+"\t"+name+"\t"+sex+"\t"+birthday); } result.close(); pStm.close(); Statement stm=connection.createStatement(); sql="SELECT * FROM person"; result=stm.executeQuery(sql); while(result.next()){ String id=result.getString("id"); String name=result.getString("name"); String sex=result.getBoolean("sex")?"女":"男"; Date birthday=result.getDate("birthday"); System.out.println(id+"\t"+name+"\t"+sex+"\t"+birthday); } result.close(); stm.close(); connection.close(); }catch(SQLException exc){ System.out.println("在执行数据库访问时发生错误"); exc.printStackTrace(); } } }
但是在运行的时候出现问题: java.sql.SQLException:[microsofr][ODBC SQL server Driver]没有执行可选特征 at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) at sun.jdbc.odbc.JdbcOdbc.standerError(JdbcOdbc.java:7115) at sun.jdbc.odbc.JdbcOdbc.SQLBindparamenterdate(JdbcOdbc.java:809) at sun.jdbc.odbc.JdbcOdbcPreparedstatement.setDate(JdbcOdbcpreparedstatement.java:824) at DemoJDBC.main(DemoJDBC.java:32) 我不知道是什么意思啊?求高手指点谢谢!!! 我的数据库的表如下: id char 1 name char 1 birthday datetime 8 sex char 4 address nvarchar 50 resume ntext 16
|