进入MySQL控制台,
输入密码,
新建数据库test1并给用户授权,用户名“jaovo”,
创建表,id主键自增,
下载jdbc驱动包(jar文件)
把它放进tomcat的安装目录lib文件夹下(我的tomcat安装在D盘) D:\apache-tomcat-8.0.20\lib
在eclipse里新建Dynamic Web Project项目,
新建成功后,在WebContent->lib下放入这两个包,
查看Web App Libraries有没有这两个包,没有的话,选中包,右键build path->Configure Build Path。
在src里新建class文件,DBUtil.java
packageUtil;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;public classDBUtil {public staticConnection getConnection() {try{//1 加载驱动
Class.forName("com.mysql.jdbc.Driver").newInstance();
}catch (InstantiationException | IllegalAccessException |ClassNotFoundException e) {//TODO Auto-generated catch block
e.printStackTrace();
}
String user= "root";
String password= "root";
String url= "jdbc:mysql://localhost:3306/test1";
Connection connection= null;try{//2 创建链接对象connection
connection =DriverManager.getConnection(url,user,password);
System.out.println("数据库连接成功");
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
System.out.println("数据库连接失败");
}returnconnection;
}//关闭资源的方法
public static voidclose(Connection connection ) {try{if (connection != null) {
connection.close();
}
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}
}public static voidclose(PreparedStatement preparedStatement ) {try{if (preparedStatement != null) {
preparedStatement.close();
}
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}
}public static voidclose(ResultSet resultSet ) {try{if (resultSet != null) {
resultSet.close();
}
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}
}public static voidmain(String[] args) {//TODO Auto-generated method stub
DBUtil c = newDBUtil();
c.getConnection();
}
}
右键Run As->Java Application,