mandmas 2016-01-19 18:26 采纳率: 71.4%
浏览 2709
已采纳

数据库连接不上,一直报错

各位哥哥姐姐,能帮我一下吗?我java数据库连接不上。
我的是mysql 5.0 java 4.2
数据库是5.1.36
网上说把jar包放在lib,我不知道放哪里?
希望各位能指教一下我新手。谢谢·急!!
package denglu;

import gongyong.DaoConn;
import gongyong.SaveUserInfo;

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;

public class loginchuankou extends JFrame{
public DaoConn daoconn=new DaoConn();

private JButton guanbi=new JButton("退出");
private JButton Queding=new JButton("登录");

private JPasswordField mimakuang=new JPasswordField(20);
private JTextField yonghumingkuang=new JTextField(20);

private JLabel yonghubiaoqian=new JLabel();

private JLabel mimabiaoqian=new JLabel();



public loginchuankou(){
    setTitle("系统登录");
    setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);




    setBounds(200,200,300,180);
//  setResizable(false);
    JPanel dengluchuan=new JPanel();
    getContentPane().add(dengluchuan,BorderLayout.CENTER);
    setVisible(true);




    yonghubiaoqian.setText("用户名");
    dengluchuan.add(yonghubiaoqian);

    dengluchuan.add(yonghumingkuang);


    dengluchuan.add(Queding);

    mimabiaoqian.setText("密码");
    dengluchuan.add(mimabiaoqian);

    dengluchuan.add(yonghumingkuang);

    dengluchuan.add(mimakuang);

    dengluchuan.add(guanbi);
    //键盘
    guanbi.addMouseListener(new MouseAdapter(){

        public void mouseClicked(final MouseEvent e){
            System.exit(0);
        }

            });

    Queding.addActionListener(new ActionListener() {
        public void actionPerformed(final ActionEvent evt) {            
            Queding(evt);         
                        }   
        });

    /////

}

protected void Queding(ActionEvent evt) {
    Connection conn = null;           //????
    Statement st = null;                
    ResultSet rs = null;   
    try {
        conn =(Connection) daoconn.getConn();           
        st = (Statement) conn.createStatement();    

        String user=yonghumingkuang.getText().trim();
        String pw=new String(mimakuang.getPassword()).trim();

        String sql="  select * from user where username='"+ user + "' and password= '"+ pw + "'  ";

        rs=(ResultSet) st.executeQuery(sql);

        if(rs.next() && rs.getString("username")!=null){
            SaveUserInfo.setuserName(user);
            SaveUserInfo.setpassword(pw);
            System.out.print("成功");
        }else{
            System.out.print("失败");
        }
    } catch (Exception e) {

        e.printStackTrace();
    }finally{
    }

}//Queding

}//gouzao

报错如下:
java.lang.ClassNotFoundException: com.mysql.jdbc.Drive
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:425)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:195)
at gongyong.DaoConn.getConn(DaoConn.java:8)
at denglu.loginchuankou.Queding(loginchuankou.java:105)
at denglu.loginchuankou$2.actionPerformed(loginchuankou.java:89)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6516)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
at java.awt.Component.processEvent(Component.java:6281)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4872)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4698)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2719)
at java.awt.Component.dispatchEvent(Component.java:4698)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:747)
at java.awt.EventQueue.access$300(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:706)
at java.awt.EventQueue$3.run(EventQueue.java:704)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:720)
at java.awt.EventQueue$4.run(EventQueue.java:718)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:717)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

  • 写回答

10条回答

  • Evankaka 博客专家认证 2016-01-20 04:26
    关注

    右键-》属性后,在弹出框中选择
    图片说明
    战鼓最右边的红框,然后选择你的jar

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(9条)

报告相同问题?

悬赏问题

  • ¥15 请教一下各位,为什么我这个没有实现模拟点击
  • ¥15 执行 virtuoso 命令后,界面没有,cadence 启动不起来
  • ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
  • ¥20 有关区间dp的问题求解
  • ¥15 多电路系统共用电源的串扰问题
  • ¥15 slam rangenet++配置
  • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
  • ¥15 ubuntu子系统密码忘记
  • ¥15 保护模式-系统加载-段寄存器
  • ¥15 电脑桌面设定一个区域禁止鼠标操作