10,613
社区成员
发帖
与我相关
我的任务
分享package javabean;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBC {
private static final String uri="jdbc:sqlserver://localhost:1433;databaseName=wsdc";
private static final String user="zhujian";
private static final String password="ld0951148";
static {
try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public static void main(String[] ags) {
try{
Connection conn=DriverManager.getConnection(uri,user,password);
Statement stmt=conn.createStatement();
String sql="select * from Users";
ResultSet rs= stmt.executeQuery(sql);
while (rs.next()){
String username=rs.getString(1);
String password=rs.getString(2);
String mobile=rs.getString(3);
String email=rs.getString(4);
System.out.println(username+""+password+""+mobile+""+email);
}
stmt.close();
conn.close();
} catch (SQLException e){
e.printStackTrace();
}
}
}
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at java.lang.ClassLoader.loadClass(ClassLoader.java:423)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:356)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:186)
at javabean.JDBC.<clinit>(JDBC.java:14)
123567432311
逐渐123786655662
大师abc123123123
ld0951148ld924814
nihaobuhao
abc123123abc
qwerdfqwerdf87654321
kkkkkk90909909090990
dddddddddd123
hhhhhhhh1111
asdasd123
balckblack
bbbbbb123
cccccc123
aaaaaa123
223422342234
334433443344
556633443344
fffffff123123
qeqwweqffff123123
12312312ffff123123
1231231231ffff123123
hello321321321
lllll12234
123123321321
asdfasdf123
fghfgh31332
ghjghj123
asdasdas12qaeqa12312
sephirothzhu567890fosunv.com