Review and start again——First Step JAVA web Program hotelmanagement：1.JDBC-优快云博客

本文链接：https://blog.youkuaiyun.com/wangxixuan0008/article/details/95499140

本文介绍Java程序中使用JDBC进行数据库连接的方法，并详细解释了如何通过Navicat生成和导入SQL文档来管理和迁移数据库内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

In a whole program of java, the JDBC, a.k.a JAVA DataBase Connectivity is a problem that cannot be avoided. So today I will integrate something about the JDBC based on the the programe hotelmanagement.

Firstly: The format in the class: JDBC
Secondly: The produce and extract of documents .sql

Section1:
The following is the codeblock about the package in the program：

package db;
import java.sql.*;
public class JDBC {

public static Connection getConnection() throws Exception {
	String driverName = "com.mysql.jdbc.Driver";   //加载JDBC驱动
	String dbURL = "jdbc:mysql://localhost:3306/hotel";   //链接服务器
	String userName = "root";  //navicat中设置的用户名
	String userPwd = "123456"; //nabicat中设置的密码
	Class.forName(driverName);
	return DriverManager.getConnection(dbURL, userName, userPwd);
}
public static void main(String args[]){

}

}
generally there should be a statement about “Conn get statement or prepareStatement object for sql operation”

Section2: The produce and extract of documents .sql .
produce:
step1: open the “navicat for mysql”
step2: right click the database you’d like to produce a .sql document
step3: click the " dump a SQL document"
step4: choose the path and run

extract:
step1: open the “navicat for mysql”;
step2: new a new database in the navicat
step3: open the new database
step4: right click the new one and click the button"run the sql document"
step5: choose the path of the sql document which you would like to extract
step6: right click the block and refresh the database

integration-integrate整合
extract提取