1、dos命令访问mysql实验报告1、连接数据库mysql -u username p userpasswd2、查看所有数据库show databases;3、选择数据库use databasename;3、查看该数据库下所有表show tables;查看表内容:use tablename;4、查看表的区段describe 表名;5、查询表数据select * from tablename; 用js操作数据库:在E盘根目录下,按住shift键的同时单击鼠标右键,在此处打开命令窗口,然后执行如下操作在DOS窗口运行测试程序打印1,2,3,4,5,6,7,8,9,10命令如下:node test.j
2、s结果如下Test.js内代码如下:for(var i=0;i10;i+) console.log(i); 打印okTest.js内代码如下:var http=require(http); http.createServer(function(req,res) res.write(hello node); res.end(); ).listen(3000); console.log(ok);test.js:var mysql=require(mysql); console.log(mysql.createConnection();Test.js:var mysql =require(mysql
3、);var conn=mysql.createConnection( host:localhost, port:3306, user:root, password:root, database:xj2014 );console.log(conn);测试成功!实验过程:123.js/引用var mysql = require(mysql);/创建连接var connection = mysql.createConnection( host: localhost, /主机名称 user: root, /用户名 password: root, /密码 database: xj2014 /数据库);/
4、连接connection.connect();/执行操作connection.query(SELECT * from userinfo limit 0,1, function(err, rows, fields) console.log(err); console.info(rows); console.log(fields););/关闭连接connection.end();查询带参数查询123.js:/引用var mysql = require(mysql);/创建连接var connection = mysql.createConnection( host: localhost, /主机名
5、称 user: root, /用户名 password: root, /密码 database: xj2014 /数据库);/连接connection.connect();/执行操作connection.query(SELECT * from userinfo where name=?, 小银银, function(err, rows) if (err = null) console.info(rows); else console.log(error info: + err); );/关闭连接connection.end();查询结果:修改:123.js:/引用var mysql = req
6、uire(mysql);/创建连接var connection = mysql.createConnection( host: localhost, /主机名称 user: root, /用户名 password: root, /密码 database: xj2014 /数据库);/连接connection.connect();/执行操作connection.query(update userinfo set name=? where id=93, 小银银, function(err, rows) if (err = null) console.info(rows); /包含相关信息 else
7、 console.log(error info: + err); );/关闭连接connection.end();增添:123.js:/引用var mysql = require(mysql);/创建连接var connection = mysql.createConnection( host: localhost, /主机名称 user: root, /用户名 password: root, /密码 database: xj2014 /数据库);/连接connection.connect();/执行操作connection.query(insert into userinfo set nam
8、e=? , 萧萧, function(err, rows) if (err = null) console.info(rows); /包含相关信息 else console.log(error info: + err); );/关闭连接connection.end();实验结果:删除123.js:/引用var mysql = require(mysql);/创建连接var connection = mysql.createConnection( host: localhost, /主机名称 user: root, /用户名 password: root, /密码 database: xj201
9、4 /数据库);/连接connection.connect();/执行操作connection.query(delete from userinfo where id=96 , function(err, result) if (err = null) console.info(result); /包含相关信息 else console.log(error info: + err); );/关闭连接connection.end();实验结果:http.jsvar mysql =require(mysql);var conn=mysql.createConnection( host:localhost, port:3306, user:root, password:root, database:xj2014 );conn.connect();conn.query(select * from userinfo limit 1,function(err,data) console.log(data);)console.log(ok);conn.end();实验结果:
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1