com.mysql.jdbc.driver类未发现异常 [英] com.mysql.jdbc.driver class not found exception

问题描述

我从<一个把帮助href="http://capdroid.word$p$pss.com/2012/07/10/configuring-and-accessing-mysql-jdbc-driver-on-android-application/"相对=nofollow>这个博客文章：

不过，我得到com.mysql.jdbc.driver类未发现异常。什么是在博客文章不同的是，他们一直试图连接到MySQL，而不是MS SQL的在我的情况。这是我的code到目前为止： 包com.example.dbtry;

But I get com.mysql.jdbc.driver class not found exception. What's different in that blog post was that they've tried to connect to mysql instead of MS SQL in my case. Here's my code so far: package com.example.dbtry;

public class MainActivity extends Activity {
protected TextView tv;

private static final String url = "jdbc:jtds:sqlserver://Server.com:1433/DB_name";
private static final String user = "username";
private static final String pass = "password";



@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    testDB();
}

public void testDB() {
    tv = (TextView)findViewById(R.id.textView1);
     try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection(url, user, pass);
            /* System.out.println("Database connection success"); */

            String result = "Database connection success\n";
          tv.setText(result);
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery("select * from this_table");
            ResultSetMetaData rsmd = rs.getMetaData();

            while(rs.next()) {
                result += rsmd.getColumnName(1) + ": " + rs.getInt(1) + "\n";
                result += rsmd.getColumnName(2) + ": " + rs.getString(2) + "\n";
                result += rsmd.getColumnName(3) + ": " + rs.getString(3) + "\n";
            }
            tv.setText(result);
        }
        catch(Exception e) {
            e.printStackTrace();
            tv.setText(e.toString());
        }   

    }


@Override
public boolean onCreateOptionsMenu(Menu menu) {
    // Inflate the menu; this adds items to the action bar if it is present.
    getMenuInflater().inflate(R.menu.main, menu);
    return true;
}

}

请告诉我，我做错了。我也曾在清单中添加权限到互联网。

Please tell me what I'm doing wrong. I have also added permission to the Internet in the manifest.

推荐答案

从下载JAR：的 http://www.java2s.com/$c$c/Jar/s/Downloadsqljdbc430jar.htm 然后更改如下几行：

download the jar from: http://www.java2s.com/Code/Jar/s/Downloadsqljdbc430jar.htm then change these lines as below:

private static final String url = "jdbc:sqlserver://Server.com:1433/DB_name";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

这篇关于com.mysql.jdbc.driver类未发现异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！