-
Posts
-
By NXTwoThou · Posted
It'll be nice when they finish transitioning us to the new channels. Canary 29610.1000 here and my Calculator is 11.2508.4.0 -
By wingliston · Posted
Will there be an extended stable design channel? The redesign of version 149.0.4022.52 is really ugly. -
By wingliston · Posted
Finally, Windows 11 is getting the attention it deserves. It seems like they've removed the terrible Edge team from working on it. -
By wingliston · Posted
I bought one of these last year. I really hope I won't have to deal with this crap. My drive is in good condition at the moment. -
By +mram · Posted
Umm, read my answer again! If you have something to add or contribute, feel free. Otherwise my point was that you apparently dont want faster updates... so you want slower updates by process of elimination. If you have something to contribute, meaningful answers are better.
-
-
Recent Achievements
-
AndrewSteel earned a badge
Very Popular
-
Taliseian went up a rank
Veteran
-
Clizby earned a badge
One Month Later
-
Timaximus earned a badge
One Month Later
-
Timaximus earned a badge
Week One Done
-
-
Popular Contributors
-
Tell a friend
.thumb.png.b7089ebbdf00d96b3b92dddbd04bac02.png)
Question
Aruz
I try to make a mysql database program in Eclipse. But I can't connect. What is the problem?
package pack; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JPanel; import javax.swing.JTextField; import javax.swing.JTextPane; public class SwingMysql extends JPanel implements ActionListener { //*************** JButton button; JTextField driver,url,user,pass,database; JTextPane status; //*************** public SwingMysql(){ url=new JTextField(20); url.setText("jdbc:mysql://localhost:3306/ss3bfd"); database=new JTextField(20); database.setText("SELECT display_name, user_email,user_nicename FROM wp_users"); user=new JTextField(5); user.setText("root"); pass=new JTextField(5); pass.setText("1234"); status=new JTextPane(); status.setText("\r ready \r"); button=new JButton("Button"); button.setActionCommand("Command1"); button.addActionListener(this); add(url); add(database); add(user); add(pass); add(button); add(status); } //*************** private static void makewin(){ JFrame.setDefaultLookAndFeelDecorated(true); JFrame myframe =new JFrame("Swing Mysql"); myframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); SwingMysql floor=new SwingMysql(); floor.setOpaque(true); myframe.setContentPane(floor); myframe.pack(); myframe.setSize(300, 400); myframe.setLocation(300, 300); myframe.setVisible(true); } //*************** public void actionPerformed(ActionEvent e){ if("Command1".equals(e.getActionCommand())){ try { status.setText("\r start "); Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection conn=DriverManager.getConnection(url.getText(),user.getText(),pass.getText()); Statement stat=conn.createStatement(); status.setText("connected"); ResultSet re=stat.executeQuery(database.getText()); while (re.next()){ String x=re.getString("display_name"); } status.setText("congratulations"); conn.close(); } catch(Exception e1){ status.setText("Error: "+ e1.getStackTrace()); } } } //*************** public static void main(String[] args) { // TODO Auto-generated method stub makewin(); } }Thanks for your time.
Link to comment
https://www.neowin.net/forum/topic/697864-swing-mysql-connection-problem/Share on other sites
15 answers to this question
Recommended Posts