mrxuexx mrxuexx
关注数: 19 粉丝数: 17 发帖数: 302 关注贴吧数: 41
萌新求教大神!!关于eclipse和数据库的故事!!! 学校老师要求要用java创建数据库里的表,部分代码如下: class ReadFileAction extends AbstractAction {//写入数据库中 public ReadFileAction() { super("确认写入"); } public void actionPerformed(ActionEvent e) { File sfile=new File(jtfPath.getText()); //源文件 try{ Class.forName("mysql-connector-java-5.1.26-bin"); //一开始必须填一个已经存在的数据库 String url = "jdbc:mysql://localhost:3306/test"; Connection conn = DriverManager.getConnection(url, "root", "960308"); Statement stat = conn.createStatement(); //创建数据库hello stat.executeUpdate("create database hello"); //打开创建的数据库 stat.close(); conn.close(); url = "jdbc:mysql://localhost:3306/hello"; conn = DriverManager.getConnection(url, "root", "960308"); stat = conn.createStatement(); //创建表test1 stat.executeUpdate("create table test1(name varchar(80), path varchar(80))"); Connection connect = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test1","root","960308"); //连接URL为 jdbc:mysql//服务器地址/数据库名 ,后面的2个参数分别是登陆用户名和密码 PreparedStatement Statement=connect.prepareStatement("INSERT INTO test1 VALUES(?,?)"); String i,g; i=sfile.getName(); g=sfile.getAbsolutePath(); Statement.setString(1,i); Statement.setString(2,g); Statement.executeUpdate(); } catch(SQLException ex) { } catch (Exception ex) { System.out.print("get data error!"); ex.printStackTrace(); } showMessage(sfile.getName()+" 写入成功.");//显示信息 } } 最后并没有成功创建表,如下: get data error!java.lang.ClassNotFoundException: mysql-connector-java-5.1.26-bin 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.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at FileUseDemo.FileUseDemo$ReadFileAction.actionPerformed(FileUseDemo.java:118) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$500(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source)
1 下一页