初学Jdbc odbc的数据源在windows控制面板->管理工具->数据源添加一个系统数据源就行了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 找本VB,delphi什么的书,必有教你odbc的章节 要看楼主使用的是什么jdbc了如果使用的是jdbc-odbc桥,那么就去设置odbc源如果是直接连数据库的jdbc就不需要设置odbc了 odbc数据源设置: 控制面板——》管理工具——》数据源(ODBC)——》用户DSN——》添加 然后选择你要用的数据库的驱动,其实就是你用的什么数据库,然后就是具体的设置你想要的东西,例如名称,端口等*********************************************************************************具体的代码就仔细看书了,书上应该是很详细。*********************************************************************************Good luck! 呀,,还有不用odbc 的jdbc 吗? 能不能详细点呀,,,, 谢谢,!!! oracle和sqlserver都提供jdbc下载,都是直接连接数据库就可以了 http://otn.oracle.com/software/tech/java/sqlj_jdbc/index.html 关于jdbc的简单说明http://www-900.ibm.com/developerWorks/cn/java/jdbc-objects/index.shtml 晕~~~~~~~~ 我已在你们说的"管理工具——》数据源(ODBC)——》用户DSN——》添加"里设置了odbc 数据源,但是还有错误,我的程序:import java.awt.*;import java.sql.*;public class Application1 { Frame frame = null; TextArea text; public Application1() { frame = new Frame(); text = new TextArea(); frame.add(text); frame.setVisible(true); frame.setSize(500,500); frame.pack(); } public static void main(String args[]) { Application1 app = new Application1(); String name, xuehao; Date date; int math, physics, english; Connection con; Statement sql; ResultSet rs; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e){ app.text.append("错误1"); } try { con = DriverManager.getConnection("jdbc:odbc:abc", "", ""); sql = con.createStatement(); rs = sql.executeQuery("SELECT * FROM chengjibiao"); while (rs.next()) { name = rs.getString(2); xuehao = rs.getString(1); date = rs.getDate(3); math = rs.getInt("数学"); physics = rs.getInt("物理"); english = rs.getInt("英语"); app.text.append("姓名" + name + " " + "\n"); app.text.append("学号" + xuehao + " " + "\n"); app.text.append("出生" + date.toString() + " " + "\n"); app.text.append("数学" + math + " " + "\n"); app.text.append("英语" + String.valueOf(physics) + " " + "\n"); app.text.append("物理" + String.valueOf(english) + " " + "\n"); app.text.append(" ." + "\n"); } rs = sql.executeQuery("SELECT *FROM chengjibiao WHERE 学号='4'"); while (rs.next()) { name = rs.getString(2); xuehao = rs.getString(1); date = rs.getDate(3); math = rs.getInt("数学"); physics = rs.getInt("物理"); english = rs.getInt("英语"); app.text.append("姓名" + name + " " + "\n"); app.text.append("学号" + xuehao + " " + "\n"); app.text.append("出生" + date.toString() + " " + "\n"); app.text.append("数学" + math + " " + "\n"); app.text.append("英语" + String.valueOf(physics) + " " + "\n"); app.text.append("物理" + String.valueOf(english) + " " + "\n"); app.text.append(" ." + "\n"); } rs = sql.executeQuery("SELECT * FROM chengjibiao WHERE 英语>=90"); while (rs.next()) { name = rs.getString(2); xuehao = rs.getString(1); date = rs.getDate(3); math = rs.getInt("数学"); physics = rs.getInt("物理"); english = rs.getInt("英语"); app.text.append("姓名" + name + " " + "\n"); app.text.append("学号" + xuehao + " " + "\n"); app.text.append("出生" + date.toString() + " " + "\n"); app.text.append("数学" + math + " " + "\n"); app.text.append("英语" + String.valueOf(physics) + " " + "\n"); app.text.append("物理" + String.valueOf(english) + " " + "\n"); app.text.append(" ." + "\n"); } con.close(); } catch (SQLException e1) {app.text.append("有错误啦!!!!"); } }}谁能帮我调试一下,,,,谢谢了......... java线程出错 高手们帮帮忙,快两天了5 FTP下载文件问题(按文件创建的时间下载) 数字格式化的问题.0的时候如何不显示? 请问那里有JTest下载 ??? Help Applet !!!!!!!!!!!!关于在面板中拖动图片!!!!!!!!!!!!!!!1111 如何调用在.jar文件中的类,是微软出的jdbc for sql server的接口 100分求Applet的实例(先放50) 想用JDataStore,但是不知道license,请高手告知,不胜感激! 初学java,选用什么书? 學java的時候有沒有類似MSDN的幫助文檔什麼的?
如果使用的是jdbc-odbc桥,那么就去设置odbc源如果是直接连数据库的jdbc就不需要设置odbc了
控制面板——》管理工具——》数据源(ODBC)——》用户DSN——》添加
然后选择你要用的数据库的驱动,其实就是你用的什么数据库,然后就是具体的设置你想要的东西,例如名称,端口等*********************************************************************************具体的代码就仔细看书了,书上应该是很详细。*********************************************************************************Good luck!
谢谢,!!!
http://www-900.ibm.com/developerWorks/cn/java/jdbc-objects/index.shtml
我已在你们说的"管理工具——》数据源(ODBC)——》用户DSN——》添加"里设置了odbc 数据源,但是还有错误,我的程序:
import java.awt.*;
import java.sql.*;public class Application1 {
Frame frame = null;
TextArea text;
public Application1() {
frame = new Frame();
text = new TextArea();
frame.add(text);
frame.setVisible(true);
frame.setSize(500,500);
frame.pack();
} public static void main(String args[]) {
Application1 app = new Application1(); String name, xuehao;
Date date;
int math, physics, english;
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){
app.text.append("错误1");
}
try {
con = DriverManager.getConnection("jdbc:odbc:abc", "", "");
sql = con.createStatement();
rs = sql.executeQuery("SELECT * FROM chengjibiao"); while (rs.next()) {
name = rs.getString(2);
xuehao = rs.getString(1);
date = rs.getDate(3);
math = rs.getInt("数学");
physics = rs.getInt("物理");
english = rs.getInt("英语");
app.text.append("姓名" + name + " " + "\n");
app.text.append("学号" + xuehao + " " + "\n");
app.text.append("出生" + date.toString() + " " + "\n");
app.text.append("数学" + math + " " + "\n");
app.text.append("英语" + String.valueOf(physics) + " " + "\n");
app.text.append("物理" + String.valueOf(english) + " " + "\n");
app.text.append(" ." + "\n");
}
rs = sql.executeQuery("SELECT *FROM chengjibiao WHERE 学号='4'");
while (rs.next()) {
name = rs.getString(2);
xuehao = rs.getString(1);
date = rs.getDate(3);
math = rs.getInt("数学");
physics = rs.getInt("物理");
english = rs.getInt("英语");
app.text.append("姓名" + name + " " + "\n");
app.text.append("学号" + xuehao + " " + "\n");
app.text.append("出生" + date.toString() + " " + "\n");
app.text.append("数学" + math + " " + "\n");
app.text.append("英语" + String.valueOf(physics) + " " + "\n");
app.text.append("物理" + String.valueOf(english) + " " + "\n");
app.text.append(" ." + "\n");
} rs = sql.executeQuery("SELECT * FROM chengjibiao WHERE 英语>=90");
while (rs.next()) {
name = rs.getString(2);
xuehao = rs.getString(1);
date = rs.getDate(3);
math = rs.getInt("数学");
physics = rs.getInt("物理");
english = rs.getInt("英语");
app.text.append("姓名" + name + " " + "\n");
app.text.append("学号" + xuehao + " " + "\n");
app.text.append("出生" + date.toString() + " " + "\n");
app.text.append("数学" + math + " " + "\n");
app.text.append("英语" + String.valueOf(physics) + " " + "\n");
app.text.append("物理" + String.valueOf(english) + " " + "\n");
app.text.append(" ." + "\n");
} con.close();
}
catch (SQLException e1) {
app.text.append("有错误啦!!!!");
}
}
}
谁能帮我调试一下,,,,谢谢了.........