wz19881220
发贴: 5
积分: 0
|
于 2008-04-29 12:31
import java.sql.SQLException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.sql.ResultSet; import java.sql.PreparedStatement;
class JdbcTest5{ private Connection con; private String url; private String serverName; private String portNumber; private String databaseName; private String userName; private String password; private String sql; JdbcTest5(){ url="jdbc:microsoft:sqlserver://"; serverName="JUJUMAO1"; portNumber="1433"; databaseName="test"; userName=""; password=""; }
private String getConnectionUrl(){ return url+serverName+":"+portNumber+";databaseName="+databaseName+";"; }
private Connection getConnection(){ try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); con=DriverManager.getConnection(getConnectionUrl(),userName,password); if(con!=null){ System.out.println("连接成功"); } }catch(Exception e){ e.printStackTrace(); System.out.println("getConnection 内的错误跟踪:"+e.getMessage()); } return con; } public void display(){ try{ con=getConnection(); PreparedStatement pstmt=con.prepareStatement("UPDATE friends SET salary=? where name like ?"); pstmt.setInt(1,1000); pstmt.setString(2,"李四"); pstmt.executeUpdate(); System.out.println("记录已更新"); Statement s=con.createStatement(); String sql="SELECT * FROM friends"; ResultSet rs=s.executeQuery(sql); while(rs.next()){ System.out.println(" "); System.out.print(rs.getInt(1)+"\t"); System.out.print(rs.getInt(5)); }
}catch(SQLException ce){ System.err.println(ce); } }
public static void main(String [] args){ JdbcTest5 obj=new JdbcTest5(); obj.display(); } }
为什么连接不上?
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.sqlserverdriv at java.net.URLClassLoader$1.run(URLClassLoader.java:199) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:187) at java.lang.ClassLoader.loadClass(ClassLoader.java:289) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274) at java.lang.ClassLoader.loadClass(ClassLoader.java:235) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:141) at JdbcTest5.getConnection(JdbcTest5.java:49) at JdbcTest5.display(JdbcTest5.java:65) at JdbcTest5.main(JdbcTest5.java:89) getConnection 内的错误跟踪:com.microsoft.jdbc.sqlserver.sqlserverdriver Exception in thread "main" java.lang.NullPointerException at JdbcTest5.display(JdbcTest5.java:66) at JdbcTest5.main(JdbcTest5.java:89)
test数据库你们测试的时候在随便建立个得了 里面的表是friends
刚学java不久 ```帮忙下 谢谢了~
wz19881220 edited on 2008-04-29 12:33
|