1.首先准备mysql 和eclipse环境,在环境搭建好之后,从eclipse官网下载jdbc的驱动包,下载地址http://dev.mysql.com/downloads/connector/j/
2.从下载的文件中取出mysql-connector-java-5.1.31-bin.jar,放到工程中,并导入路径
方法:右击工程名->Build Path->Configure Build Path,选择Add External JAR... 找到mysql-connector-java-5.1.31-bin.jar所在的位置,然后将驱动包加载到项目中,
3.写个例子测试一下
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
package testmysql;
import java.sql.*;
public class Test {
public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver" ;
String URL = "jdbc:mysql://localhost:3306/student" ;
Connection con = null ;
try
{
Class.forName(driver);
}
catch (java.lang.ClassNotFoundException e)
{
System.out.println( "Connect Successfull." );
System.out.println( "Cant't load Driver" );
}
try {
con=DriverManager.getConnection(URL, "root" , "root" );
System.out.println( "Connect Successfull." );
}
catch (Exception e)
{
System.out.println( "Connect fail:" + e.getMessage());
}
}
}
|
连接上数据库之后,可以根据表中的内容进行数据库表的查询,首先表中要有内容,将一些信息输入到表中之后即可使用SQL语言进行查询
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
import java.sql.*;
public class Main {
public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver" ;
String URL = "jdbc:mysql://localhost:3306/xiaolu" ;
Connection con = null ;
ResultSet rs = null ;
Statement st = null ;
String sql = "select * from student" ;
try
{
Class.forName(driver);
}
catch (java.lang.ClassNotFoundException e)
{
// System.out.println("Connect Successfull.");
System.out.println( "Cant't load Driver" );
}
try {
con=DriverManager.getConnection(URL, "root" , "root" );
st=con.createStatement();
rs=st.executeQuery(sql);
if (rs!= null ) {
ResultSetMetaData rsmd = rs.getMetaData();
int countcols = rsmd.getColumnCount();
for ( int i= 1 ;i<=countcols;i++) {
if (i> 1 ) System.out.print( ";" );
System.out.print(rsmd.getColumnName(i)+ " " );
}
System.out.println( "" );
while (rs.next()) {
System.out.print(rs.getString( "sno" )+ " " );
System.out.print(rs.getString( "sname" )+ " " );
System.out.print(rs.getString( "ssex" )+ " " );
System.out.print(rs.getString( "sage" )+ " " );
System.out.println(rs.getString( "sdept" )+ " " );
}
}
//System.out.println("Connect Successfull.");
System.out.println( "ok" );
rs.close();
st.close();
con.close();
}
catch (Exception e)
{
System.out.println( "Connect fail:" + e.getMessage());
}
}
}
|
关于JDBC连接MySQL5.7的文章就介绍到这,其他的可以查下服务器之家其它相关文章。
原文链接:https://blog.csdn.net/lxl121181/article/details/78056415