Ðề: Kết nối java với SQL server
em có cái code java này, kết nối qua driver nhưng nó báo lỗi, ai chỉ cho em cách sửa cái, gấp lắm
import java.io.*;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.microsoft.sqlserver.jdbc.*;
import java.sql.ResultSet;
import java.sql.Statement;
class ThuData{
public static void main(String srgs[]){
Connection connect1=null;
try{
Class.forName(“com.microsoft.jdbc.sqlserver.SQLServerDriver”).newInstance();
}catch(Exception e){
e.printStackTrace();
}
String urlResource=”jdbc:sqlserver://localhost:1433;databaseName=SaoBang”;
try{
connect1=DriverManager.getConnection(urlResource,”sa”,””);
Statement s = connect1.createStatement();
ResultSet rs = s.executeQuery(“select*from example”);
while(rs.next())
{
System.out.print(rs.getString(1)+”\t\t”);
System.out.print(rs.getString(2)+”\t\t”);
System.out.print(“\n”);
}
String uid = “so1grbvcn1”;
String pw = “12345vb567”;
String sql = “insert into example values(‘”+uid+”‘,'”+pw+”‘)”;
int rows = s.executeUpdate(sql);
System.out.println(“co “+ rows + “dong duoc them vao”);
}catch(SQLException e1){
System.out.print(” Khong ket noi duoc – > Loi ! “);
e1.printStackTrace();
}
if(connect1!=null){
System.out.println(” Ket Noit thanh cong ! “);
}
else {
System.out.println(” Ket noi that bai ! “);
}
}
}
sau khi chạy nó hiện lỗi này, em không hiểu thế nào:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at CourseAppl.getConnection(conn.java:31)
at CourseAppl.display(conn.java:49)
at CourseAppl.main(conn.java:74)
Error Trace in getConnection() : com.microsoft.jdbc.sqlserver.SQLServerDriver
Exception in thread “main” java.lang.NullPointerException
at CourseAppl.display(conn.java:50)
at CourseAppl.main(conn.java:74)