工程连接mysql_javaweb之eclipse工程连接mysql数据库

javaweb之eclipse工程连接mysql数据库

准备工作&＃xff1a;

1.在mysql官网下载mysqlconnection的jar包

输入网址&＃xff1a;mysql.com—点击DOWNLOADS——下拉选择MySQL Community (GPL) Downloads »——选择Connector/J——下载后解压——找到mysql-connector-java-8.0.22.jar

2.将mysql-connector-java-8.0.22.jar复制到当前javaweb工程

3.构建路径&＃xff1a;右击当前项目——选择Build Path——Configure Build Path——Libraries——AddJARs——将之前复制在lib文件下的mysql-connection导入——Apply and Close

看到如下则成功&＃xff1a;

4.在src中创建com.mysqlconnection包和mysqlconnection类

进行连接

public class mysqlconnect {

public static void main(String[] args) {

//判断驱动是否加载成功

try {

Class.forName("com.mysql.cj.jdbc.Driver"); //固定语法

System.out.print("成功加载驱动&＃xff01;");//提示语

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

System.out.print("加载驱动失败&＃xff01;");

e.printStackTrace();

}

//连接mysql

Connection con;

//localhost为主机名 3306为mysql的端口号 web&＃xff1a;进行连接的目标数据库

String url &＃61; "jdbc:mysql://localhost:3306/web?serverTimezone&＃61;UTC";

//登录数据库用户名

String user &＃61; "root";

//登录数据库的密码

String password &＃61; "password";

try {

con &＃61; DriverManager.getConnection(url,user,password); //将参数传给驱动进行连接

if(!con.isClosed()) {

System.out.print("成功连接数据库&＃xff01;");

//创建statement对象

Statement statement &＃61; con.createStatement();

//声明一个sql语句查询student表中所有信息

String sql &＃61; "select * from student";

ResultSet rs &＃61; statement.executeQuery(sql);

//循环输出打印student表中的id name age

while (rs.next()){System.out.print(rs.getString("id"));

System.out.print("");

System.out.print(rs.getString("name"));

System.out.print("");

System.out.print(rs.getString("age"));

System.out.print("\t");}

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}