站内搜索: 请输入搜索关键词

当前页面: 开发资料首页Eclipse 专题关于"未发现数据源名称并且未指定默认驱动程序"问题

关于"未发现数据源名称并且未指定默认驱动程序"问题

摘要: 关于"未发现数据源名称并且未指定默认驱动程序"问题


我刚开始学Java不久,我写了个程序,可是总是出错,提示说是"未发现数据源名称并且未指定默认驱动程序";不知怎么解决,请大侠们帮忙啊,我的ODBC已经配置好了,测试已经成功了.程序如下:
package query;

import java.awt.Container;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;

import javax.swing.*;


public class QueryFrame extends JFrame implements ActionListener{
JTextField jf = new JTextField(20);
String[] value = {"姓名","部门","薪水"};
JComboBox box = new JComboBox(value);
JButton find = new JButton("查询");
JPanel panel_find = new JPanel();
JPanel panel_content = new JPanel();
java.sql.Statement stmt = null;

//图形界面初始化工作
public QueryFrame(){
this.setTitle("查询系统");
Container c = this.getContentPane();

//完成了查找界面的设置
jf.addActionListener(this);
find.addActionListener(this);
panel_find.add(jf);
panel_find.add(box);
panel_find.add(find);
c.add(panel_find,"North");
c.add(panel_content,"Center");
this.setSize(400,400);
this.setLocation(200,100);
//连接SQL Server数据库
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:MyTest", "sa", "");
stmt=conn.createStatement();
/*Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyTest";
Connection conn = DriverManager.getConnection(url,"sa","");
stmt = conn.createStatement();*/
}catch(Exception e){
System.out.println(e.toString());
//e.printStackTrace();
}
this.setVisible(true);
}
//接受并处理查询请求的方法
public void actionPerformed(ActionEvent e){
panel_content.removeAll();
String item = (String)box.getSelectedItem();
//确定用户所选择的查询依据
if(item.equals("姓名")){
item = "name";
}
if(item.equals("部门")){
item = "depatment";
}
if(item.equals("薪水")){
item = "salary";
}
//获取用户输入的查询关键字
String content = jf.getText();
int i = 0;
try{
String sql = "select * from employee";
if(!content.equals("")){
//组装查询语句
sql = sql + " where " + item + " like '%" + content + "%'";
}
//执行查询语句,并显示查询结果
ResultSet rs = null;
try{
rs = stmt.executeQuery(sql);
}catch(Exception e6){
e6.printStackTrace();
}
while(rs.next()){
int id = rs.getInt(1);
String name = rs.getString(2);
String department = rs.getString(3);
int salary = rs.getInt(4);
JLabel label = new JLabel(id + " " + name + " " + department + " " + salary);
JPanel panel = new JPanel();
panel_content.add(label);
panel_content.add(panel);
i++;
}
}catch(Exception e1){
e1.printStackTrace();
}
panel_content.setLayout(new GridLayout(i,1));
panel_content.validate();
}
public static void main(String[] args) {
new QueryFrame();

}


}
请大侠们多帮忙啊.


还有我在网上找了一个程序,出现同样的错误,不知怎么处理;
网上找的程序如下:
import java.sql.*;
public class TestOne {
public static void main(String args[]) throws Exception{

String user ="sa";
String password = "";
String ls_1="select * from sysfiles";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:MyTest",user,password);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(ls_1);
while(rs.next()) {
System.out.print(rs.getString(1) + " ");
System.out.print(rs.getString(2) + " ");
System.out.println(rs.getString(3));
}
rs.close();
st.close();
con.close();
} catch(Exception err) {
System.out.println(err.toString());
//err.printStackTrace(System.out);
}
}
}



请大侠们多帮吗啊


好了,回复一个,结贴给分


接分


↑返回目录
前一篇: Cannot create JDBC driver of class '' for connect URL 'null'
后一篇: 我这个配置文件properties,有10个参数,为什么有的参数居然在NEXT节点下?(解决就给分)