Exception in thread "main" java.lang.Error: Unresolved compilation problems:
Conneection cannot be resolved to a type
Syntax error, insert ";" to complete LocalVariableDeclarationStatement
Syntax error on token "Catch", catch expected at TestJdbc.main(TestJdbc.java:15)
以下是连接代码请高手帮助看下,Thanks!import java.sql.*;
public class TestJdbc {
public static void main(String[] args) {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//注册驱动
//new com.microsoft.jdbc.sqlserver.SQLServerDriver;
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft: sqlserver://localhost:1433;DatabaseName=Test_01";//数据库名为Test_01
String userName = "sa"; //Sql用户名
String userPwd = ""; //密码
Conneection dbConn
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL,userName,userPwd);
System.out.println("Connection Successful!");
}
Catch (Exception e){
e.printStackTrace();
}
}}
Conneection cannot be resolved to a type
Syntax error, insert ";" to complete LocalVariableDeclarationStatement
Syntax error on token "Catch", catch expected at TestJdbc.main(TestJdbc.java:15)
以下是连接代码请高手帮助看下,Thanks!import java.sql.*;
public class TestJdbc {
public static void main(String[] args) {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//注册驱动
//new com.microsoft.jdbc.sqlserver.SQLServerDriver;
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft: sqlserver://localhost:1433;DatabaseName=Test_01";//数据库名为Test_01
String userName = "sa"; //Sql用户名
String userPwd = ""; //密码
Conneection dbConn
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL,userName,userPwd);
System.out.println("Connection Successful!");
}
Catch (Exception e){
e.printStackTrace();
}
}}
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$100(Unknown Source)
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 TestJdbc.main(TestJdbc.java:9)
public class TestJdbc {
public static void main(String[] args){
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//注册驱动
//new com.microsoft.jdbc.sqlserver.SQLServerDriver;
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft: sqlserver://localhost:1433;DatabaseName=Test_01";//数据库名为Test_01
String userName = "sa"; //Sql用户名
String userPwd = ""; //密码
Connection dbConn;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL,userName,userPwd);
System.out.println("Connection Successful!");
}
catch (Exception e){
e.printStackTrace();
}
}}
1:升级到SP3
2:JDBC三个JAR,
3,环境变量里加入这三个文件,
使程序能找到这三个文件
把你的工程目录下的LIB文件夹都放MSSQL的驱动程序