---
title: "MYSQL 的JDBC连接测试程序"
author: "fanjava"
date: "2004-09-28T15:11:00Z"
tags: []
slug: "mysql-jdbc"
draft: false
lastmod: "2004-09-28T15:11:00Z"
id: 601881
url: "https://fanjava.iteye.com/blog/601881"
---

package com.catmiw.testmysql;

import java.sql.\*;

public class MysqlJdbc {  
public static void main(String args\[]) {  
try {  
Class.forName("org.gjt.mm.mysql.Driver"); //加载MYSQL JDBC驱动程序  
System.out.println("Success loading Mysql Driver!");  
}  
catch (Exception e) {  
System.out.print("Error loading Mysql Driver!");  
e.printStackTrace();  
}

try {  
Connection connect = DriverManager.getConnection(  
"jdbc:mysql://localhost/catmiw", "root", "");  
//连接URL为 jdbc:mysql//服务器地址/数据库名  
//后面的2个参数分别是登陆用户名和密码  
System.out.println("Success connect Mysql server!");

Statement stmt = connect.createStatement();  
ResultSet rs = stmt.executeQuery("select * from pet");  
while (rs.next()) {  
System.out.println(rs.getString("name"));

}  
}  
catch (Exception e) {  
System.out.print("get data error!");  
e.printStackTrace();  
}  
}  
}

程序运行结果如下：  
Success loading Mysql Driver!  
Success connect Mysql server!  
a dog