|
|
Hi, I have a problem when running my project in NetBeans 8.2 and SQL server express 2014.
After doing the programming it shows the result as below
" com.microsoft.sqlserver.jdbc.sqlservExeption Login failed for user ''. ClientConnectionid: d963d05c-a68b-49c0-a7e9-88b829c96174 "
Can anybody help me with this issue, please?
Hehreby the quoding that i key in
"
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url= "jdbc:sqlserver://localhost:1433;"
+ "databaseName = testdb"
+ "user = sa; password = 12345";
Connection con = DriverManager.getConnection(url);
String sql = "Select* from test where username = ? and password =?";
PreparedStatement pst = con.prepareStatement(sql);
pst.setString (1, username.getText());
pst.setString (2, passwrod.getText());
ResultSet rs = pst.executeQuery();
if (rs.next())
{
JOptionPane.showMessageDialog(null, "ok, it match");
}
else
{
JOptionPane.showMessageDialog(null, "not ok, try again!!");
username.setText("");
passwrod.setText("");
}
con.close();
}
catch (Exception e)
{
JOptionPane.showMessageDialog (null,e);
}
|
|
|
|
|
Login failed for user: usually means that some credential is not valid. Check that your userid and password are both correct. Also check any server logs to see if there is more informarion on exactly what went wrong.
|
|
|
|
|
Member 13601614 wrote: + "user = sa; password = 12345";
I cannot find any examples that would suggest that the spaces before and after the equals sign should be there.
|
|
|
|
|
How can i load a file into the JTextArea
|
|
|
|
|
Probably by reading the content, if necessary converting it into text, and copying it to the JTextxxx window. See The Java™ Tutorials[^] for suggestions and samples.
|
|
|
|
|
|
what is the advantage of declaring each variable in separate line?
Zaki
|
|
|
|
|
|
What is the advantage of posting the same message over and over again?! 
Java1 - Java Discussion Boards[^] - 6th October - "what is the advantage of declaring each variable in separate line?"
Java1 - Java Discussion Boards[^] - 22nd December - "what is the advantage of declaring each variable in separate line?"
Java - Java Discussion Boards[^] - 22nd December - "what is the advantage of declaring each variable in separate line?"
You were given the answer back in October. It hasn't changed in the last two months.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
It's a way of trying to get the answer you want. 
|
|
|
|
|
It is one of those good practices which you're asked to follow while writing your code because it makes a lot cleaner and concise code. This is similar as to why we programmers focus so much on indentation... Because whenever you're working on a big project chances are you may not be the only person working on it, so if someone else has to review your code it'll be a lot easier for him/her to get a reference as to where was each variable declared. Because you might be well aware of the haunting NullPointerException which just pops out of no where and can be really trick to negotiate if your code isn't clear.
Hope this helps. Cheers.
modified 8-Feb-18 1:09am.
|
|
|
|
|
what is the advantage of declaring each variable in separate line?
Zaki
|
|
|
|
|
|
Yep, and very ideal for troubleshooting and finding possible errors.
|
|
|
|
|
Write a JSP page which will dynamically create a drop down list with all smart phones along their company saved in database.
|
|
|
|
|
If you are expecting someone to write the code for you, you are going to be disappointed.
|
|
|
|
|
I think no one will do this for you until you offer a payment.
|
|
|
|
|
I want to build a web crawler that will take a list of urls and search those urls for events happening. I want the crawler to pick up details such as address, image urls, description of event, title of event. And anything else that would be useful for sombody wanting to know about an event. I would like to write this program in java or nodejs. Doing this project quickly and simply is important.
I have checked out nutch the java framework, but I had a difficult time getting going with it quickly. I want my web crawler to be up and running by the end of the week, so the simplest quickest solution is important.
What frameworks should I use and/or what advice do you have to complete such a project?
|
|
|
|
|
Member 13566357 wrote: what advice do you have to complete such a project?
Be prepared for years of work; what you are asking for is far beyond a few simple classes. You would need to read each url, break it down into all its different parts and somehow analyse the content to identify each event (whatever you mean by that). You would then need to follow links from the event to extract any other relevant details. Just take a look at a few websites and see how they advertise events, each one is different.
|
|
|
|
|
Thanks for the input. But there is a huge difference between a few simple classes and 'years of work'. I think that maybe my problem was not defined well. But mainly I was hoping to get advice for a simple, quick to setup webcrawler with nodejs or java. Like a framework or a tool or somthing. As mentinoed I checked out nutch, but it seems overkill. I am not trying to scrape the whole web and I dont want to have to type like 300 characters into a terminal to start it up. I want to define in the beginning maybe 5 urls to scrape in the beginning and slowly but surely add to that url list. Any helpfuls suggestions are appreciated!
|
|
|
|
|
One URL or a million, the issue is exactly the same. Do you understand how to extract the information you want from any web page?
|
|
|
|
|
Ive never built a web crawler so in the context of a webcrawler no. In the context of the DOM, then I was planning to just cycle through those elements and take the data. But yeah I havent gotten that far yet, I thought this would be a good first step. I was also looking at elastic search, and wondering if somehow that might be useful.
|
|
|
|
|
Well that is easy enough to test. Write a small piece of code to pull a page from any website and go through each element in the DOM. Now you have those elements how do you identify these events that you are looking for?
|
|
|
|
|
I havent gotten that far yet. I dont really know. There are a lot of tools out there that help developers with these kinds of problems. I dont think I am the first person who wants to crawl websites looking for events, so it seems like there might be some already made tools either a java dependency I can put into my pom file or some npm package that will help me to solve that issue. If there is no such dependency, then I guess I will have to make it. If that is the case, the spontaneously, dont know if this is a good idea, because I came up with it 5 seconds ago. But You could create a bunch of lists of keywords that can be used as titles for the different data points I am interested with for example. Date could have a title on a website "date","Day of event", "Time", and so fourth. And then when you parse you looked for those key words, and then if you find it then you take the text that is nearby. Then using regular expressions you identify and remove any html tags. you could also have another list of regular expressions that identify if the text following the key word matches the regular expression, so in the case of date, you have like 50 regexes all identifying a date, so that you make sure to get a date. But yeah came up with that in 5 seconds. All I really want is events for a particular city on a particular date, maybe there is an API that takes care of that? Google doesnt, last time I checked.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
