import java.sql.*;
import java.awt.event.*;
import java.applet.*;
import javax.swing.*; class dbConnection
{ public static Connection getConnection()
{
Connection con;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Xiaoyuanka");
return con;
}catch(ClassNotFoundException e)
{ JOptionPane.showMessageDialog(null,"无法找到!");} return null; }
}class User
{
public String id;
public String password;
public boolean CheckUser(String ID,String pw)
{
Statement stmt;
Connection conn;
try
{
conn=DBConnection.getConnection();
stmt=conn.createStatement();
ResultSet rs=stmt.execute("select * from Student");
if(rs.next())
{
id=rs.getString("id");
password=rs.getString("password");
stmt.close();
conn.close();
}
}catch(SQLException e){System.out.println(e.getMessage());}
if(ID.equals(id)&&pw.equals(password))
return true;
else
return false;
}
}public class Text1 extends Applet implements ActionListener
{
Label n1,n2;
TextField txt1,txt2;
Button btn;
User user;
public void init()
{
user=new User();
n1=new Label("姓名:");
n2=new Label("密码:");
txt1=new TextField(8);
txt2=new TextField(8);
add(n1);add(txt1);
add(n2);add(txt2);
add(btn);
btn.addActiontListener(this);
}
public void actionPerformed(ActionEvent e)
{
if(user.CheckUser(txt1.getText(),txt2.getText()))
JOptionPane.showMessageDialog(null,"yes");
else
JOptionPane.showMessageDialog(null,"NO");
}
}数据库中只有一张表,名字为Student 属性有 id(主健),name,address,grade,password,这些都是字符串类型,还有属性 money 货贝型的(数据库用的是ACCESS)
请大家帮我改下,谢谢了~~
import java.awt.event.*;
import java.applet.*;
import javax.swing.*; class dbConnection
{ public static Connection getConnection()
{
Connection con;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Xiaoyuanka");
return con;
}catch(ClassNotFoundException e)
{ JOptionPane.showMessageDialog(null,"无法找到!");} return null; }
}class User
{
public String id;
public String password;
public boolean CheckUser(String ID,String pw)
{
Statement stmt;
Connection conn;
try
{
conn=DBConnection.getConnection();
stmt=conn.createStatement();
ResultSet rs=stmt.execute("select * from Student");
if(rs.next())
{
id=rs.getString("id");
password=rs.getString("password");
stmt.close();
conn.close();
}
}catch(SQLException e){System.out.println(e.getMessage());}
if(ID.equals(id)&&pw.equals(password))
return true;
else
return false;
}
}public class Text1 extends Applet implements ActionListener
{
Label n1,n2;
TextField txt1,txt2;
Button btn;
User user;
public void init()
{
user=new User();
n1=new Label("姓名:");
n2=new Label("密码:");
txt1=new TextField(8);
txt2=new TextField(8);
add(n1);add(txt1);
add(n2);add(txt2);
add(btn);
btn.addActiontListener(this);
}
public void actionPerformed(ActionEvent e)
{
if(user.CheckUser(txt1.getText(),txt2.getText()))
JOptionPane.showMessageDialog(null,"yes");
else
JOptionPane.showMessageDialog(null,"NO");
}
}数据库中只有一张表,名字为Student 属性有 id(主健),name,address,grade,password,这些都是字符串类型,还有属性 money 货贝型的(数据库用的是ACCESS)
请大家帮我改下,谢谢了~~
解决方案 »
- java 客户端如何尽快知道服务端关闭服务?
- repaint()函数的问题
- 我们要做一个webservice 怎么加验证呢?
- 各位大哥 我以前是做SAP维护的 现在做程序员 该怎么办?
- 求:如何计算出一个字符串中的中文,英文,数字,其它符号的个数等
- 十万火急,大家帮忙看看错在哪里了!!!!
- servlet怎样获得本主机的IP?
- 我下载了jbuilder7,但是有30天的使用限制,真是不爽,哪位仁兄有注册码?50分相谢!
- 请教:用java重写c时的问题
- 我引入了一个pinyin4j-2.5.0.jar包,为什么有的类能引用,有的不能?!都存在!
- telnet一个机器的端口能通,但是往连到同机器,同端口的socket写入流时候就报错:software caused connection abort: socket write error
- 很简单的一小段javascript,立马揭帖
这个方法你永远返回的是null啊