drivers=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://localhost:1433;
DatabaseName=studentmanager
user=sa
password=411516wwd :这个是配制文件,以下是一个程序:运行这个程序时..就是报错..NOT suitable driver..请问怎么回事呢????
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.Date;
import java.util.Properties;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.FileNotFoundException;
public class CreatTableTest
{
private Connection con;
private String url;
private String userName;
private String password;
public static void main(String[] args)
{
CreatTableTest test=new CreatTableTest();
test.getProperty();
Connection con=test.getConnection();
test.createTable(con);
test.getStudent(con);
}
public void createTable(Connection con)
{
try
{
Statement st=con.createStatement();
String sql="CREATE TABLE student(姓名 varchar(12) NOT NULL,"+"学号 varchar(10) NOT NULL,"+
"出生日期 datetime NOT NULL,专业 varchar(10) NULL,"+"籍贯 varchar(30) NULL)";
System.out.println("输出的SQL语句是:");
System.out.println(sql);
st.execute(sql);
sql="insert into student values('邱培光','20005010819','1984-9-16','英语','福建')";
st.executeUpdate(sql);
st.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
public void getStudent(Connection con)
{
try
{
Statement st=con.createStatement();
String sql="select * from student";
ResultSet rs=st.executeQuery(sql);
while(rs.next())
{
String name=rs.getString("姓名");
String number=rs.getString("学号");
Date date=rs.getDate("出生日期");
String spe=rs.getString("专业");
String address=rs.getString("籍贯");
System.out.println("\n姓名:"+name+"\t学号:"+number+"\t出生日期:"+date+"\t专业:"+spe+"\t籍贯:"+address);
st.close();
con.close();
}
}
catch (SQLException e)
{
e.printStackTrace();
}
}
public Connection getConnection()
{
try
{
con=DriverManager.getConnection(url,userName,password);
}
catch (SQLException e)
{
e.printStackTrace();
}
return con;
}
public void getProperty()
{
Properties prop=new Properties();
try
{
FileInputStream in=new FileInputStream("driver.properties");
prop.load(in);
String driver=prop.getProperty("drivers");
if(driver!=null)System.setProperty("jdbc.drivers",driver);
url=prop.getProperty("url");
userName=prop.getProperty("user");
password=prop.getProperty("password");
}
catch (FileNotFoundException e)
{
e.printStackTrace();
}
catch(IOException e)
{
e.printStackTrace();
}
}
}
url=jdbc:microsoft:sqlserver://localhost:1433;
DatabaseName=studentmanager
user=sa
password=411516wwd :这个是配制文件,以下是一个程序:运行这个程序时..就是报错..NOT suitable driver..请问怎么回事呢????
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.Date;
import java.util.Properties;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.FileNotFoundException;
public class CreatTableTest
{
private Connection con;
private String url;
private String userName;
private String password;
public static void main(String[] args)
{
CreatTableTest test=new CreatTableTest();
test.getProperty();
Connection con=test.getConnection();
test.createTable(con);
test.getStudent(con);
}
public void createTable(Connection con)
{
try
{
Statement st=con.createStatement();
String sql="CREATE TABLE student(姓名 varchar(12) NOT NULL,"+"学号 varchar(10) NOT NULL,"+
"出生日期 datetime NOT NULL,专业 varchar(10) NULL,"+"籍贯 varchar(30) NULL)";
System.out.println("输出的SQL语句是:");
System.out.println(sql);
st.execute(sql);
sql="insert into student values('邱培光','20005010819','1984-9-16','英语','福建')";
st.executeUpdate(sql);
st.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
public void getStudent(Connection con)
{
try
{
Statement st=con.createStatement();
String sql="select * from student";
ResultSet rs=st.executeQuery(sql);
while(rs.next())
{
String name=rs.getString("姓名");
String number=rs.getString("学号");
Date date=rs.getDate("出生日期");
String spe=rs.getString("专业");
String address=rs.getString("籍贯");
System.out.println("\n姓名:"+name+"\t学号:"+number+"\t出生日期:"+date+"\t专业:"+spe+"\t籍贯:"+address);
st.close();
con.close();
}
}
catch (SQLException e)
{
e.printStackTrace();
}
}
public Connection getConnection()
{
try
{
con=DriverManager.getConnection(url,userName,password);
}
catch (SQLException e)
{
e.printStackTrace();
}
return con;
}
public void getProperty()
{
Properties prop=new Properties();
try
{
FileInputStream in=new FileInputStream("driver.properties");
prop.load(in);
String driver=prop.getProperty("drivers");
if(driver!=null)System.setProperty("jdbc.drivers",driver);
url=prop.getProperty("url");
userName=prop.getProperty("user");
password=prop.getProperty("password");
}
catch (FileNotFoundException e)
{
e.printStackTrace();
}
catch(IOException e)
{
e.printStackTrace();
}
}
}
解决方案 »
- native关键字的运用
- 求求各位大侠帮忙啊 为什么一个简单的圆形动画用了双缓冲还是闪
- classloader?
- 一个简单的鼠标在窗口画点程序 编译能过 就是运行错误 谁帮我看下好么?
- 有谁了解手机游戏的开发?是不是只能用java? j2me?
- poi操作excel文件的问题,请大侠出手相助呀!!!!
- 着急呀,怎么样在jTextArea中画一幅jpg格式的图片?
- 关于UDP协议,服务器的问题!
- 请问哪里有PWS或IIS下载?
- 在VJ++6.0的环境下,当编译时,出现"Unable to update resources in file:'d:\visual Studio projects\cy1\server\server.exe". 如何解决?
- 难题!!有关java类应用...
- 算法?
你自己再试一下都改成VARCHAR(20)的就肯定没问题了
你自己测试一下看那个太小吧再根据自己的需求调一下就好了
就是驱动和连接的URL问题
应高是driver错了
可以在查询分析器中输入select @@ version
运行后如果版本低于Microsoft SQL Server 2000 - 8.00.0760
那就有可能出现这种错误的。
打了SP4补丁的话应该是8.00.2039
{
Properties prop=new Properties();
try
{
FileInputStream in=new FileInputStream("driver.properties");
prop.load(in);
driver=prop.getProperty("drivers");
if(driver!=null)System.setProperty("jdbc.drivers",driver);
url=prop.getProperty("url");
userName=prop.getProperty("user");
password=prop.getProperty("password");
}
catch (FileNotFoundException e)
{
e.printStackTrace();
}
catch(IOException e)
{
e.printStackTrace();
}
}
public Connection getConnection()
{
try
{
Class.forName().newInstance(driver);
con=DriverManager.getConnection(url,userName,password);
}
catch (SQLException e)
{
e.printStackTrace();
}
return con;
}