Linux 网络服务器构架实务之六_MySql_学习笔记★闵涛★计算机学习电脑编程软硬件技巧


	转至繁体中文版	\| 网站首页 \| 图文教程 \| 资源下载 \| 站长博客 \| 图片素材 \| 武汉seo \| 武汉网站优化 \|

Linux 网络服务器构架实务之六

作者：闵涛文章来源：闵涛的学习笔记点击数：2532 更新时间：2009/4/22 20:46:06

insert into prov values (''''26'''',''''四川'''');

insert into prov values (''''27'''',''''天津'''');

insert into prov values (''''28'''',''''西藏'''');

insert into prov values (''''29'''',''''新疆'''');

insert into prov values (''''30'''',''''云南'''');

insert into prov values (''''31'''',''''浙江'''');

insert into prov values (''''32'''',''''香港'''');

insert into prov values (''''33'''',''''澳门'''');

insert into prov values (''''34'''',''''台湾'''');

##按如下方式添加的帐户只对yesgo数据库具有权限，而且对它拥有全部权限。但为什么要添加四次呢？主要是host的不同，需要注意的是，MySQL验证是一个连接是否正确，不仅取决于帐号和密码，还要看主机名和数据库名。

mysql –p

mysql> grant all privileges on yesgo.* to your_user_name@localhost identified by ‘your_password’ with grant option;

mysql> grant all privileges on yesgo.* to your_user_name@’ns.yesgo.loc’ identified by ‘your_password’ with grant option;

mysql> grant all privileges on yesgo.* to your_user_name@’192.168.1.2’ identified by ‘your_password’ with grant option;

mysql> grant all privileges on yesgo.* to your_user_name@’%’ identified by ‘your_password’ with grant option;

mysql>exit

touch /home/www/cnmysql.jsp

chown –R www /home/www/cnmysql.jsp

chgrp –r root /home/www/cnmysql.jsp

chmod 771 /home/www/cnmsql.jsp

vi /home/www/cnmsql.jsp

## 源代码如下：

<%@ page language="java" import="java.sql.*"%>

Class.forName ("org.gjt.mm.mysql.Driver");

Connection conn = DriverManager.getConnection("jdbc:mysql://host_name/db_name","user_name","password");

Statement stmt = conn.createStatement();

ResultSet rs=stmt.executeQuery("select * from prov");

rs.next();