(1)在MySQL数据库mydb中创建一个表CustomerTbl,表中的内容为自动生成的<int>id,<String> name,<String> email
首先建立一个JavaProject
在JavaProject 目录下建立一个文件名为lib
在lib文件中导入一个jar包,我使用的版本为mysql-connector-java-5.1.43.jar
选中jar右击选中Build Path选项,再选Add to Build Path 就在Referenced Library中自动生成ysql-connector-java-5.1.43.jar
在新建的JavaProject目录下的src建立一个类,填一下代码
package com.mydb.demo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Test {
//加载JDBC驱动程序
public static void main(String[] args) {
//加载驱动程序
Connection conn=null;
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
String url="jdbc:mysql://localhost:3306/mydb";
String username="root";
String password="123456";
try {
conn = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String sql="select * from CustomerTbl;";
try {
Statement stmt = conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
int id=rs.getInt(1);
String name=rs.getString(2);
String email=rs.getString(3);
System.out.println(id+","+name+","+email);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
if(conn!=null)
{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}