JDBC:java database data connect(java数据库连接),通过用java代码操作数据库。
下面是基础代码:
public class Main {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String userName = "root";
String pwd = "123";
//"jdbc:mysql://localhost:3306/"固定写法,"xjb" 指的是要连接的数据库名称
String url = "jdbc:mysql://localhost:3306/xjb";
String driverClassName = "com.mysql.jdbc.Driver";
//加载驱动类
Class.forName(driverClassName);
//链接数据库
Connection connection = DriverManager.getConnection(url, userName, pwd);
//数据库操作
Statement statement = (Statement) connection.createStatement();//sql语句发送器
//对数据库增,删,改操作
statement.executeUpdate("insert into person values('tom','man',40)");
//对数据库查询操作
ResultSet resultSet = statement.executeQuery("select * from person");
while (resultSet.next()) {
System.out.println(resultSet.getString("name")
+"---"+ resultSet.getString("sex")
+"---"+resultSet.getInt("age"));
}
//获取列的数量(字段的个数)
int columnCount = resultSet.getMetaData().getColumnCount();
}
}