首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > JAVA > J2SE开发 >

java联接sql时出现错

2011-12-26 
java连接sql时出现错packageaaimportjava.sql.DriverManagerimportjava.sql.Connectionimportjava.sql.

java连接sql时出现错
package   aa;

import   java.sql.DriverManager;
import   java.sql.Connection;
import   java.sql.ResultSet;
import   java.sql.Statement;
import   java.sql.*;
import   java.sql.SQLException;
import   java.lang.*;

public   class   qq   {
    Connection   con;
    Statement   sta;
    ResultSet   rs;
    String   sqldriver;
    String   sqlurl;
    String   user;
    String   pwd;
    public   qq(){
        sqldriver= "sun.jdbc.odbc.JdbcOdbcDriver ";
        sqlurl= "jdbc:odbc:pub ";
        user= "sa ";
        pwd= " ";
        init();
    }
    public   void   init()
    {
        try{
            Class.forName(sqldriver);
            System.out.println( "driver   is   ok ");
            con=DriverManager.getConnection(sqlurl,user,pwd);
            System.out.println( "connection   is   ok ");
            sta=con.createStatement();
            rs=sta.executeQuery( "select   *   from   titles ");
            while(rs.next())
                System.out.println(rs.getDate(1));
        }catch(Exception   e)
        {
            e.printStackTrace();
        }
    }
    public   static   void   main(String[]   args)   {
        new   qq();
        }
    }


出现下面的错
D:\Borland\JBuilder2006\jdk1.5\bin\javaw   -classpath   "C:\Documents   and   Settings\Administrator\jbproject\aa\classes;D:\Borland\JBuilder2006\jdk1.5\jre\lib\jce.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\ext\localedata.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\ext\dnsns.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\ext\sunjce_provider.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\ext\sunpkcs11.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\deploy.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\charsets.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\plugin.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\im\thaiim.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\im\indicim.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\jsse.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\javaws.jar;D:\Borland\JBuilder2006\jdk1.5\jre\lib\rt.jar;D:\Borland\JBuilder2006\jdk1.5\sample\jnlp\servlet\jnlp.jar;D:\Borland\JBuilder2006\jdk1.5\sample\jnlp\servlet\jnlp-servlet.jar;D:\Borland\JBuilder2006\jdk1.5\sample\jnlp\servlet\jardiff.jar;D:\Borland\JBuilder2006\jdk1.5\lib\jconsole.jar;D:\Borland\JBuilder2006\jdk1.5\lib\dt.jar;D:\Borland\JBuilder2006\jdk1.5\lib\tools.jar;D:\Borland\JBuilder2006\jdk1.5\lib\htmlconverter.jar;D:\Borland\JBuilder2006\jdk1.5\demo\jfc\Java2D\Java2Demo.jar;D:\Borland\JBuilder2006\jdk1.5\demo\jfc\CodePointIM\CodePointIM.jar;D:\Borland\JBuilder2006\jdk1.5\demo\plugin\jfc\Java2D\Java2Demo.jar;D:\Borland\JBuilder2006\jdk1.5\demo\plugin\jfc\CodePointIM\CodePointIM.jar "     aa.qq  


driver   is   ok


java.sql.SQLException:   [Microsoft][ODBC   SQL   Server   Driver]Invalid   character   value   for   cast   specification
at   sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at   sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at   sun.jdbc.odbc.JdbcOdbc.SQLGetDataStringDate(JdbcOdbc.java:4035)
at   sun.jdbc.odbc.JdbcOdbcResultSet.getDataStringDate(JdbcOdbcResultSet.java:5745)connection   is   ok

at   sun.jdbc.odbc.JdbcOdbcResultSet.getDate(JdbcOdbcResultSet.java:949)
at   aa.qq.init(qq.java:36)
at   aa.qq. <init> (qq.java:24)
at   aa.qq.main(qq.java:43)

[解决办法]
应该是你的jb的问题
[解决办法]
con=DriverManager.getConnection(sqlurl,user,pwd);
这里抛异常啦,会不会是你的串拼错了?偶没用过sqlserver不好说啊
[解决办法]
先去看看环境是否已经搭建好,不知道你是否已经把数据源做好,jdbc odbc是需要数据源的。

热点排行