java php mysql数据库_PHP脚本和JAVA连接mysql数据库

环境

开发包：appserv-win32-2.5.10

服务器：Apache2.2

数据库：phpMyAdmin

语言：php5，java

平台：windows 10

java驱动：mysql-connector-java-5.1.37

需求

编写一个PHP脚本语言，连接到phpMyAdmin数据库的test库

编写一个java web服务端，连接到phpMyAdmin数据库的test库

代码

php连接方式

mysql.php

/*****************************

*数据库连接

*****************************/

$conn= @mysql_connect("localhost","root","123");

if(!$conn){

die("连接数据库失败：" .mysql_error());

}

mysql_select_db("test",$conn);

//字符转换，读库

mysql_query("set character set utf8");

mysql_query("set names utf8");

?>

test.php测试

error_reporting(0);//防止报错

include('mysql.php');

$result=mysql_query("select * from user");//根据前面的计算出开始的记录和记录数

//循环取出记录

$six;

while($row=mysql_fetch_row($result))

{

echo$row[0];

echo$row[1];

}

?>

运行截图：

java连接方式

1.新建一个java project为mysqlTest

2.加载JDBC驱动,mysql-connector-java-5.1.37

MySQLConnection.java

packagecom.mysqltest;

importjava.sql.Connection;

importjava.sql.DriverManager;

importjava.sql.SQLException;

/*

* **Mysql连接**

*

*参数：

* conn连接

* url mysql数据库连接地址

* user数据库登陆账号

* password数据库登陆密码

*方法：

* conn获取连接

*/

publicclassMySQLConnection {

publicstaticConnection conn =null;

publicstaticString driver ="com.mysql.jdbc.Driver";

publicstaticString url ="jdbc:mysql://127.0.0.1:3306/post";

publicstaticString user ="root";

publicstaticString password ="123";

/*

*创建Mysql数据连接第一步：加载驱动Class.forName(Driver)第二步：创建连接

*DriverManager.getConnection(url, user, password);

*/

publicConnection conn() {

try{

Class.forName(driver);

}catch(ClassNotFoundException e) {

System.out.println("驱动加载错误");

e.printStackTrace();

}

try{

conn = DriverManager.getConnection(url, user, password);

}catch(SQLException e) {

System.out.println("数据库链接错误");

e.printStackTrace();

}

returnconn;

}

}

Work.java

packagecom.mysqltest;

importjava.sql.Connection;

importjava.sql.PreparedStatement;

importjava.sql.ResultSet;

importjava.sql.SQLException;

/*

* mysql增删改查

*/

publicclassWork {

/*

* insert增加

*/

publicstaticintinsert() {

MySQLConnection connection =newMySQLConnection();

Connection conns;//获取连接

PreparedStatement pst;//执行Sql语句

inti = 0;

String sql = "insert into user (username,password)values(?,?)";

try{

conns = connection.conn();

pst = conns.prepareStatement(sql);

pst.setString(1, "lizi");

pst.setString(2, "123");

i= pst.executeUpdate();

pst.close();

conns.close();

}catch(SQLException e) {

System.out.println("数据写入失败");

e.printStackTrace();

}

returni;

}

/*

* select写入

*/

publicstaticvoidselect() {

MySQLConnection connection =newMySQLConnection();

Connection conns;//获取连接

PreparedStatement pst;//执行Sql语句(Statement)

ResultSet rs;//获取返回结果

String sql = "select * from user";

try{

conns = connection.conn();

pst = conns.prepareStatement(sql);

rs = pst.executeQuery(sql);//执行sql语句

System.out.println("---------------------------------------");

System.out.println("名字|密码");

while(rs.next()) {

System.out.println(rs.getString("username") + "        |       " + rs.getString("password"));

}

System.out.println("---------------------------------------");

conns.close();

pst.close();

rs.close();

}catch(SQLException e) {

System.out.println("数据查询失败");

e.printStackTrace();

}

}

/*

* update修改

*/

publicstaticintupdate() {

MySQLConnection connection =newMySQLConnection();

Connection conns;//获取连接

PreparedStatement pst;//执行Sql语句(Statement)

inti = 0;

String sql = "update user set password = ? where username =?";

try{

conns = connection.conn();

pst = conns.prepareStatement(sql);

pst.setString(1, "123");

pst.setString(2, "lizi");

i= pst.executeUpdate();

pst.close();

conns.close();

}catch(SQLException e) {

System.out.println("数据修改失败");

e.printStackTrace();

}

returni;

}

/*

* delete删除

*/

publicstaticintdelete() {

MySQLConnection connection =newMySQLConnection();

Connection conns;//获取连接

PreparedStatement pst;//执行Sql语句(Statement)

inti = 0;

String sql = "delete from user where username = ?";

try{

conns = connection.conn();

pst = conns.prepareStatement(sql);

pst.setString(1, "lizi");

i= pst.executeUpdate();

pst.close();

conns.close();

}catch(SQLException e) {

System.out.println("数据删除失败");

e.printStackTrace();

}

returni;

}

/*

* test

*/

publicstaticvoidmain(String[] args) {

//System.out.println(insert());

select();

//System.out.println(update());

// System.out.println(delete());

}

}