
我从this博客文章中寻求帮助:
但是我发现com.MysqL.jdbc.driver类未找到异常.那篇博客文章的不同之处在于,在我的案例中,他们尝试连接到MysqL而不是MS sql.到目前为止,这是我的代码:
包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";@OverrIDeprotected 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()); } }@OverrIDepublic 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;}}请告诉我我在做什么错.我还在清单中添加了对Internet的许可.
解决方法:
从以下位置下载罐子:http://www.java2s.com/Code/Jar/s/Downloadsqljdbc430jar.htm
然后如下更改这些行:
private static final String url = "jdbc:sqlserver://Server.com:1433/DB_name";Class.forname("com.microsoft.sqlserver.jdbc.sqlServerDriver"); 总结 以上是内存溢出为你收集整理的Java-找不到com.mysql.jdbc.driver类全部内容,希望文章能够帮你解决Java-找不到com.mysql.jdbc.driver类所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)