Re: How to make getText() return the result in case sensitive ?
On Oct 2, 7:54 am, Lew <no...@lewscanon.com> wrote:
tobleron wrote:
@Lew
How to solve it ? As I mention above, when I didn't call
Class.forName("com.mysql.jdbc.Driver"), the
NetBeans show error message "No suitable driver found" even I included
MySQL driver libraries in my project. The program will not run without
this call.
Well, for Pete's sake, calling it zero times is not the solution! I po=
inted
out that you only need to call it once. Calling it zero times is not
following the advice.
Tom Anderson wrote:
No, but you only need to make it once per invocation of the application=
..
You could do it in a static block - add:
static {
Class.forName("com.mysql.jdbc.Driver") ;
}
to your app class definition.
--
Lew
@Lew and Tom
I'm not quite understand. I've tried to follow your suggestion, but it
can't run. May be you can explicitly write within my code bellow (FYI,
I used NetBeans 6.1 and this code is only a part for a button click) :
@Action public void doLogin() {
String url = "jdbc:mysql://localhost:3306/dicom?
jdbcCompliantTruncation=false";
Connection con;
PreparedStatement passwordLookup ;
try {
Class.forName("com.mysql.jdbc.Driver");
} catch(java.lang.ClassNotFoundException e) {
System.err.println(e);
}
try {
con = DriverManager.getConnection(url, "root", "");
String sql = "SELECT userid,passwd FROM user WHERE userid
= BINARY ? AND passwd = BINARY ?";
passwordLookup = con.prepareStatement(sql);
char[] passwdnya = passwdTxt.getPassword();
String convertedChars = new String(passwdnya);
passwordLookup.setString(1, userIDTxt.getText().trim());
passwordLookup.setString(2, convertedChars.trim());
ResultSet result = passwordLookup.executeQuery();
if (result.next()) {
setVisible(false);
if (ecgMenuBox == null) {
JFrame mainFrame =
Main.getApplication().getMainFrame();
ecgMenuBox = new ECGMenu(mainFrame);
ecgMenuBox.setLocationRelativeTo(mainFrame);
}
Main.getApplication().show(ecgMenuBox);
}
else {
setVisible(false);
if (loginWarningBox == null) {
JFrame mainFrame =
Main.getApplication().getMainFrame();
mainFrame.setSize(100,80);
loginWarningBox = new
LoginWarning(mainFrame);
loginWarningBox.setLocationRelativeTo(mainFrame);
}
Main.getApplication().show(loginWarningBox);
}
result.close();
passwordLookup.close();
con.close();
} catch(SQLException e) {
System.err.println(e);
}
}
@All
Is there anyone can help me to understand what the NetBeans show this
warning ?
Oct 2, 2008 2:56:02 PM org.jdesktop.application.LocalStorage getId
WARNING: unspecified resource Application.id using Main
Oct 2, 2008 2:56:02 PM org.jdesktop.application.LocalStorage getId
WARNING: unspecified resource Application.vendorId using
UnknownApplicationVendor