4.2连接数据库跳转
主要代码：
<%
Stringname=request.getParameter（"username1"）;
Stringpass=request.getParameter（"password1"）;
//1.加载驱动
Class.forName（"com.mysql.jdbc.Driver"）;
//2.获取连接
Connectionconn=DriverManager.getConnection（"jdbc:
mysql:
//127.0.0.1:
3306/school","root","123456"）;
//3.获取预处理命令
//conn.prepareStatement（"insertintoebmanager（username）value（?
）"）;
PreparedStatementps=conn.prepareStatement（"select*frominformationwhereusername=?
"）;
ps.setString（1,name）;
//4.执行查询
ResultSetrs=ps.executeQuery（）;
//5.处理结果集
if（rs.next（））
{
//用户名正确
Stringpass1=rs.getString（"password"）;
if（pass1.equals（pass））
{
//查询成功
session.setAttribute（"user",name）;
response.sendRedirect（"admin.jsp"）;
}
else{
out.println（""）;
}
}
else{
out.println（""）;
}
%>
4.3主界面
主要代码：
4.4添加信息界面
主要代码：
BOOLCGEREN:
:
OnInitDialog（）
{
CDialog:
:
OnInitDialog（）;
UpdateData（TRUE）;
m_USERName.Format（"%s",name）;
UpdateData（FALSE）;
UpdateData（TRUE）;
CStringsqlStr;
sqlStr.Format（"SELECT*FROMschoolfellowwhereusername='%s'",name）;
mygerenset=newCGERENSET（&（（CSchoolfellowApp*）AfxGetApp（））->m_DB）;
if（!
mygerenset->Open（AFX_DB_USE_DEFAULT_TYPE,sqlStr））
{
AfxMessageBox（"schoolfellow表打开失败!
"）;}
if（mygerenset->GetRecordCount（）==0）
{
//AfxMessageBox（"无记录！
"）;
}
m_sname=mygerenset->m_sname;
m_sex=mygerenset->m_sex;
m_faculty=mygerenset->m_faculty;
m_major=mygerenset->m_major;
m_classname=mygerenset->m_classname;
m_birthday=mygerenset->m_birthday;
m_graduate=mygerenset->m_graduate;
m_phone=mygerenset->m_phone;
m_mail=mygerenset->m_mail;
m_QQ=mygerenset->m_QQ;
m_myaddress=mygerenset->m_myaddress;
m_city=mygerenset->m_city;
m_jobfield=mygerenset->m_jobfield;
m_workunit=mygerenset->m_workunit;
m_job=mygerenset->m_job;
m_teacher2=mygerenset->m_teacher;
m_tphone2=mygerenset->m_tphone;
//m_Photo=mygerenset->m_tupian;
//m_Photo=mygerenset->m_tupian.m_hData;
//m_Photo=mygerenset->m_tupian.m_dwDataLength;
if（mygerenset->IsOpen（））
{
mygerenset->Close（）;
deletemygerenset;
}
UpdateData（FALSE）;
//TODO:
Addextrainitializationhere
returnTRUE;//returnTRUEunlessyousetthefocustoacontrol
//EXCEPTION:
OCXPropertyPagesshouldreturnFALSE
}
voidCGEREN:
:
OnXiugai（）
{
//TODO:
Addyourcontrolnotificationhandlercodehere
UpdateData（TRUE）;
CStringsql;
sql.Format（"SELECT*FROMschoolfellowwhereusername='%s'",name）;
mygerenset=newCGERENSET（&（（CSchoolfellowApp*）AfxGetApp（））->m_DB）;
if（!
mygerenset->Open（AFX_DB_USE_DEFAULT_TYPE,sql））
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1
升级会员 