02. Example of applications for lomboz and JDBC processing DDL statements, 02. lombozddl

02. Example of applications for lomboz and JDBC processing DDL statements, 02. lombozddl
Reprinted please indicate the source: http://blog.csdn.net/u012637501
1. lomboz development toolsLomboz is a major open-source plug-in (open-source plug-in) of Eclipse. The Lomboz plug-in enables Java developers to better use Eclipse to create, debug and deploy a Java application server 100% based on J2EE. The Lomboz plug-in enables Eclipse to integrate multiple J2EE elements, Web application development, and the most popular application server vehicles. There is no problem with replacing myeclipse with it. Here we only need to develop JDBC database applications.1. Download and installLomboz official website, http://lomboz.ow2.org/downloads.php. You can download lomboz from the above. The current version is not provided based on eclipse 3.4, So we download version 3.3. When downloading, only eclipse + lomboz versions with all-in-on are available. With prequest (install the plug-in to the pure version of Eclipse), it refers to other software packages that only lomboz + says to be dependent on, and the other is only lomboz. Here, we recommend that you use the all-in-one version directly to avoid configuration troubles. Version: linux: strongswan.2. Create a JDBC Application ProjectUsing lomboz to develop JDBC database applications is actually developing a common Java application (1) adding a MySQL database. jar package (driver package name) to the project, right-click the project name, select "mysql-connector .... -bin. jar "(2 create a Java Project: File-> New-> Java Project (3) create a JDBC application (multiple) in the Java Project ), run the project name (or a Java source file)-> right-click-> run as-> run on Java Application. note: To perform one-step debugging, select debug as-> run on Java Application.
Ii. database programming practices: JDBC processing DDL statementsDDL (Data manipulation language) Statements: Data Definition language. These statements define different Data objects, such as Data segments, databases, tables, columns, and indexes, common statement keywords include create, drop, select, and alter.1. Install MySQL databaseFirst, we need to install the MySQL database on the host (username is root, password is 111111), and create a database for JDBC application access create database jdbc_test_db (id tinyint primary key auto_increment, name varchar (10) not null default '', age tinyint not null default 0, score smallint not null default 0) charset UTF-8; insert several records as follows:
2. Create a Java Application project and add the database driver. jar package

1. ImportJava. SQL .*;
3. /* MySQL Database Programming
4. * Instance (1): JDBC processes DLL statements */
6. Public ClassTestJDBC_1 {
7. Public Static VoidMain (String [] args ){
8. // 0. Database URL, database account name, and password
9. String url = "jdbc: mysql: // localhost/jdbc_test_db ";
10. String DBusername = "root ";
11. String DBpassword = "111111 ";
13. // 1. Load the database driver to the Java Virtual Machine
15. Try{
16. Class. forName ("com. mysql. jdbc. Driver"); // The Driver is a MySQL Driver Class.
17. }Catch(ClassNotFoundException e)
18. {
19. System. out. println ("the database driver class cannot be found. Failed to load the driver! ");
20. E. printStackTrace (); // Save the exception to log
21. }
23. // 2. Create the Connection object conn to connect to the MySQL database.
24. Connection conn =Null;
25. Statement stmt =Null;
26. ResultSet rs =Null;
27. Try{
28. Conn = DriverManager. getConnection (url, DBusername, DBpassword );
29. // 3. Obtain the Statement object that can execute SQL statements.
30. Stmt = conn. createStatement ();
31. // 4. Execute the SQL statement and obtain the result set (the query result set contains multiple rows)
32. Rs1_stmt.exe cuteQuery ("select * from test ");
33. // 5. traverse all rows in the result set to obtain the specified data
34. While(Rs. next ())
35. {
36. IntId = rs. getInt (1); // obtain the first column of all records
37. System. out. print (id );
38. String name = rs. getString (2); // obtain the second column of all records
39. System. out. print (name );
40. IntAge = rs. getInt (3); // obtain the third column of all records
41. System. out. print (age );
42. IntScore = rs. getInt (4); // obtain the fourth column of all records
43. System. out. print (score );
44. }
45. }Catch(SQLException se)
46. {
47. System. out. println ("failed to connect to the Database ");
48. Se. printStackTrace ();
49. }
50. // 6. Close all used JDBC objects and release JDBC Resources
51. If(Rs! =Null) // Close the record set
52. {
53. Try{
54. Rs. close ();
55. }Catch(SQLException e ){
56. E. printStackTrace ();
57. }
58. }
60. If(Stmt! =Null) // Close the Declaration
61. {
62. Try{
63. Stmt. close ();
64. }Catch(SQLException e ){
65. E. printStackTrace ();
66. }
67. }
69. If(Conn! =Null) // Close the database connection
70. {
71. Try{
72. Conn. close ();
73. }Catch(SQLException e ){
74. E. printStackTrace ();
75. }
76. }
77. }
79. }

3. Running result
Analysis: to determine whether a JDBC application is connected to a MySQL database, we only need to load the database driver and create a database connection. If no exception occurs during the operation, the database is connected successfully. Otherwise, check whether the database URL ("jdbc: mysql: // localhost: 3306/jdbc_test_db"), Database User and password, database name, and table name are correct. Reference http://blog.sina.com.cn/s/blog_495325a50100c1k8.html