工厂模式应用以及Ｏracle数据库连接

最新推荐文章于 2024-09-17 13:42:29 发布

hongtashan11

最新推荐文章于 2024-09-17 13:42:29 发布

阅读量676

点赞数

文章标签：数据库 string exception user sql import

工厂：

package message;

import javax.xml.*;
import org.w3c.*;
import org.w3c.dom.*;
import javax.xml.parsers.*;
public class factory {
    private factory() {
    }
    private static factory demo=null;
    public static factory newInstance()
    {
        if(demo==null)
        {
            demo=new factory();

}

return demo;
 }
 public Object createInstance(String type)
 {
 String src=System.getProperty("user.dir")+"//WebM//xml//comment.xml";
 try
 {
 javax.xml.parsers.DocumentBuilderFactory dbf=DocumentBuilderFactory.newInstance();
 DocumentBuilder db=dbf.newDocumentBuilder();
 Document doc=db.parse(src);
 Element root=doc.getDocumentElement();
 NodeList list=root.getElementsByTagName("compoment");
 for(int i=0;i<list.getLength();i++)
 {
 Element comElement=(Element)list.item(i);
 String id=comElement.getAttribute("id");
 String ee=comElement.getAttribute("type");
 if(id.equals(type))
 {
 Object demo=Class.forName(type).newInstance();
 }
 break;
 }
 } catch (Exception xxx)
 {
 return null;
 }
 return demo;
 }
}

接口:

package message;

/**
* Title: 
*
* Description: 
*
* Copyright: Copyright (c) 2005
*
* Company: 
*
* @author not attributable
* @version 1.0
*/
public interface Iuser{

    public void add(User NewUser);
    public void del(String id);
    public void update(User UpdateUser);
    public User getUser(String id);
    public boolean login (User checkUser);

}

描述类：

package message;

/**
* Title: 
*
* Description: 
*
* Copyright: Copyright (c) 2005
*
* Company: 
*
* @author not attributable
* @version 1.0
*/
public class User {
 private String userid;
 private String name;
 private String pwd;
 private String lovname;
 public User() {
 }

    public void setUserid(String userid) {
        this.userid = userid;
    }

    public void setName(String name) {
        this.name = name;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd;
    }

    public void setLovname(String lovname) {
        this.lovname = lovname;
    }

    public String getUserid() {
        return userid;
    }

    public String getName() {
        return name;
    }

    public String getPwd() {
        return pwd;
    }

    public String getLovname() {
        return lovname;
    }

}

实现了接口的类：

package message;
import message.*;
/**
* Title: 
*
* Description: 
*
* Copyright: Copyright (c) 2005
*
* Company: 
*
* @author not attributable
* @version 1.0
*/
import java.sql.*;
public class UserManager implements Iuser{
public UserManager() {
}

    public void add(User NewUser)
    {
        String userid=NewUser.getUserid();
        String name=NewUser.getName();
        String pwd=NewUser.getPwd();
        String lovname=NewUser.getLovname();
        String sql=String.format("insert into UserMassage values('%s','%s','%s','%s')",userid,name,pwd,lovname);
        message.OracleConn.noRsultBack(sql);
    }

    public void del(String id)
    {
        String sql=String.format("delete from UserMassage where Userid='%s'",id);
        message.OracleConn.noRsultBack(sql);
    }

    public void update(User UpdateUser)
    {
        String userid = UpdateUser.getUserid();
        String name = UpdateUser.getName();
        String pwd = UpdateUser.getPwd();
        String lovname = UpdateUser.getLovname();
        String sql=String.format("update UserMassage set name='%s',pwd='%s',Lovename='%s' where userid='%s'",name,pwd,lovname,userid);
        message.OracleConn.noRsultBack(sql);

}

    public User getUser(String id)
    {
        String sql=String.format("select * from UserMassage where userid='%s'",id);
        java.sql.ResultSet rs=message.OracleConn.haveRsultBack(sql);
       try{
        User u=new User();
        u.setUserid(rs.getString(1));
        u.setName(rs.getString(2));
        u.setPwd(rs.getString(3));
        u.setLovname(rs.getString(4));
        return u;
       }catch(Exception xx)
       {
       return null;
       }

}

public boolean login(User checkUser)
{

return true;
}

}

连接数据库的类：

package message;
import java.sql.*;
public class OracleConn {
    public OracleConn() {
    }
    public static java.sql.ResultSet haveRsultBack(String sql)
    {
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            java.sql.Connection conn=java.sql.DriverManager.getConnection("jdbc:oracle:thin:@pub452:1521:Aptech","scott","tiger");
            java.sql.PreparedStatement pr=conn.prepareStatement(sql);
            java.sql.ResultSet rs=pr.executeQuery();
            return rs;
        }
        catch(Exception xx)
        {
            System.out.print(xx.getMessage());
            return null;
        }
    }
    public static void noRsultBack(String sql)
   {
       try
       {
           Class.forName("oracle.jdbc.driver.OracleDriver");
           java.sql.Connection conn=java.sql.DriverManager.getConnection("jdbc:oracle:thin:@pub452:1521:aptech","scott","tiger");
           java.sql.PreparedStatement pr=conn.prepareStatement(sql);
           pr.executeUpdate();
       }
       catch(Exception xx)
       {