database.java

软件设计大赛的作品,学生登陆系统.包含数据库

/*
*功能：数据库的连接
 *数据成员：conn  类型：Connection
          stmt  类型:Statement
          rs    类型:ResultSet
 *方法：void connect();
 */
package wsbm.util;
import java.sql.*;

public class DataBase
{
    public Connection conn;
    public Statement stmt;
    public ResultSet rs=null;
    public String sqlStr="";
    public DataBase()
    {
        this.connect();
    }
    public void connect()
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            System.out.println( "类实例化成功!" );
        }
        catch(ClassNotFoundException e)
        {
            System.out.print(" "+e);
        }
        try
        {
            conn=DriverManager.getConnection("jdbc:odbc:wsbmy","sa","sony");
             System.out.println( "创建连接对像成功!" );
            stmt=conn.createStatement();
            System.out.println( "创建Statement成功!" );
        }
        catch(SQLException er)
        {
            System.out.print("connect db error: " + er);
        }
    }

}