如何修复“java.net.connectexception” java中使用netbeans IDE的异常......? [英] How to fix "java.net.connectexception" exception in java using netbeans IDE...?
问题描述
我正在尝试连接登录页面和sql数据库,但它会抛出一个异常com.mysql.jdbc.CommunicationsException:由于基础异常导致通信链接失败。
**开始嵌入异常* *
java.net.ConnectException
消息:拒绝连接:连接
STACKTRACE
..... ......
代码:
String sql =select * from login where username =?and password =? ;
试试
{
Class.forName(com.mysql.jdbc.Driver);
con = DriverManager.getConnection(jdbc:mysql:// MANOSHRI / testsql,manoshri,wamanbaba);
pst = con.prepareStatement(sql);
pst.setString(1,user.getText());
pst.setString(2,pass.getText());
rs = pst.executeQuery( );
if(rs.next())
{
JOptionPane.showMessageDialog(null,用户名和密码匹配..) ;
}
else
{
JOptionPane.showMessageDialog(null,不匹配);
}
}
catch(exception ex)
{
JOptionPane.showMessageDialog(null,ex);
}
我尝试了什么:
我只是一个初学者所以我没试过......
Plzz以一种简单的方式帮助我...
i am trying to connect login page and sql database but it throws an exception that "com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception.
**BEGIN NESTED EXCEPTION**
java.net.ConnectException
MESSAGE: Connection refused:connect
STACKTRACE
..........."
Code:
String sql = "select * from login where username=? and password = ?";
try
{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://MANOSHRI/testsql", "manoshri", "wamanbaba");
pst = con.prepareStatement(sql);
pst.setString(1, user.getText());
pst.setString(2, pass.getText());
rs = pst.executeQuery();
if(rs.next())
{
JOptionPane.showMessageDialog(null, "Username and password matched..");
}
else
{
JOptionPane.showMessageDialog(null, "Not matched");
}
}
catch(Exception ex)
{
JOptionPane.showMessageDialog(null, ex);
}
What I have tried:
I am just a beginner so i didn't try anything...
Plzz help me in a simple way...
推荐答案
使用Java DB(Derby)数据库 - NetBeans IDE教程 [ ^ ]
这篇关于如何修复“java.net.connectexception” java中使用netbeans IDE的异常......?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!