81,122
社区成员
发帖
与我相关
我的任务
分享新手的程序，大家都来看看指点呀！＾＿＾
以下是JAVABEAN，CLASS 文件！
==========================
package com.ydh;
import java.sql.*;
import javax.swing.*;
import java.io.*;
public class userinfo {
private String username;
private String userpass;
private boolean logined = false;
private String dbdriver;
private String dburl;
private String dbusername;
private String dbuserpass;
private boolean loginded1 = false;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getUserpass() {
return userpass;
}
public void setUserpass(String userpass) {
this.userpass = userpass;
}
public boolean isLoginded1() {
return loginded1;
}
public void setLoginded1(boolean loginded1) {
this.loginded1 = loginded1;
}
public String getDbdriver() {
return dbdriver;
}
public void setDbdriver(String dbdriver) {
this.dbdriver = dbdriver;
}
public String getDburl() {
return dburl;
}
public void setDburl(String dburl) {
this.dburl = dburl;
}
public String getDbusername() {
return dbusername;
}
public void setDbusername(String dbusername) {
if (dbusername != null) {
this.dbusername = dbusername;
}
else {
this.dbusername = "";
}
}
public String getDbuserpass() {
return dbuserpass;
}
public void setDbuserpass(String dbuserpass) {
if (dbuserpass != null) {
this.dbuserpass = dbuserpass;
}
else {
this.dbuserpass = "";
}
}
/**
* 执行登陆操作
* @param username
* @param userpass
* @return
*/
public void login1(String username, String userpass) {
java.sql.Connection sqlCon; //数据库连接对象
java.sql.Statement sqlStmt; //SQL语句对象
java.sql.ResultSet sqlRst; //结果集对象
java.lang.String strCon; //数据库连接字符串
java.lang.String strSQL = ""; //SQL语句
//======================================
try {
Class.forName(this.getDbdriver()); //设置数据库连接字符串
sqlCon = java.sql.DriverManager.getConnection(this.getDburl(),
this.getDbusername(),
this.getDbuserpass());
sqlStmt = sqlCon.createStatement();
strSQL = "select * from userinfo where username=\'" +
username + "\' and userpass=\'" +
userpass + "\' and level=999";
System.out.println(strSQL);
sqlRst = sqlStmt.executeQuery(strSQL);
if (sqlRst != null) {
if (sqlRst.next() && sqlRst.getString("level").length() > 0) {
//如果用户信息存在
this.setLoginded1(true);
}
else {
//用户信息不存在
this.setLoginded1(false);
}
}
else {
//用户信息不存在
this.setLoginded1(false);
}
sqlRst.close();
sqlCon.close();
}
catch (Exception ex) {
ex.printStackTrace();
}
}
=============================================
以下为调用它的JSP页
<%@ page contentType="text/html; charset=GBK" %>
<html>
<head>
<title>check</title>
</head>
<jsp:useBean id="userinfo" scope="session" class="com.ydh.userinfo" />
<body bgcolor="#ffffff">
<h1>JBuilder Generated JSP</h1>
<%
//下面四行代码是从web.xml里读出数据库配置信息
String dbdriver=pageContext.getServletContext().getInitParameter("dbdriver");
String dbusername=pageContext.getServletContext().getInitParameter("dbusername");
String dbuserpass=pageContext.getServletContext().getInitParameter("dbuserpass");
String dburl=pageContext.getServletContext().getInitParameter("dburl");
out.println("变量值为："+"dbdriver="+dbdriver+"dbusername"+dbusername+dbuserpass+"dburl"+dburl);
//下面四行代码是把数据库配置信息写到userinfo里.
userinfo.setDbdriver(dbdriver);
userinfo.setDbusername(dbusername);
userinfo.setDbuserpass(dbuserpass);
userinfo.setDburl(dburl);
pageContext.getServletContext().log("开始建立连接");
userinfo.login1(request.getParameter("username"),request.getParameter("userpass"));
if(userinfo.isLogined1()==true){
response.sendRedirect("StuView.jsp");}
else{
response.sendRedirect("login.jsp");}
%>
</body>
</html>
出现的问题是数据库中有这个用户和密码，就是进不去，是isLogined1()的问题吗，如果能告诉我怎么改，最好不过了，谢谢！
急，后天交的课程设计，大家帮帮我吧！
==========================
package com.ydh;
import java.sql.*;
import javax.swing.*;
import java.io.*;
public class userinfo {
private String username;
private String userpass;
private boolean logined = false;
private String dbdriver;
private String dburl;
private String dbusername;
private String dbuserpass;
private boolean loginded1 = false;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getUserpass() {
return userpass;
}
public void setUserpass(String userpass) {
this.userpass = userpass;
}
public boolean isLoginded1() {
return loginded1;
}
public void setLoginded1(boolean loginded1) {
this.loginded1 = loginded1;
}
public String getDbdriver() {
return dbdriver;
}
public void setDbdriver(String dbdriver) {
this.dbdriver = dbdriver;
}
public String getDburl() {
return dburl;
}
public void setDburl(String dburl) {
this.dburl = dburl;
}
public String getDbusername() {
return dbusername;
}
public void setDbusername(String dbusername) {
if (dbusername != null) {
this.dbusername = dbusername;
}
else {
this.dbusername = "";
}
}
public String getDbuserpass() {
return dbuserpass;
}
public void setDbuserpass(String dbuserpass) {
if (dbuserpass != null) {
this.dbuserpass = dbuserpass;
}
else {
this.dbuserpass = "";
}
}
/**
* 执行登陆操作
* @param username
* @param userpass
* @return
*/
public void login1(String username, String userpass) {
java.sql.Connection sqlCon; //数据库连接对象
java.sql.Statement sqlStmt; //SQL语句对象
java.sql.ResultSet sqlRst; //结果集对象
java.lang.String strCon; //数据库连接字符串
java.lang.String strSQL = ""; //SQL语句
//======================================
try {
Class.forName(this.getDbdriver()); //设置数据库连接字符串
sqlCon = java.sql.DriverManager.getConnection(this.getDburl(),
this.getDbusername(),
this.getDbuserpass());
sqlStmt = sqlCon.createStatement();
strSQL = "select * from userinfo where username=\'" +
username + "\' and userpass=\'" +
userpass + "\' and level=999";
System.out.println(strSQL);
sqlRst = sqlStmt.executeQuery(strSQL);
if (sqlRst != null) {
if (sqlRst.next() && sqlRst.getString("level").length() > 0) {
//如果用户信息存在
this.setLoginded1(true);
}
else {
//用户信息不存在
this.setLoginded1(false);
}
}
else {
//用户信息不存在
this.setLoginded1(false);
}
sqlRst.close();
sqlCon.close();
}
catch (Exception ex) {
ex.printStackTrace();
}
}
=============================================
以下为调用它的JSP页
<%@ page contentType="text/html; charset=GBK" %>
<html>
<head>
<title>check</title>
</head>
<jsp:useBean id="userinfo" scope="session" class="com.ydh.userinfo" />
<body bgcolor="#ffffff">
<h1>JBuilder Generated JSP</h1>
<%
//下面四行代码是从web.xml里读出数据库配置信息
String dbdriver=pageContext.getServletContext().getInitParameter("dbdriver");
String dbusername=pageContext.getServletContext().getInitParameter("dbusername");
String dbuserpass=pageContext.getServletContext().getInitParameter("dbuserpass");
String dburl=pageContext.getServletContext().getInitParameter("dburl");
out.println("变量值为："+"dbdriver="+dbdriver+"dbusername"+dbusername+dbuserpass+"dburl"+dburl);
//下面四行代码是把数据库配置信息写到userinfo里.
userinfo.setDbdriver(dbdriver);
userinfo.setDbusername(dbusername);
userinfo.setDbuserpass(dbuserpass);
userinfo.setDburl(dburl);
pageContext.getServletContext().log("开始建立连接");
userinfo.login1(request.getParameter("username"),request.getParameter("userpass"));
if(userinfo.isLogined1()==true){
response.sendRedirect("StuView.jsp");}
else{
response.sendRedirect("login.jsp");}
%>
</body>
</html>
出现的问题是数据库中有这个用户和密码，就是进不去，是isLogined1()的问题吗，如果能告诉我怎么改，最好不过了，谢谢！
急，后天交的课程设计，大家帮帮我吧！
...全文
请发表友善的回复…
发表回复
ydh1981 2003-12-19
- 打赏
- 举报
access数据库，成功了。
llhdf 2003-12-19
- 打赏
- 举报
用System.out.println()，一步一步看一看，哪有问题，不就知道了。
eureka0891 2003-12-15
- 打赏
- 举报
你用的是什么数据库，
数据库连成功过没？
我这儿连mysql时不能有用户名和密码.
你先试着连成功一个试试
数据库连成功过没？
我这儿连mysql时不能有用户名和密码.
你先试着连成功一个试试
ydh1981 2003-12-15
- 打赏
- 举报
ooop
ydh1981 2003-12-15
- 打赏
- 举报
up
IT源哥 2003-12-12
- 打赏
- 举报
是不是你类的位置放错了？
nql10 2003-12-12
- 打赏
- 举报
ding
ydh1981 2003-12-12
- 打赏
- 举报
UP
ydh1981 2003-12-12
- 打赏
- 举报
还有，这个程序在
WWW.SEE-SEA.COM/OTHER/JAVA/JAVATEST.RAR可下载，谢谢！感激不尽！
http://expert.csdn.net/Expert/topic/2544/2544120.xml?temp=.4745905
谁在这个贴子上留下言，分给他，因为这个帖子没人回，晕！
谢谢！感激不尽！
WWW.SEE-SEA.COM/OTHER/JAVA/JAVATEST.RAR可下载，谢谢！感激不尽！
http://expert.csdn.net/Expert/topic/2544/2544120.xml?temp=.4745905
谁在这个贴子上留下言，分给他，因为这个帖子没人回，晕！
谢谢！感激不尽！
