import java.sql.*;
public class DBConnection
{
private Connection conn;
public DBConnection()
{
this.connect();
}
public boolean connect()
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:414;DatabaseName=Register_Login";
String user="sa";
String password="";
conn=DriverManager.getConnection(url,user,password);
}catch(Exception e){
System.out.println("connect db error:"+e.getMessage());
return false;
}
return true;
}
public static void main(String args[])
{
try{
DBConnection db=new DBConnection();
db.connect();
}catch(Exception e){
e.printStackTrace();
}
}
}
运行结果:
connect db error:com.microsoft.jdbc.sqlserver.SQLServerDriver
connect db error:com.microsoft.jdbc.sqlserver.SQLServerDriver
public class DBConnection
{
private Connection conn;
public DBConnection()
{
this.connect();
}
public boolean connect()
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:414;DatabaseName=Register_Login";
String user="sa";
String password="";
conn=DriverManager.getConnection(url,user,password);
}catch(Exception e){
System.out.println("connect db error:"+e.getMessage());
return false;
}
return true;
}
public static void main(String args[])
{
try{
DBConnection db=new DBConnection();
db.connect();
}catch(Exception e){
e.printStackTrace();
}
}
}
运行结果:
connect db error:com.microsoft.jdbc.sqlserver.SQLServerDriver
connect db error:com.microsoft.jdbc.sqlserver.SQLServerDriver
解决方案 »
- 你都用什么TableModel
- java.lang.Throwable: Socket is closed
- 菜鸟求助:java程序实现改变当前windows的壁纸?
- 读取txt文件,怎么保证将格式(换行符)读取进来,然后向另外一个文件保持原格式输出呢?
- 如果通过HttpURLConnection的方式登陆一个页面?
- HttpServletResponse 中能不能设置自动打开一个窗口? 如果不能,在jsp中怎么写?
- 一个拗口的问题.
- 2个String类型的对象如何比较值相等
- 迷宫问题求解。高分,不够再补
- 有人知道SCJP的题库怎么更新的么?
- jar到底如何加入classpath啊
- 请问如何在保证JFrame有根据里面的内容的自动缩放功能的前提下,为JFrame内的内容添加一个垂直滚动条(就像qq游戏大厅的坐位)
System.out.println("connect db error:"+e.getMessage());
return false;
}
别用e.getMessage())
直接e.printStackTrace()!!!!!!大家更好找错误。可能的原因:
1.jdbc没引入或引入错误
2.没打补丁
3.URL错误(现在的端口不是默认端口,可能还有别的)
4.用户名密码错误
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at DBConnection.connect(DBConnection.java:12)
at DBConnection.<init>(DBConnection.java:7)
at DBConnection.main(DBConnection.java:26)
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at DBConnection.connect(DBConnection.java:12)
at DBConnection.main(DBConnection.java:27)
falseProcess completed.
总之就是jdbc驱动包不对。
如果是MyEclipse 你就选中工程名单击右键选中Build Path 然后选中Add External 找到你驱动包
选中 再点击打开就加进来了
conn = DriverManager.getConnection
("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=football;",user,pwd);有错java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at infrastruture.DBConnection.getConnection(DBConnection.java:21)
at infrastruture.DBConnection.main(DBConnection.java:38)
和楼主一样的错 这样写Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = java.sql.DriverManager.getConnection("jdbc:odbc:FootBall")就对着 但是查询的时候不能进行模糊查询啊