I have a database which i have created using phpmyadmin. I need this database to be update programmatically using values i get from a java program. How would i go about doing this.
1
-
2Check this question: stackoverflow.com/questions/5113614/…DRCB– DRCB2012-03-13 12:52:24 +00:00Commented Mar 13, 2012 at 12:52
Add a comment
|
2 Answers
Simple database access in Java is achieved via JDBC. The exact commands you'd need to use depend on what sort of queries you want to execute, but any half-decent tutorial should cover both select and insert/update statements.
I'd recommend starting with Sun's JDBC Basics tutorial, and going from there.
If you have any specific points you're stuck on after following the tutorial, I'd recommend posting a follow-up question showing what you've tried to do, and why it's not working. However asides from perhaps getting an environment set up, JDBC isn't too tricky to use.
(Do remember to close your resources in a finally block though!)
Comments
i think this might work. not very sure
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost/login" ,"root","");
statement = connection.createStatement();
1 Comment
Andrzej Doyle
What makes you unsure if this would work, and how did you try to improve the answer to eliminate this potential confusion? IMHO, it's not very helpful to provide guesses, certainly not without justification behind them and suggesting how they might be used or extended into a concrete solution.