java连接access运行错误!在线等!
wjazz 2006-10-13 02:17:02 import java.io.*;
import java.net.*;
import java.sql.*;
public class Test
{
public static void main(String[] args)
{
try
{
System.out.println("1");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//装载数据库连接驱动
String connstr ="jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=QQ.mdb";//注意空格
Connection conn2=DriverManager.getConnection(connstr,"","");
System.out.println("2");
String newsql="insert into users(password,username,age,sex,email,info) values(?,?,?,?,?,?)";
System.out.println("2");
PreparedStatement p2=conn2.prepareCall(newsql);
p2.clearParameters();
p2.setString(1,"123456");
p2.setString(2,"wjazz");
p2.setString(3,"20");
p2.setString(4,"男");
p2.setString(5,"ball-202@tom.com");
p2.setString(6,"拉萨建立发射机了");
int r2=p2.executeUpdate();
System.out.println(r2);
}catch(Exception e)
{
System.err.println(e.getMessage());
}
}
}
运行这段代码,编译没错,但是运行时抛出下列异常:
[Microsoft][ODBC 驱动程序管理器]未发现数据源名称并且未指定默认驱动程序
希望大家给我点意见..