package com.jdbc.entity;
import java.sql.*;
public class MysqlConnection
{
public static void main(String[] args){
try{
String url="jdbc:mysql://localhost/hibernate";
String user="root";
String password="123456";
//加载驱动,这一句也可写为:Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver").newInstance();
//建立到MySQL的连接
Connection conn = DriverManager.getConnection(url,user, password);
//执行SQL语句
//创建语句对象,用以执行sql语言
Statement stmt = conn.createStatement();
String sql = "select * from persons";
ResultSet rs = stmt.executeQuery(sql);
//处理结果集
while (rs.next()){
String name = rs.getString("name");
System.out.println(name);
}
//关闭数据库
rs.close();
conn.close();
}
catch (Exception ex){
System.out.println("Error : " + ex.toString());
}
}
}
JDBC连接MySQL数据库(数据库信息硬编码到程序中)
最新推荐文章于 2022-02-23 16:23:28 发布