$query = "insert into books values (' ".$isbn." ', ' ".$author." ', ' ".$title." ', ' ".$price." ')"

<?php
//分析PHP两个语句的执行过程
$isbn = 111111;
$author = "David";
$title = "ePHP";
$price = 99;
$query1 = "insert into books values (' ".$isbn." ', ' ".$author." ', ' ".$title." ', ' ".$price." ')";
$query2 = "insert into books values (' $isbn ', ' $author ', ' $title', ' $price ')";  
/*第一个语句,PHP见到双引号里面的变量时先解释变量,变成:
$query1 = "insert into books values (' ".111111." ', ' ".David." ', ' ".ePHP." ', ' ".99." ')";
echo "$quary1"; 将输出:insert into books values (' 111111 ', ' David ', ' ePHP ', ' 99 ')
该输出是由.号把insert into books values (' 和111111和 ', ' 和David和 ', ' 和ePHP和 ', ' 和99还有 ')
连接起来的。
第二个语句,PHP见到双引号里面的变量时先解释变量,变成:
$query2 = "insert into books values (' 111111 ', 'David ', ' ePHP', ' 99 ')"; 
echo "$query2";输出同上。
该输出是把双引号内的字符串输出来。 */
echo "$query1";
echo "<br />";
echo "$query2";
?>

$query = "insert into books values (' ".$isbn." ', ' ".$author." ', ' ".$title." ', ' ".$price." ')"

这个语句出自 PHP和MySQL Web开发(原书第4版)

import java.sql.*;public class BookManagementSystem { private Connection connection; private Statement statement; private ResultSet resultSet; public BookManagementSystem() { try { Class.forName("com.mysql.jdbc.Driver"); connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/library", "root", "password"); statement = connection.createStatement(); } catch (Exception e) { e.printStackTrace(); } } public void query(String isbn) { try { resultSet = statement.executeQuery("SELECT * FROM books WHERE isbn='" + isbn + "'"); if (resultSet.next()) { System.out.println(resultSet.getString("title") + ", 作者:" + resultSet.getString("author") + ", 价格:" + resultSet.getDouble("price") + ", 出版社:" + resultSet.getString("publisher")); } else { System.out.println("没有找到书籍"); } } catch (Exception e) { e.printStackTrace(); } } public void input(String isbn, String title, String author, double price, String publisher) { try { statement.executeUpdate("INSERT INTO books VALUES('" + isbn + "', '" + title + "', '" + author + "', " + price + ", '" + publisher + "')"); System.out.println("书籍添加成功,图书信息为:" + isbn + " " + title + ", 作者:" + author + ", 价格:" + price + ", 出版社:" + publisher); } catch (Exception e) { e.printStackTrace(); } } public static void main(String[] args) { BookManagementSystem bms = new BookManagementSystem(); if (args[0].equals("query")) { bms.query(args[1]); } else if (args[0].equals("input")) { bms.input(args[1], args[2], args[3], Double.parseDouble(args[4]), args[5]); } }}
06-11
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值