asp.netÁ¬½ÓmysqlÔõôдµÇ¼´úÂë
asp.netÁ¬½ÓmysqlÔõôдµÇ¼´úÂë
¹Ø¼üÊǰѵǼ´úÂëдÔÚ ÀàÖÐ
È»ºóǰ̨µÇ¼´úÂë¾ÍÖ»Óþ͵÷ÓÃÕâ¸ö ÀàC# code:
using System;//Õâ¸öÀàÖÐÒªÊÇÓдíÇëÖ¸³öÀ´£¬Ð»Ð»
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Configuration;
using MySql.Data.MySqlClient;
/// <summary>
///UserInfo µÄժҪ˵Ã÷
/// </summary>
public class UserInfo
{
public string user_name;
public string password;
public string str = System.Configuration.ConfigurationManager.AppSettings["strconn"];
MySqlConnection conn = new MySqlConnection();
MySqlCommand cmd = new MySqlCommand();
public string User_Name
{
get
{
return user_name;
}
set
{
user_name = value;
}
}
public string Password
{
get
{
return password;
}
set
{
password = value;
}
}
public bool CheckLogin()
{
conn = new MySqlConnection(str);
string sql = "Select count(user_name) from bg_user where username=? and password =?";
Ïà¹ØÎÊ´ð£º
СµÜÊǽñÄê¸Õ±ÏҵѧÉúÕÒÁ˺ܳ¤Ê±¼ä¹¤×÷ÁË,×ÜÊÇʧ°Ü£¬Ò»Ð©¹«Ë¾¶¼ÒªÓй¤×÷¾ÑéµÄ£¬¶¼±ÀÀ£ÁË£¬ËùÒÔÏëÇë¸÷λ´ó¸ç°ï¸öæ
½ñÌìÎÒÈ¥ÃæÊÔÁËÒ»¼Ò¹«Ë¾£¬ËûÊÇÏë×öÒ»¸ö¡°Ò½ÁƵÄÍøÕ¾¡±Ï൱ÓÚÊÇÍÆ¹ã×Ô¼ºµÄÒ½ÁÆ·½·¨°É£¬Ëû½ÐÎ ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
СµÜ¸ãASP.NETÒ²¿ì2ÄêÁË
µ«ÊǼܹ¹ÎÊÌâÒ»Ö±¶¼ÊÇÓõıðÈ˼ܹ¹ºÃµÄ
Ò»Ö±Ïë×Ôѧ¼Ü¹¹
ÓнéÉܺÃÊéµÄû£¿
´ó¼ÒÒ»Æð·ÖÏí¹þ
¸Ð¼¤²»¾´°¡
sf
ÏÈѧ»ù±¾µÄ°É¡¶Äã±ØÐëÖªµÀµÄ.NET¡·
ѸÀ×ÉÏ¿ÉÒÔϵġ£
Äã±Ø ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......