先创建一个pacakge包,把mysql的java压缩包放进去然后按add as library,这样可以引用mysql的包
成功的话压缩包可以展开
下面是数据库连接,sql语句简单的代码
package Day1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class Text {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//导入jar包
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//获得数据库连接对象
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb1", "root", "root");
//定义sql语句
String sql = "update student set age =18 where id =1";
//获得sql执行对象
Statement sta =conn.createStatement();
//执行sql语句
int coount =sta.executeUpdate(sql);
//处理结果
System.out.println(coount);
//释放资源
sta.close();
conn.close();
}
}