java JDBC连接数据库

直接用单元测试方法来测试数据库连接,数据库名为ycdemo表名为tuser

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import org.junit.Test;

public class DBHelper {
	// 保存数据
@Test
	public void save() throws ClassNotFoundException, SQLException {
		String user = "root";
		String password = "123456";
		String url = "jdbc:mysql://localhost:3306/ycdemo?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone = GMT";
		String driverClass = "com.mysql.cj.jdbc.Driver";
//		// 1.加载数据库驱动
//		Class.forName(driverClass);
//		// 2.创建数据库连接
//		Connection conn = DriverManager.getConnection(url, user, password);
//		// 3.拼写sql语句
//		String sql = "Insert INTO tuser (uname,upassword) VALUES('孙尚香','sunshangxiang')";
//		// 4.发送sql语句
//		PreparedStatement prepareStatement = conn.prepareStatement(sql);
//		// 5.执行sql语句
//		int executeUpdate = prepareStatement.executeUpdate(sql);
//		// 6.处理返回结果
//		if (executeUpdate>0) {
//			System.out.println("保存数据成功");
//		}else {
//			System.out.println("保存数据失败");
//		}
//		// 7.关闭资源
//		conn.close();
		Class.forName(driverClass);
		Connection connection=DriverManager.getConnection(url,user,password);
		String sqlString="insert into tuser (uname,upassword) values('luban','luban')";
		int executeUpdate = connection.prepareStatement(sqlString).executeUpdate(sqlString);
		if (executeUpdate>0) {
			System.out.println("success");
		}else {
			System.out.println("error");
		}
		connection.close();
	}

}
posted @ 2021-05-30 17:00  doufei  阅读(5)  评论(0编辑  收藏  举报  来源