weblogicconn.java

java的一系列产品中包括jsme,jmse,j2ee,本文件提供j2ee实现的源代码.

import java.sql.*;
import java.util.*;
import java.lang.*;

/**
 * Use Weblogic default JDBC driver connection to MS SQL Server DBMS
 */
public class WeblogicConn{
  /** String identifier of this connection's type */
  public static void main(String[] args){
  	String sql_query="select * from t_employee";
  	String sql_insert="insert into t_employee values(1003,'zhanghz03',28,7000.00,'inset through jdbc')";
  	String sql_update="update t_employee set emp_name='zhanghz02' where emp_no='1002'";
  	String sql_delete="delete from t_employee where emp_name='zhanghz02'";
  	ResultSet rs=null;
  	
  	try{
      Driver myDriver=(java.sql.Driver)Class.forName("weblogic.jdbc.mssqlserver4.Driver").newInstance();
      Properties props=new Properties();
			props.put("user","sa");
			props.put("password","zhangjl");
			//cannot use this setence,or conn failed:
			//props.put("db","mysqlsvrdb");
			props.put("server","172.24.216.55");
			props.put("port","1079");
			System.out.println("start conn db");
      Connection con=myDriver.connect("jdbc:weblogic:mssqlserver4",props);
      
      System.out.println("conn succ\n");
      Statement stmt=con.createStatement();
      String st=sql_query.trim().substring(0,sql_query.indexOf(""));      
      stmt.executeUpdate(sql_insert);
      con.commit();
      System.out.println("insert into t_employee succ");
      
      stmt.execute(sql_update);
      con.commit();
      System.out.println("update t_employee succ");
      
      stmt.executeUpdate(sql_delete);
      con.commit();
      System.out.println("delete t_employee succ");
      
      rs=stmt.executeQuery(sql_query);
      System.out.println("select from t_employee:");
      while(rs.next()){
				for(int j=1; j<=rs.getMetaData().getColumnCount(); j++){
					System.out.print(rs.getObject(j)+"\t");
				}
				System.out.println();
			}
			
      con.close();
      System.out.println("Bye-Bye");
    }catch(Exception e){
     	System.out.println("conn failed"); 
    }    
  }//end main()
}