dataconnect.java

图书管理设计文档

/*
 * DataConnect.java
 * 说明：数据连接测试类
 * 编写人：倪少春
 * Created on 2004年12月29日, 上午10:53
 */
public class DataConnect {
    private java.sql.Connection cn=null;
    private String URL=null;
    private String user=null;
    private String password=null;
    private String database=null;
    public DataConnect() 
        throws java.sql.SQLException,
            java.lang.InstantiationException,
            java.lang.ClassNotFoundException,
            java.lang.IllegalAccessException
        {
        /*mysql
        java.lang.Class.forName("org.gjt.mm.mysql.Driver").newInstance();
        URL="jdbc:mysql://localhost:3306/"+
            database+
            "?useUnicode=true&characterEncoding=gb2312";
        user="root";password="771023";
         */
        //sql server
        java.lang.Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
        database="BookManager";
        URL="jdbc:odbc:BookManager";
        user="sa";password="771023";
        cn=java.sql.DriverManager.getConnection(
                URL,user,password);
        java.sql.Statement stmt=cn.createStatement();
        }
    public java.sql.Statement getStatement()
        throws java.sql.SQLException
        {
        if(cn!=null)
            return cn.createStatement();
        else
            return null;
        }
    public java.sql.PreparedStatement getPreparedStatement(String strSql)
        throws java.sql.SQLException
        {
        if(cn!=null)
            return cn.prepareStatement(strSql);
        else
            return null;
        }
    public void close()
        {
        cn=null;
        URL=null;
        user=null;
        password=null;
        database=null;
        }
    
    public static void main(String[] args) throws Exception
        {
        DataConnect dc=new DataConnect();
        java.sql.Statement stmt=dc.getStatement();
        java.sql.ResultSet rs=stmt.executeQuery
            //("select * from Book");
            ("select id,name,qx,password from Manager");
        while(rs.next())
            {
            System.out.println("管理员ID:"+rs.getInt("id")+
                "  管理员名称："+rs.getString("name")+
                "  用户权限："+(rs.getInt("qx")==0?"超级":"前台")+
                "  用户密码："+(rs.getString("password")));
            }
        rs.close();
        stmt.close();
        dc.close();
        }
}//~