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();
}
}
本文来自博客园,作者:doufei,转载请注明原文链接:https://www.cnblogs.com/lfdou/p/17412941.html