ÔõôÔÚjspÁ´½Ósqlserver2000
ÔõôÔÚjspÁ´½Ósqlserver2000£¬Ìø×ªÀϲ»³É¹¦£¬²»¹ÜÔõôÊäÈ룬ÃÜÂëÓû§Ãû¶¼ÓÐ´í£¬Õâ¸öµÄÎÊÌâÊdzöÔÚÄÇ£¬Çë¸ßÊÖÒ»¶¨Òª°ïÎÒ°¡£¬Ð»Ð»
°ÑÄãµÄjsp¶«Î÷Ìù³öÀ´°¡
ÏȰѴúÂëÌù³öÀ´²ÅÄÜÖ»Äܵ½ÊÇʲô´í¡£
±¨µÄɶ´í
ÄãÁ¬½ÓÉÏÁËû
ÎÒµÄ×ÊÔ´ÀïÓб¾ myEclipse ¿ª·¢ÖÐÎĽ̳̣¬Â¥Ö÷¿ÉÒÔÈ¥¿´¿´
´úÂë ºÍ±¨´íÐÅÏ¢
Ê×ÏÈ¿´Á¬½ÓÊý¾Ý¿âÓÐûÓдí,ÊÇÖ±Á¬»¹ÊÇÇÅÁ¬.Èç¹ûÁ¬½ÓÕýÈ·,ÄǾÍÊÇÊý¾Ý¿â²Ù×÷Óï¾ä´íÎó»òÅжϳö´íÀ².
Òª¿´ÄãµÄÊÇʲôÊý¾Ý¿â£¬SQLServer£¬Oracle£¿
¶Ë¿Ú號£¬連½Ó帳號¡£ÃÜ碼ÊÇ·ñÓÐ錯£¡
´úÂë~~~
ͬÒâÂ¥ÉϵÄÒâ¼û£¬ÓпÉÄÜÊÇÄãµÄ´úÂëÓдíÎó£¬Òì³£¡¢´úÂ롢ûÓÐÕâд¿´²»³öÀ´¡£
´úÂ붼ûÌù³öÀ´£¬Äãµ±ÎÒÃÇÊÇÉñÏɰ¡ £¿
Äã¼ÓÔØÇý¶¯ÁËÂð? SQL SERVER2002µÄºÍSQL SERVER 2005µÄÇý¶¯²»Ò»ÑùµÄ.µ½Î¢ÈíÍøÕ¾ÏÂÔØ.°ÑJIA°ü·ÅWEBINF/LIB ÏÂÃæ.
Õâ¸öÊÇÎÒµÄÕû¸öϵͳÁ´½ÓÊý¾Ý¿âµÄ³ÌÐò£¬´ó¼Ò¿´¿´´íÔÚÄÇÂð£¬ÎÒÁ´½ÓµÄÊÇmf sqlserver 2000
package com.course;
import java.io.*;
import java.sql.*;
public class sqlBean{///
public Connection conn=null;
public ResultSet rs=null;
//ÉùÃ÷Êý¾Ý¿âÁ¬½Ó×Ö·û´®
private String DatabaseDriver="sun.jdbc.odbc.JdbcOdbcDriver";
//DataSource Êý¾ÝÔ´Ãû³ÆDSN
private String DatabaseConnStr="jdbc:odbc:ClassDB,'sa',";
//¶¨Òå·½·¨
/*setXxxÓÃÓÚÉèÖÃÊôÐÔÖµ;getXxxÓÃÓڵõ½ÊôÐÔÖµ*/
public void setDatabaseDriver(String
Ïà¹ØÎÊ´ð£º
ÎҵĿª·¢µÄƽ̨ÊÇMyeclipes6.0 + tomcat5.x + mysql
ÎÒËùÓеıàÂ뷽ʽ¶¼ÊÇÓõÄUTF-8
ÎÒÖ»ÓÃÁËStrtus¿ò¼Ü
ÔÚÒ»¸öformÖÐÈçÏÂÓõÄÊÇpostµÄÌá½»·½Ê½£º
<form class="form" action=&quo ......
ÎÒÏëµÇ¼ºó£¬Èç¹ûµÇ¼³É¹¦¾ÍÈ¥Ö´ÐÐij¸öÒ³Ãæ
ÎÒÏÖÔڵĴúÂëÊÇÕâÑùµÄ£º
if(rs.next()){
session.setAttribute( "username" , user);
<jsp:include page="login.jsp" />// ......
jsÖеķ½·¨£¬²»ÄÜÔÚjspÖе÷ÓÃÔõô½â¾ö£¿¼±£¡£¡!
²»Ã÷°×Òâ˼
ºÃºÃ¼ì²éÊDz»ÊÇ·¾¶µÄÎÊÌ⣬ºÜÓпÉÄÜ·¾¶²»¶Ôµ¼Öµ÷Óò»µ½
Ìùһϵ÷ÓõĴúÂë¿´¿´°¡~~
ÓÐûÓÐÕýÈ·ÒýÓÃjs£¿º¯ÊýÓÐûÓгõʼ»¯£¿....
jsp´úÂë±¾À´¾ ......
ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ ËÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá
ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:
public void doPost(HttpServletRequest reque ......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......