list=new ArrayList();//读取配置文件InputStream input = 配置文件.class.getClassLoader().getResourceAsStream("database.properties");Properties p=new Properties();p.load(input);//获取集合中的键值对String dirverClass=p.getProperty("dirverClass");String user=p.getProperty("user");String password=p.getProperty("password");String url=p.getProperty("url");//注册驱动Class.forName(dirverClass);//获取数据库连接对象Connection conn = DriverManager.getConnection(url, user, password);//定义sql语句String sql="select*from worter";//获取语句执行对象CallableStatement cs = conn.prepareCall(sql);//执行语句ResultSet rs = cs.executeQuery();while (rs.next()) {worter w=new worter(rs.getString("sname"),rs.getInt("sage"),rs.getString("sid"));//装集合list.add(w);}//关流conn.close();cs.close();rs.close();//遍历集合for (worter w : list) {System.out.println(w);}}Exception in thread "main" java.lang.ClassNotFoundException: "com.mysql.jdbc.Driver"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)
mysql 异常类型_MySQL错误类型转换异常
最新推荐文章于 2022-12-11 20:57:16 发布