RiverHillsNOW
Find out what is happening at the North Shore Library. Keep up with all of the upcoming programs and events here at the library.
Also, get the updates on the latest and hottest books and movies to be added to the library&s collection.
Michael Franks, CFP&, CRPC& is a Certified Financial Planner& certificant (CFP&), a designation award by the Certified Financial Planner Board of Standards, Inc., and a Chartered Retirement Planning Counselor& (CRPC), a designation awarded by the College of Financial Planning. He began his career in New York in 1994, working for 12 years as an Institutional salesman, selling equity ideas to mutual funds, hedge funds, banks and insurance companies. In 2006 he transitioned to working with individual investors, a move driven by his desire to have a more positive impact on individual&s lives. Over the last several years he has helped clients navigate some of the most challenging markets of our lifetime. Mike earned a B.S. in business management from Cornell University.
Front Porch Financial Management LLC is a separate entity from LPL Financial. &Securities and Advisory services offered through LPL Financial, a Registered Investment Advisor and Member of FINRA/SIPC.&
Jenna Behrens is a licensed professional counselor who has been practicing in the mental health field for seven years. She owns Behrens Psychotherapy Services, LLC which has four office locations around the Milwaukee area. She works with children, adolescents, families, and adults on a wide array of issues including depression, anxiety, ADHD, childhood behavioral disorders, adjustment disorders, stress and parenting.
I have had two careers: (1) teaching the social studies (2) selling promotional merchandise.
Teaching is selling: selling is teaching.
Alamelu Vairavan, a Whitefish Bay resident, is an author and culinary instructor. Alamelu has a passion for educating the public about the use of spices and legumes in preparing healthy and tasty foods. She is also interested in educating the public about the growing research that points to the enormous health benefits of spices in preventing many diseases. Her mission is to enrich people's culinary experience and to inspire them to discover that cooking and sharing healthful foods can be an especially joyful experience.
Visit Alamelu's web site,
With a warm smile, Dr. Abbey LaManna is focused on keeping your teeth healthy and providing a positive and relaxing dental experience at Lakeshore Family Dentistry in Glendale.
Brown Deer mom offers helpful &takeaways& while traveling about town with two girls, ages 6 and 3.
It&s not rocket science, just a slice of life.
The Wisconsin Humane Society (WHS) is a private, nonprofit organization whose mission is to build a community where people value animals and treat them with respect and kindness. For more than 128 years, WHS has been saving the lives of animals in need. We offer adoption services that place 9,000 animals in new homes annually, veterinary services that save thousands of lives, educational programs that instill respect for animals, behavior services to assist guardians and a myriad of other initiatives that help end suffering for animals. We depend entirely on private donations to fund our programs and rely on volunteers in nearly every department. If you are interested in adopting, volunteering, enrolling in a class, taking a tour or making a donation, check out our comprehensive web site at
The adoptable animals' web pages are updated every 30 minutes!
IMPACT is committed to changing lives, for good. Our family of services helps restore the health and productivity of individuals, organizations and workplaces leading to an improved quality of life for our entire community.
IMPACT 2-1-1 is a central access point for people in need. During times of personal crisis or community disaster the free, confidential helpline and online resource directory make it easy for residents to get connected to information and assistance.
IMPACT Alcohol and Drug Abuse Services includes consultation and referral for people concerned about alcohol or drug use.
IMPACT Awareness raises community consciousness about risky drinking and promotes healthy lifestyles with the stop drinking [SO MUCH] milwaukee campaign.
IMPACT Workplace Services provides consultation, training and employee assistance programs to foster a healthy and productive work environment.
North Shore Fire/Rescue provides fire, emergency medical and life safety services to the City of Glendale and the Villages of Bayside, Brown Deer, Fox Point, River Hills, Shorewood and Whitefish Bay.
Community Watch
Advertisement
Advertisement
How to Subscribe
Advertisement
Local Business Directory
Powered by
Public Notices
Click here for a .
Most Popular17308人阅读
Javascript（20）
nodejs（8）
1、建立数据库连接：createConnection(Object)方法
& & & 该方法接受一个对象作为参数，该对象有四个常用的属性host，user，password，database。与php中链接数据库的参数相同。属性列表如下：
host: 连接数据库所在的主机名. (默认: localhost)
port: 连接端口. (默认: 3306)
localAddress: 用于TCP连接的IP地址. (可选)
socketPath: 链接到unix域的路径。在使用host和port时该参数会被忽略.
user: MySQL用户的用户名.
password: MySQL用户的密码.
database: 链接到的数据库名称 (可选).
charset: 连接的字符集. (默认: 'UTF8_GENERAL_CI'.设置该值要使用大写!)
timezone: 储存本地时间的时区. (默认: 'local')
stringifyObjects: 是否序列化对象. See issue #501. (默认: 'false')
insecureAuth: 是否允许旧的身份验证方法连接到数据库实例. (默认: false)
typeCast: 确定是否讲column值转换为本地JavaScript类型列值. (默认: true)
queryFormat: 自定义的查询语句格式化函数.
supportBigNumbers: 数据库处理大数字(长整型和含小数),时应该启用 (默认: false).
bigNumberStrings: 启用 supportBigNumbers和bigNumberStrings 并强制这些数字以字符串的方式返回(默认: false).
dateStrings: 强制日期类型(TIMESTAMP, DATETIME, DATE)以字符串返回，而不是一javascript Date对象返回. (默认: false)
debug: 是否开启调试. (默认: false)
multipleStatements: 是否允许在一个query中传递多个查询语句. (Default: false)
flags: 链接标志.还可以使用字符串连接数据库例如：var connection = mysql.createConnection('mysql://user:pass@host/db?debug=true&charset=BIG5_CHINESE_CI&timezone=-0700');2、结束数据库连接end()和destroy()
end()接受一个回调函数，并且会在query结束之后才触发，如果query出错，仍然会终止链接，错误会传递到回调函数中处理。
destroy()立即终止数据库连接，即使还有query没有完成，之后的回调函数也不会在触发。
3、创建连接池 createPool(Object) &Object和createConnection参数相同。
可以监听connection事件，并设置session值
pool.on('connection', function(connection) {
connection.query('SET SESSION auto_increment_increment=1')
});connection.release()释放链接到连接池。如果需要关闭连接并且删除，需要使用connection.destroy()
pool除了接受和connection相同的参数外，还接受几个扩展的参数createConnection: 用于创建链接的函数. (Default: mysql.createConnection)
waitForConnections: 决定当没有连接池或者链接数打到最大值时pool的行为. 为true时链接会被放入队列中在可用是调用，为false时会立即返回error. (Default: true)
connectionLimit: 最大连接数. (Default: 10)
queueLimit: 连接池中连接请求的烈的最大长度，超过这个长度就会报错，值为0时没有限制. (Default: 0)4、连接池集群
允许不同的host链接// create
var poolCluster = mysql.createPoolCluster();
poolCluster.add(config); // anonymous group
poolCluster.add('MASTER', masterConfig);
poolCluster.add('SLAVE1', slave1Config);
poolCluster.add('SLAVE2', slave2Config);
// Target Group : ALL(anonymous, MASTER, SLAVE1-2), Selector : round-robin(default)
poolCluster.getConnection(function (err, connection) {});
// Target Group : MASTER, Selector : round-robin
poolCluster.getConnection('MASTER', function (err, connection) {});
// Target Group : SLAVE1-2, Selector : order
// If can't connect to SLAVE1, return SLAVE2. (remove SLAVE1 in the cluster)
poolCluster.on('remove', function (nodeId) {
console.log('REMOVED NODE : ' + nodeId); // nodeId = SLAVE1
poolCluster.getConnection('SLAVE*', 'ORDER', function (err, connection) {});
// of namespace : of(pattern, selector)
poolCluster.of('*').getConnection(function (err, connection) {});
var pool = poolCluster.of('SLAVE*', 'RANDOM');
pool.getConnection(function (err, connection) {});
pool.getConnection(function (err, connection) {});
// destroy
poolCluster.end();链接集群的可选参数canRetry: 值为true时，允许连接失败时重试(Default: true)
removeNodeErrorCount: 当连接失败时 errorCount 值会增加. 当errorCount 值大于 removeNodeErrorCount 将会从PoolCluster中删除一个节点. (Default: 5)
defaultSelector: 默认选择器. (Default: RR)
RR: 循环. (Round-Robin)
RANDOM: 通过随机函数选择节点.
ORDER: 无条件地选择第一个可用节点.
5、切换用户/改变连接状态Mysql允许在比断开连接的的情况下切换用户
connection.changeUser({user : 'john'}, function(err) {
user: 新的用户 (默认为早前的一个).
password: 新用户的新密码 (默认为早前的一个).
charset: 新字符集 (默认为早前的一个).
database: 新数据库名称 (默认为早前的一个).
6、处理服务器连接断开var db_config = {
host: 'localhost',
user: 'root',
password: '',
database: 'example'
function handleDisconnect() {
connection = mysql.createConnection(db_config); // Recreate the connection, since
// the old one cannot be reused.
connection.connect(function(err) {
// The server is either down
// or restarting (takes a while sometimes).
console.log('error when connecting to db:', err);
setTimeout(handleDisconnect, 2000); // We introduce a delay before attempting to reconnect,
// to avoid a hot loop, and to allow our node script to
// process asynchronous requests in the meantime.
// If you're also serving http, display a 503 error.
connection.on('error', function(err) {
console.log('db error', err);
if(err.code === 'PROTOCOL_CONNECTION_LOST') { // Connection to the MySQL server is usually
handleDisconnect();
// lost due to either server restart, or a
// connnection idle timeout (the wait_timeout
// server variable configures this)
handleDisconnect();7、转义查询值
为了避免SQL注入攻击，需要转义用户提交的数据。可以使用connection.escape() 或者 pool.escape()
var userId = 'some user provided value';
= 'SELECT * FROM users WHERE id = ' + connection.escape(userId);
connection.query(sql, function(err, results) {
或者使用？作为占位符
connection.query('SELECT * FROM users WHERE id = ?', [userId], function(err, results) {
不同类型值的转换结果
Numbers 不变
Booleans 转换为字符串 'true' / 'false'
Date 对象转换为字符串 'YYYY-mm-dd HH:ii:ss'
Buffers 转换为是6进制字符串
Strings 不变
Arrays =& ['a', 'b'] 转换为 'a', 'b'
嵌套数组 [['a', 'b'], ['c', 'd']] 转换为 ('a', 'b'), ('c', 'd')
Objects 转换为 key = 'val' pairs. 嵌套对象转换为字符串.
undefined / null ===& NULL
NaN / Infinity 不变. MySQL 不支持这些值,
除非有工具支持，否则插入这些值会引起错误.
转换实例：
= {id: 1, title: 'Hello MySQL'};
var query = connection.query('INSERT INTO posts SET ?', post, function(err, result) {
console.log(query.sql); // INSERT INTO posts SET `id` = 1, `title` = 'Hello MySQL'
或者手动转换
var query = &SELECT * FROM posts WHERE title=& + mysql.escape(&Hello MySQL&);
console.log(query); // SELECT * FROM posts WHERE title='Hello MySQL'
8、转换查询标识符
如果不能信任SQL标识符(数据库名、表名、列名)，可以使用转换方法mysql.escapeId(identifier)；var sorter = 'date';
var query = 'SELECT * FROM posts ORDER BY ' + mysql.escapeId(sorter);
console.log(query); // SELECT * FROM posts ORDER BY `date`
支持转义多个
var sorter = 'date';
var query = 'SELECT * FROM posts ORDER BY ' + mysql.escapeId('posts.' + sorter);
console.log(query); // SELECT * FROM posts ORDER BY `posts`.`date`
可以使用??作为标识符的占位符
var userId = 1;
var columns = ['username', 'email'];
var query = connection.query('SELECT ?? FROM ?? WHERE id = ?', [columns, 'users', userId], function(err, results) {
console.log(query.sql); // SELECT `username`, `email` FROM `users` WHERE id = 1
9、准备查询
可以使用mysql.format来准备查询语句，该函数会自动的选择合适的方法转义参数。var sql = &SELECT * FROM ?? WHERE ?? = ?&;
var inserts = ['users', 'id', userId];
sql = mysql.format(sql, inserts);
10、自定义格式化函数
connection.config.queryFormat = function (query, values) {
if (!values)
return query.replace(/\:(\w+)/g, function (txt, key) {
if (values.hasOwnProperty(key)) {
return this.escape(values[key]);
}.bind(this));
connection.query(&UPDATE posts SET title = :title&, { title: &Hello MySQL& });
11、获取插入行的id
当使用自增主键时获取插入行id，如：connection.query('INSERT INTO posts SET ?', {title: 'test'}, function(err, result) {
console.log(result.insertId);
12、流处理
有时你希望选择大量的行并且希望在数据到达时就处理他们，你就可以使用这个方法var query = connection.query('SELECT * FROM posts');
.on('error', function(err) {
// Handle error, an 'end' event will be emitted after this as well
.on('fields', function(fields) {
// the field packets for the rows to follow
.on('result', function(row) {
// Pausing the connnection is useful if your processing involves I/O
connection.pause();
processRow(row, function() {
connection.resume();
.on('end', function() {
// all rows have been received
13、混合查询语句（多语句查询）
&因为混合查询容易被SQL注入攻击，默认是不允许的，可以使用var connection = mysql.createConnection({multipleStatements: true});开启该功能。
&混合查询实例：connection.query('SELECT 1; SELECT 2', function(err, results) {
// `results` is an array with one element for every statement in the query:
console.log(results[0]); // [{1: 1}]
console.log(results[1]); // [{2: 2}]
});同样可以使用流处理混合查询结果：var query = connection.query('SELECT 1; SELECT 2');
.on('fields', function(fields, index) {
// the fields for the result rows that follow
.on('result', function(row, index) {
// index refers to the statement this result belongs to (starts at 0)
});如果其中一个查询语句出错，Error对象会包含err.index指示错误语句的id，整个查询也会终止。
混合查询结果的流处理方式是做实验性的，不稳定。
14、事务处理
connection级别的简单事务处理connection.beginTransaction(function(err) {
if (err) { }
connection.query('INSERT INTO posts SET title=?', title, function(err, result) {
if (err) {
connection.rollback(function() {
var log = 'Post ' + result.insertId + ' added';
connection.query('INSERT INTO log SET data=?', log, function(err, result) {
if (err) {
connection.rollback(function() {
mit(function(err) {
if (err) {
connection.rollback(function() {
console.log('success!');
15、错误处理err.code = string
err.fatal =& boolean
更详细的说明请查看：
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：74696次
排名：千里之外
原创：26篇
(3)(7)(1)(1)(3)(4)(2)(4)(1)(1)SouthMilwaukeeNOW
Kevin Fischer is a veteran broadcaster, the recipient of over 150 major journalism awards from the Milwaukee Press Club, the Wisconsin Associated Press, the Northwest Broadcast News Association, the Wisconsin Bar Association, and others. He has been seen and heard on Milwaukee TV and radio stations for over three decades. A longtime aide to state Senate Republicans in the Wisconsin Legislature, Kevin can be seen offering his views on the news on the public affairs program, &InterCHANGE,& on Milwaukee Public Television Channel 10, and heard filling in on Newstalk 1130 WISN. He lives with his wife, Jennifer, and their lovely young daughter, Kyla Audrey, in Franklin.
I am an Ultra-Conservative, Alpha-Male, True Authentic Leader, Type &C& Personality, who is very ac whether it is donating time, clothes or money for Project Concern or going to Common Council meetings and voicing my opinions. As a blogger, I intend to provide a different viewpoint &The way I see it!& on various world, national and local issues with a few helpful tips & tidbits sprinkled in.
Jennifer is a one in a million stay-at-home mom.
(More like one OF a million stay at home moms!)
She graduated from a liberal arts college but there is nothing liberal OR artsy about her.
She is married to Kevin Fischer of This Just In, and together they have a beautiful young daughter Kyla Audrey.
In no particular order she loves dogs, wine, a good bargain, her family, pizza, and entertaining.
Follow her blog of all things miscellaneous including but not limited to cooking and baking, entertaining and party planning, being a mommy, and homekeeping.
I am a husband, father, son, brother, uncle and friend. I believe in sharing my talents and experiences by giving back to the community by giving my time to coaching, church and especially to the disability community.
I truly believe that all men and women are created equally.
Family lured Jerrianne and her husband to South Milwaukee in 2002 from Southern California where she worked as, first, a journalist, then, as a court information officer. She now stays busy with media-relations consulting, playing with her three grandchildren (part of the lure), writing, discovering her new environs, and hoping her garden will produce before the first fall frost.
My name is Kristan T. Harris. I have run for political office and have worked a political grass roots campaign for Ron Paul. I was nominated and elected to the GOP platform committee in 2012.
I am a huge advocate for liberty and freedom.I am a libertarian at heart. I am also a news junkie and love a good mystery.
Former Cudahy Student turned American Soldier. Just here to share my experiences.
The Wisconsin Humane Society (WHS) is a private, nonprofit organization whose mission is to build a community where people value animals and treat them with respect and kindness. For more than 128 years, WHS has been saving the lives of animals in need. We offer adoption services that place 9,000 animals in new homes annually, veterinary services that save thousands of lives, educational programs that instill respect for animals, behavior services to assist guardians and a myriad of other initiatives that help end suffering for animals. We depend entirely on private donations to fund our programs and rely on volunteers in nearly every department. If you are interested in adopting, volunteering, enrolling in a class, taking a tour or making a donation, check out our comprehensive web site at
The adoptable animals' web pages are updated every 30 minutes!
IMPACT is committed to changing lives, for good. Our family of services helps restore the health and productivity of individuals, organizations and workplaces leading to an improved quality of life for our entire community.
IMPACT 2-1-1 is a central access point for people in need. During times of personal crisis or community disaster the free, confidential helpline and online resource directory make it easy for residents to get connected to information and assistance.
IMPACT Alcohol and Drug Abuse Services includes consultation and referral for people concerned about alcohol or drug use.
IMPACT Awareness raises community consciousness about risky drinking and promotes healthy lifestyles with the stop drinking [SO MUCH] milwaukee campaign.
IMPACT Workplace Services provides consultation, training and employee assistance programs to foster a healthy and productive work environment.
Community Watch
Advertisement
Advertisement
Zoo Interchange Projects
Advertisement
Local Business Directory
Powered by
Most Popular