Results 1 to 1 of 1
Thread: getting database connection
- 11-27-2009, 04:33 AM #1
Member
- Join Date
- Nov 2009
- Posts
- 4
- Rep Power
- 0
getting database connection
I am staring a new project with swing application framework in netbeans 6.5 in that i selected newproject->java - java desktop application - basic application-> finish.
when opening the project i saw three classes about,view,app.In view class
i started doing my project in that class i take two textboxes and one button.the
textboxes names are usernamee and password.and a button name is submit.from that
class i connect a database connection to SQLServer 2005.In my code i loaded
driver successfully but not getting connection. In libraries i add sqljdbc.jar
file also.please help me
//code under the button
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// getting textbox values.
String user = username.getText();
String pass = password.getText();
System.out.println("username " + user);
System.out.println("password "+pass);
try {
//connecting database
Class.forName("com.microsoft.sqlserver.jdbc.SQLSer verDriver");
System.out.println("driver loaded........");
con = DriverManager.getConnection("jdbc:sqlserver://java04:1433;databaseName=appforum;userName=sa");
stmt = con.createStatement();
System.out.println("statement created.");
rst = stmt.executeQuery("select userName,Password from SwingsUser where UserName='" + user + "' and Password='" + pass + "'");
System.out.println("resultset created.");
if (rst.next())
{
db_username = rst.getString("UserName");
db_password = rst.getString("Password");
System.out.println("retrieving username,password.");
}
if (user.equals(db_username))
{
if (pass.equals(db_password))
{
NewJFrame appframe = new NewJFrame();
appframe.setVisible(true);
}
}
} catch (Exception e)
{
e.printStackTrace();
}
}
output:
//entered textboxes username and password
username:ravi
password:ravi
driver loaded..... after that process is running only and structed the form
and connection is not getting plz help me
Similar Threads
-
getting database connection
By ravidasineni in forum AWT / SwingReplies: 1Last Post: 11-22-2009, 02:01 AM -
database connection in jsf
By Srikala in forum JavaServer Faces (JSF)Replies: 0Last Post: 10-06-2008, 06:53 AM -
Database Connection
By CompleteBeginner in forum New To JavaReplies: 2Last Post: 05-24-2008, 02:30 PM -
Database Connection
By vipinkumarsolanki in forum Advanced JavaReplies: 2Last Post: 11-26-2007, 06:36 AM -
Database connection
By oaklander in forum New To JavaReplies: 2Last Post: 11-12-2007, 11:11 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks