昨天下午民大招生办公布了我校外省2006年美术类高考专业合格线。我下午去了趟招生办,将民大的外省2006年艺术类专业考试成绩由Excel导入MySQL数据库,晚上根据招生办的要求对我编写的“艺术类高考查询与回执系统”作了最后的修改,终于赶在今天上午前8点,开通了成绩查询。
  
  一、数据库由Excel导入MySQL后,根据招生办的要求对数据某些部分进行了修改(在phpMyAdmin中执行了以下SQL语句。这些SQL语句比较实用,所以写出来保存一下,以后可能还会用到。):
  
  1、将考生的专业总分四舍五入,保留一位小数,与分数线格式保持一致。例如159.66五入转为159.7,159.49四舍转为159.4。真是感叹,0.01分可以决定人生。
  UPDATE `art_student` SET `zyf` = ROUND(`zyf`,1)
  
  2、河北、山西、江西、山东四省考生因为没有专门的查询密码,将身份证号设为查询码。以下是将身份证号字符sfzh的信息复制到密码字段pass
  UPDATE `art_student` SET `pass` = `sfzh` WHERE `kd` = '河北' OR `kd` = '山西' OR `kd` = '江西' OR `kd` = '山东青岛' OR `kd` = '山东潍坊'
  
  3、查询一下返回记录数,看看某省(例如湖南)达到分数线(158.3)的考生人数是否有误。
  SELECT *  FROM `art_student` WHERE `zyf` >= 158.3 AND `kd` = '湖南'
  
  4、河南大部分考生准考证上都有查询密码,但准考证号在123456(仅举例,无此准考证号)之后的考生无查询密码,故将姓名字段xm的第一个汉字作为查询密码。
  UPDATE `art_student` SET `pass` = left(`xm`,2) WHERE `kd` = '河南' AND `zkzh` >= 123456
  
  5、因为第4步操作完成后,发现有些考生的姓名的第一个汉字可能是录入计算机时因字迹潦草而无法辨认,使用了全角?号代替,为了考生输入方便,将?改为a
  UPDATE `art_student` SET `pass` = 'a' WHERE `kd` = '河南' AND `zkzh` >= 123456 AND `pass` = '?'
  
  二、对web页面的输入表单作了以下两点修改:
  
  1、考虑到很多考生是在网吧查询分数、填写回执,所以我设置了登录框输入的信息不会在浏览器的历史记录中保存。
  例如:< input name="zkzh" type="text" AUTOCOMPLETE="off">
  加上AUTOCOMPLETE="off"就可以实现不保存表单历史记录。
  
  2、关闭输入法,回执填写表单中的邮编、电话、身份证号等输入框不能输入全角汉字,以免某些考生输入全角数字(例如123),造成格式不统一。
  例如:< input name="sfzh" type="text" style="IME-MODE: disabled">
  加上style="IME-MODE: disabled"就可以实现关闭输入法。




电脑杂谈 | 评论(24) | 引用(0) | 阅读(12143)
louis vuitton uk Email Homepage
2011-11-22 17:21
This louis vuitton uk for sale belongs to the sounding just what are termed as Louis Vuitton vintage best sellers, many other products and services for the reason that range appearing companies.You will easily notice the unfold zippers of this coach outlet store online. That is the decoration. There are some inside pockets for you as well. They are easy to match your clothes and to carry.Let us inspire your inner beauty with fine christian louboutin sale. Purse the elegance in bridal wedding. Enjoy the fashion.
armani watches Email Homepage
2011-11-23 10:21
If you are looking for armani Bags, our armani watches Handbags Canada outlet store is your first choice. We promise Original Packing and Best Discount,3-5 Workdays To Your Door!If you buy bags and purses of the latest new designs from the louis vuitton outlet now, you can enjoy special discounts. What else are you waiting for?After you choose the right kind of plants and the size pot for the plant.
coach factory outlet Email Homepage
2012-5-17 09:30
Today, following half a century, mentor leather-bases coach factory outlet continues to be the delicate craft of leather-based master is accountable for,Would you like to meet more friends, or go with the times? If yes, coach factory online is opening welcome doors to you.in the market you definitely can find various colorways that are designed in as well as the high quality that applied in. For most of you would like to come. So just come to our coach factory outlet online store to choose one.
louis vuitton sale Email Homepage
2012-5-17 09:30
Louis Vuitton belt at louis vuitton sale is one kind of fashion accessory with high cost performance among the Louis Vuitton accessories.Offering quality LV products with favorable prices, louis vuitton outlet store is at your service. Hurry up, or you can not seize the chance.in fact, louis vuitton is one of the most famous fashion design master.he opened the fist suitcase shop called after his name.
coach outlet online Email Homepage
2012-5-17 09:31
I heard of coach outlet online through the advertisement when I was shopping. And now I often brow the webpage and buy Coach bags online.It is a symbol regarding position not to mention nature.Here I would like to launch a excellent bags pertaining to business men.Which may be coach outlet store.coach outlet has always been simple,durable style features to win consumers.The products are more flexible,with easy bleaching,wear characteristics,and simply use a damp cloth.
coach outlet, Email Homepage
2012-5-17 09:31
Remember the coach outlet provide coach bags which won't be deteriorated into its overall styles by any means. It will maintain its looks, colors, and uniqueness for long time.coach outlet store online has been voted by Hour Detroit magazine readers as the Best of Detroit in their 12th annual readers'poll.Lots of women like which usually amount normally include a coach outlet online ,it provides coziness to many girls that don't even think it is a great bushel of great interest directly to them.
xujie777 Email
2012-5-18 13:58
We aim to make all our customers satisfy with our products. You will find a variety of Men's fashion louis vuitton uk, fashion Women's cheap Louis Vuitton bags in our store at affordable price.Thinking of interesting ways to cost a milestone birthday? louis vuitton online shop had one of the most distinctive distinctive celebrations.bakery along with living room operated by means of about three moment louis vuitton online Most effective Pastry Chef’s of the year Rammy Nominee Chef’s.
xujie777 Email
2012-5-18 13:58
The choices are likely to be basically countless seeing that louis vuitton outlet occurs with the help of completely new and also incredible concepts once in a while.Louis vuitton Wholesale Monogram Canvas HandbagsLouis Vuitton Collection Beach Handbags louis vuitton bags outlet Damier Canvas HandbagsLouis vuitton Mahina HandbagsLouis Vuitton Monogram Mini Lin HandbagsLouis Vuitton Monogram Multicolore HandbagsLouis vuitton Monogram Vernis HandbagsLouis Vuitton Wholesale Epi Leather HandbagsLouis Vuitton For Men HandbagsLouis Vuitton Damier Canvas WalletsLouis Vuitton Epi Leather WalletsLouis Vuitton Monogram Canvas WalletsLouis Vuitton Monogram Vernis WalleLouis Vuitton ShoesLouis Vuitton Men wallets.As the Authentic Louis Vuitton are so high-priced, so came the louis vuitton handbags outlet.
xujie777 Email
2012-5-18 13:58
coach outlet has become a popular shopping experience for consumers around the world, and a desirable distribution channel for manufacturer's and retailers.Getting your hands on coach outlet store online can be a hefty investment of hundreds of dollars.But do not despair,the Coach Outlet store could be the answer to your prayers.coach outlet online is your smart choice when you want to get the discount Coach accessory. You can find the exact Coach Bags and other accessory you want at a low price that's right for you. My dear friends, let the coach outlet online pave your way into the world of high fashion with their ultimate fashion factory.
xujie111 Email
2012-5-21 10:27
Our online store offers you discounted Designer louis vuitton replica wallet at present. You could find them in desirable quality and price. If you don't mind high class louis vuitton uk, have a good time here.louis vuitton Store Online Handbags can also bring great accuracy as well as practical applicability and fashionable.Have you ever dreamed of being as charming as Madonna? Have you ever thought of becoming an envy of all your friends? If so, come to louis vuitton outlet.<br/>
xujie555
2012-5-21 11:52
coach factory outlet uses graceful accessories to match the classical logo of coach, which is the best combination of coach. The handmade coach products?can make you more charming and graceful.coach factory online provides people many coach goods. If you wish to snatch the coach handbag, then this best method is made for that you like for coach discount.coach factory outlet online is a fashion brand to ensure its quality. With designer coach shoulder bags, you will always attract people's attention. The bags will emphasize your personal style and taste.<br/>
xujie333
2012-5-21 14:10
coach outlet online Store guarantee that all the coach handbags offered are own high quality. In addition , all of them are sold at an unexpected low price.If you want to purchase, just visit their website.coach factory outlet is really sizzling kinds of shopping way for you. With the usage of the replica designer coach bags, you can surely be able to change your individual looks in a stunning manner.Coach bags on sale from the coach outlet are cheap or discount prices that you certainly will stand out from the crowd on your next camping trip!<br/>
coach88888888 Email
2012-8-13 17:04
Coach Factory Outlet can design new and original products that are also functional. The stylish appearance of products, sophisticated workmanship, superior quality and highly competitive prices have won the customer's trust and love from consumers at home and abroad. So you can rest assured that purchase.Coach Factory Online are loved by many people, when you walk in the street, you could see many people take coach styles.And Coach Outlet Online is a great gift because there are many different styles that could be coordinated with different personalities together.If your dream is to look like a million bucks for a mere several dollars, then our Coach Outlet store is the Jiminy Cricket of your existence.
Julie N. Gomez
2021-9-30 22:24
I am very enjoyed for this blog. Its an informative topic. It help me very much to solve some problems. Its opportunity are so fantastic and working style so speedy For More Information
shz Email
2022-8-14 16:21
I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful.  Lead generation
shz Email
2022-8-14 16:23
Glad to chat your blog, I seem to be forward to more reliable articles and I think we all wish to thank so many good articles, blog to share with us.  Lead generation
shz Email
2022-8-14 16:26
It is perfect time to make some plans for the future and it is time to be happy. I’ve read this post and if I could I desire to suggest you few interesting things or tips. Perhaps you could write next articles referring to this article. I want to read more things about it!  Lead generation
shzz Email
2022-8-14 16:27
Wonderful illustrated information. I thank you about that. No doubt it will be very useful for my future projects. Would like to see some other posts on the same subject!  Lead generation
shz Email
2022-8-14 16:28
It is the intent to provide valuable information and best practices, including an understanding of the regulatory process.  Lead generation
shzz Email
2022-8-14 16:30
I must admit that your post is really interesting. I have spent a lot of my spare time reading your content. Thank you a lot!  Lead generation
分页: 1/2 第一页 1 2 下页 最后页
发表评论
表情
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
打开HTML
打开UBB
打开表情
隐藏
记住我
昵称   密码   游客无需密码
网址   电邮   [注册]