jbuilder 2005 + tomcat 5.0
0、数据源的配置http://localhost:8080/admin声称数据源好像不起什么作用
运行时产生
D:\Documents and Settings\zpt\jbproject\untitled3\Tomcat\conf\server8080.xml文件
手工编辑其，去掉第二行的注释，并加入使其为：
<?xml version="1.0" encoding="UTF-8"?><Server debug="0" port="8081" shutdown="SHUTDOWN"><Service name="Catalina"> <Connector acceptCount="10" connectionTimeout="60000" debug="0" maxThreads="75" minSpareThreads="5" port="8080"/> <Engine debug="0" defaultHost="localhost" name="Catalina"> <Host appBase="D:\Documents and Settings\zpt\jbproject\untitled3\Tomcat\webapps" autoDeploy="false" debug="0" deployXML="false" name="localhost" unpackWARs="false"> <Context workDir="D:\Documents and Settings\zpt\jbproject\untitled3\Tomcat\work\WebModule1" path="/WebModule1" displayName="WebModule1" docBase="D:/Documents and Settings/zpt/jbproject/untitled3/WebModule1" reloadable="true"> <Resource type="javax.sql.DataSource" name="jdbc/oracle"/> <ResourceParams name="jdbc/oracle"> <parameter> <name>maxWait</name> <value>5000</value> </parameter> <parameter> <name>maxActive</name> <value>4</value> </parameter> <parameter> <name>password</name> <value>pmiswh</value> </parameter> <parameter> <name>url</name> <value>jdbc:oracle:thin:@10.161.160.10:1521:lydyj</value> </parameter> <parameter> <name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value> </parameter> <parameter> <name>maxIdle</name> <value>2</value> </parameter> <parameter> <name>username</name> <value>pmis</value> </parameter> </ResourceParams> </Context> </Host> </Engine></Service></Server>
1、Hibernate
a、拷贝ojdbc14.jar、jcconn2d.jar到tomcat 5.0\common\lib目录下，
并添加到jbuilder的JDKS的Class引用中
b、拷贝
cglib-full-2.0.1.jar
commons-collections-2.1.jar
commons-lang-1.0.1.jar
commons-logging-1.0.3.jar
dom4j-1.4.jar
ehcache-0.7.jar
hibern8ide.jar
hibernate2.jar
hibernate-tools.jar
jdom.jar
jta.jar
odmg-3.0.jar
oscache-2.0.jar
到tomcat 5.0\common\lib目录下，
并添加到jbuilder的Servlet的Class引用中
package p;import net.sf.hibernate.*;import net.sf.hibernate.cfg.*;public class HibernateUtil {private static final SessionFactory sessionFactory;static { try { sessionFactory = new Configuration();.configure(new HibernateUtil();.getClass();.getResource("/hibernate.cfg.xml"););.buildSessionFactory();; } catch (HibernateException ex); { throw new RuntimeException("Exception building SessionFactory: " + ex.getMessage();, ex);; }}public static final ThreadLocal session = new ThreadLocal();;public static Session currentSession(); throws HibernateException { Session s = (Session); session.get();; // Open a new Session, if this Thread has none yet //if (s == null); { s = sessionFactory.openSession();; session.set(s);; } return s;}public static void closeSession(); throws HibernateException { Session s = (Session); session.get();; session.set(null);; if (s != null); { s.close();; }}}package web;import p.DB;import java.sql.ResultSet;import javax.naming.Context;import javax.naming.InitialContext;import javax.sql.DataSource;import java.sql.Connection;import java.sql.Statement;import java.sql.DriverManager;import net.sf.hibernate.Session;import p.HibernateUtil;import net.sf.hibernate.Query;import java.util.List;import hibernates.Cat;import net.sf.hibernate.LockMode;import net.sf.hibernate.Transaction;import oracle.sql.CLOB;import java.io.Writer;import net.sf.hibernate.Hibernate;public class test {private String str;public String getStr(); { return str;}public void setStr(String str); { this.str = str;}public test(); throws Exception { try { jbInit();; } catch (Exception ex); { ex.printStackTrace();; }}public void o1(); throws Exception { Class.forName("oracle.jdbc.driver.OracleDriver");.getInterfaces();; String url = "jdbc:oracle:thin:@10.161.160.10:1521:lydyj"; Connection conn = DriverManager.getConnection(url, "pmis", "pmiswh");; Statement stmt = conn.createStatement();; ResultSet rs = stmt.executeQuery("select name from cat");; str = ""; while (rs.next();); { str += rs.getString("name");; } rs.close();; stmt.close();; conn.close();;}public void o2(); throws Exception { Context iniContext = new InitialContext();; Context envContext = (Context); iniContext.lookup("java:comp/env");; DataSource ds = (DataSource); envContext.lookup("jdbc/pmis/oracle");; Connection conn = ds.getConnection();; Statement stmt = conn.createStatement();; ResultSet rs = stmt.executeQuery("select name from Cat");; str = ""; while (rs.next();); { str += rs.getString("name");; } rs.close();; stmt.close();; conn.close();;}public void o3(); throws Exception{ Session sess=HibernateUtil.currentSession();; Query query=sess.createQuery("from Cat");; List list=query.list();; str=""; for(int i=0; i<list.size();; i++);{ str+=((Cat);list.get(i););.getName();; } HibernateUtil.closeSession();;}public void o4(); throws Exception{ Session sess = HibernateUtil.currentSession();; Cat obj=(Cat);sess.get(Cat.class, new Long(2148););; obj.setMesString(obj.getMes();.getSubString(1, (int);obj.getMes();.length();););; obj.setMesString("成郁落叶沉郁落叶沉鱼落雁沉鱼落雁");; Transaction tx = sess.beginTransaction();; obj.setMes(Hibernate.createClob(" "););; sess.save(obj);; sess.flush();; sess.refresh(obj, LockMode.UPGRADE);; CLOB clob = (CLOB); obj.getMes();; Writer pw = clob.getCharacterOutputStream();; pw.write(obj.getMesString(););; pw.flush();; pw.close();; sess.flush();; tx.commit();; HibernateUtil.closeSession();;}public void s1(); throws Exception { Class.forName("com.sybase.jdbc2.jdbc.SybDriver");.getInterfaces();; String url = "jdbc:sybase:Tds:10.161.160.10:4100"; Connection conn = DriverManager.getConnection(url, "pmiswh", "pmiswh");; conn.setCatalog("rlzy2");; Statement stmt = conn.createStatement();; ResultSet rs = stmt.executeQuery("select xm from t_zgxx");; str = ""; while (rs.next();); { str += this.native2Unicode(rs.getString("xm"););; } rs.close();; stmt.close();; conn.close();;}public void s2(); throws Exception { Context iniContext = new InitialContext();; Context envContext = (Context); iniContext.lookup("java:comp/env");; DataSource ds = (DataSource); envContext.lookup("jdbc/pmis/sybase");; Connection conn = ds.getConnection();; conn.setCatalog("rlzy2");; Statement stmt = conn.createStatement();; ResultSet rs = stmt.executeQuery("select xm from t_zgxx");; str = ""; while (rs.next();); { str += this.native2Unicode(rs.getString("xm"););; } rs.close();; stmt.close();; conn.close();;}private void jbInit(); throws Exception {}public String native2Unicode(String s); { if (s == null); { return null; } byte[] buffer = new byte; for (int i = 0; i < s.length();; i++); { buffer = (byte); s.charAt(i);; } return new String(buffer);;}}
其它参见idea 4.5 使用 tomcat 4
页:
[1]