1、直接连接JDBC并且进行数据库的修改,贴出来的代码是进行数据库的插入操作,修改可进行更改和删除,注释的代码是进行查询操作。
/*
* Hello Java!
* 小菜鸟要开始编程了!!
* Stop!!
*/
package Test;
import java.sql.*;
public class Connetion1 {
public static void main(String[] args) {
Connection conn = null;
PreparedStatement prestat = null;
ResultSet res = null;
String driver = "com.mysql.cj.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/r1";
String name = "root";
String password = "123456";
try{
//1、注册驱动
Class.forName(driver);
//2、创建连接
conn = DriverManager.getConnection(url,name,password);
//3、创建数据库对象
String sql = "INSERT INTO people (name,sage) VALUES (?,?)";
prestat = conn.prepareStatement(sql);
prestat.setString(1,"张三");
prestat.setInt(2,18);
//4、执行SQL语句
int count = prestat.executeUpdate();
System.out.println("增加记录为:"+count);
// res = prestat.executeQuery();
//5、数据处理
// while(res.next()){
// String bname = res.getString("name");
// String bage =res.getString("sage");
// System.out.println(bname+ " "+ bage);
// }
}catch(Exception e){
e.printStackTrace();
}finally{
//6、释放资源
if(res!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(prestat!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
2、使用配置文件进行连接
/*
* Hello Java!
* 小菜鸟要开始编程了!!
* Stop!!
*/
package Test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.*;
public class Connection2 {
public static void main(String[] args) {
String driver = null;
String url = null;
String user = null;
String password = null;
Connection conn = null;
PreparedStatement pre = null;
ResultSet res =null;
try {
ResourceBundle resget = ResourceBundle.getBundle("profile");
driver = resget.getString("driver");
url = resget.getString("url");
user = resget.getString("user");
password = resget.getString("password");
Class.forName(driver);
conn = DriverManager.getConnection(url,user,password);
String sql = "SELECT * FROM people";
pre = conn.prepareStatement(sql);
res = pre.executeQuery();
while (res.next()) {
System.out.println(res.getString("name" ) + " "+ res.getString("sage"));
}
}catch (Exception e) {
e.printStackTrace();
}finally{
if(res!=null){
try{
res.close();
}catch(Exception e){
e.printStackTrace();
}
}
if(pre!=null){
try{
pre.close();
}catch(Exception e){
e.printStackTrace();
}
}
if(conn!=null){
try{
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
}
}
配置文件中内容,配置文件要放在src目录中,我的配置文件名字是:profile.properties
driver=com.mysql.cj.jdbc.Driver
user=root
password=123456
url=jdbc:mysql://localhost:3306/r1