📄 connpara.java

📁 五个java源程序
💻 JAVA
📖 第 1 页 / 共 2 页
字号:
12 下一页
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>New Page </title>
</head>

<body>

<p>import javax.servlet.*;<br>
import javax.servlet.http.*;<br>
//import javax.servlet.http.HttpServlet;<br>
import java.util.*;<br>
import java.io.*;<br>
import java.sql.*;<br>
import java.net.*;<br>
<br>
class ConnPara {<br>
<br>
String sHostName=&quot;zhoupeng&quot;;<br>
String sIp=&quot;100.0.0.120&quot;;<br>
String password=&quot;&quot;;<br>
String user=&quot;sa&quot;;<br>
String sDbName=&quot;GenerWeb&quot;;<br>
String sPort=&quot;5000&quot;;<br>
String sDriver=&quot;com.sybase.jdbc.SybDriver&quot;;<br>
String url=&quot;jdbc:sybase:Tds:&quot;+sIp+&quot;:&quot;+sPort+&quot;/&quot;+sDbName;<br>
<br>
/*<br>
String password=&quot;manger&quot;;<br>
String user=&quot;system&quot;;<br>
String sPort=&quot;1521&quot;;<br>
String sDbName=&quot;orcl&quot;;<br>
// String sDriver=&quot;oracle8i.jdbc.driver.OracleDriver&quot;;<br>
// String sDriver=&quot;oracle.jdbc.driver.OracleDriver&quot;;<br>
String sDriver=&quot;oracle.jdbc.driver.OracleDriver&quot;; // from xyz<br>
// String sDriver=&quot;oracle8i.orcale.jdbc.driver.OracleDriver&quot;;<br>
String 
url=&quot;jdbc:oracle:thin:@&quot;+sIp+&quot;:&quot;+sPort+&quot;:&quot;+sDbName+&quot;&quot;;<br>
*/<br>
public ConnPara(String sql){<br>
}<br>
}<br>
class CompanyInfo {<br>
String sCompanyName=&quot;浪潮集团山东通用软件有限公司&quot;;<br>
String sTele=&quot;0531 8955188&quot;;<br>
String sUrl=&quot;www.genersoft.com&quot;;<br>
String sManager=&quot;周朋&quot;;<br>
String sAddress=&quot;中国济南山大路224 号&quot;;<br>
String info=sCompanyName+&quot;\n电话&quot;+sTele+&quot; 联系人:&quot;+sManager+&quot; 
地址:&quot;+sAddress;<br>
}<br>
public class conn {<br>
//Initialize global variables<br>
public static int getSqlFieldsNum(String sql){<br>
int ii=0;<br>
try {<br>
String fields= sql.substring(7, sql.indexOf(&quot;from&quot;));<br>
String fieldName=null,tempStr;<br>
while (fields.trim().length()!=0 &amp;&amp; ii&lt;=50 ) {<br>
if (fields.indexOf(&quot;,&quot;)==-1) {<br>
fieldName=fields;<br>
fields=&quot;&quot;;<br>
}else {<br>
fieldName=fields.substring(0,fields.indexOf(&quot;,&quot;));<br>
fields=fields.substring(fields.indexOf(&quot;,&quot;)+1,fields.length());<br>
}<br>
ii=ii+1;<br>
}<br>
}catch (Exception ye) {<br>
}<br>
return ii; // 返回个数<br>
}<br>
public static Hashtable selectAllOrder(String sqlStr ) {<br>
sqlStr=sqlStr.trim();<br>
System.out.print(&quot;\n ********* selectAllOrder(String sqlStr) execue state 
*************\nsql=&quot;+sqlStr+&quot;\n&quot;);<br>
Hashtable ht=new Hashtable();<br>
java.sql.Connection con=null; // Create a conn<br>
java.sql.Statement stat;<br>
java.sql.ResultSet result;<br>
String url, user, password, sDriver;<br>
ConnPara para= new ConnPara(sqlStr);<br>
url=para.url;<br>
user=para.user;<br>
password=para.password;<br>
sDriver=para.sDriver;<br>
try {<br>
Class.forName(sDriver);<br>
con=java.sql.DriverManager.getConnection(url,user,password);<br>
stat=con.createStatement();<br>
result=stat.executeQuery(gener.base(doWithSqlStr(sqlStr)));<br>
if( !result.next() ){ // if no value , let it return null Hashtable<br>
System.out.print(&quot;\n************ resule is null successed selectAllOrder(String 
sqlStr) **********\n&quot;);<br>
con.close();<br>
return ht;<br>
}<br>
// 处理这个结果集 放入 ht 里。 //<br>
String fields1=sqlStr.substring(7, sqlStr.indexOf(&quot;from&quot;));<br>
String fields=null;<br>
String fieldName=null,tempStr;<br>
int ii=1,idii=0 ; String intStr;<br>
String addValues=null;<br>
do { // 让它循环 result<br>
fields=fields1;<br>
while (fields.trim().length()!=0 ) {<br>
if (fields.indexOf(&quot;,&quot;)==-1) {<br>
fieldName=fields;<br>
fields=&quot;&quot;;<br>
}else {<br>
fieldName=fields.substring(0,fields.indexOf(&quot;,&quot;));<br>
fields=fields.substring(fields.indexOf(&quot;,&quot;)+1,fields.length());<br>
}<br>
if (fieldName.indexOf(&quot;Int&quot;)!=-1 ) {<br>
fieldName=fieldName.substring(0, fieldName.indexOf(&quot;Int&quot;));<br>
intStr=&quot; &quot;+result.getInt(fieldName)+&quot; &quot;;<br>
} else { // 这是认为查询的是字符串<br>
intStr=gener.base(result.getString(fieldName.trim()));<br>
}<br>
intStr=intStr.trim();<br>
ht.put(&quot;&quot;+idii+&quot;&quot;, intStr); // add this obj .<br>
//System.out.print(&quot;\n('&quot;+idii+&quot;', '&quot;+intStr+&quot;') already 
load&quot;);<br>
fields=fields.trim();<br>
idii=idii+1;<br>
}<br>
} while(result.next());<br>
con.close();<br>
System.out.println(&quot;\n\n******* sql execue Succend *************\n&quot;);<br>
return ht;<br>
} catch (Exception ye) {<br>
System.out.print(&quot;\n 在执行sql时出现异常:\n&quot;+ye.toString()) ;<br>
System.out.println(&quot;\n\n******* sql execue Error *************\n&quot;);<br>
try {<br>
con.close();<br>
} catch (Exception ffye) {<br>
System.out.print(&quot;在关闭连接时出现错误。&quot;) ;<br>
}<br>
}<br>
return ht ;<br>
}<br>
/* 执行一个非查询sql ; */<br>
public static String execure(String sql) {<br>
String sqlstr=gener.N2U(sql);<br>
System.out.println(&quot;\n****** Execure the sql **********\nWill execure sql is 
:\n&quot;+sql);<br>
java.sql.Connection con=null;<br>
String url,password,user,sDriver;<br>
ConnPara para= new ConnPara(sql);<br>
url=para.url;<br>
user=para.user;<br>
password=para.password;<br>
sDriver=para.sDriver;<br>
<br>
System.out.println(&quot;url=&quot;+url);<br>
System.out.println(&quot;user=&quot;+user);<br>
System.out.println(&quot;passwrod=&quot;+password);<br>
System.out.println(&quot;sDirver=&quot;+sDriver);<br>
try {<br>
System.out.println(&quot;marker0&quot;);<br>
Class.forName(sDriver);<br>
System.out.println(&quot;marker1&quot;);<br>
// 
con=java.sql.DriverManager.getConnection(&quot;jdbc:oracle:thin:@100.0.0.120:1521:orcl&quot;,&quot;system&quot;,&quot;manager&quot;);<br>
con=DriverManager.getConnection(url,user,password);<br>
System.out.println(&quot;marker2&quot;);<br>
java.sql.Statement stat = con.createStatement();<br>
System.out.println(&quot;marker3&quot;);<br>
stat.executeUpdate(gener.N2U(sqlstr));<br>
System.out.println(&quot;marker4&quot;);<br>
con.close();<br>
System.out.println(&quot;\n****** the end Succeed **********\n&quot;);<br>
return &quot;1&quot;;<br>
}catch(Exception e) { // 这里是把捕获的Error 放到定义的 e 对象里。<br>
System.out.println( &quot;Error: &quot;+e.getMessage() );<br>
try {<br>
con.close();<br>
System.out.println( &quot;Error: &quot;+e.getMessage() );<br>
System.out.println(&quot;\n****** the end Error **********\n&quot;);<br>
return &quot;0&quot;;<br>
} catch ( Exception dd) {}<br>
System.out.println(&quot;\n****** the end Error **********\n&quot;);<br>
return &quot;0&quot;;<br>
}<br>
}<br>
public static Hashtable selectOne(String sqlStr ) {<br>
sqlStr=sqlStr.trim();<br>
System.out.print(&quot;\n ********* selectOne(String sqlStr) execue state 
*************\nsql=&quot;+sqlStr+&quot;\n&quot;);<br>
Hashtable ht=new Hashtable();<br>
java.sql.Connection con=null; // Create a conn<br>
java.sql.Statement stat;<br>
java.sql.ResultSet result;<br>
String url, user, password, sDriver;<br>
ConnPara para= new ConnPara(sqlStr);<br>
url=para.url;<br>
user=para.user;<br>
password=para.password;<br>
sDriver=para.sDriver;<br>
try {<br>
Class.forName(sDriver);<br>
con=java.sql.DriverManager.getConnection(url,user,password);<br>
stat=con.createStatement();<br>
result=stat.executeQuery(gener.N2U((doWithSqlStr(sqlStr))));<br>
//System.out.println(&quot;处理后的sql是=&quot;+doWithSqlStr(sqlStr));<br>
if( !result.next() ){ // if no value , let it return null ht<br>
System.out.print(&quot;******** \n resule is null **********&quot;);<br>
con.close();<br>
return ht;<br>
}<br>
// 处理这个结果集 放入 ht 里。 //<br>
String fields= sqlStr.substring(7, sqlStr.indexOf(&quot;from&quot;));<br>
String fieldName=null,tempStr;<br>
int ii=1; String sApp;<br>
while (fields.trim().length()!=0 &amp;&amp; ii&lt;=50 ) {<br>
if (fields.indexOf(&quot;,&quot;)==-1) {<br>
fieldName=fields;<br>
fields=&quot;&quot;;<br>
}else {<br>
fieldName=fields.substring(0,fields.indexOf(&quot;,&quot;));<br>
fields=fields.substring(fields.indexOf(&quot;,&quot;)+1,fields.length());<br>
}<br>
if (fieldName.indexOf(&quot;Int&quot;)!=-1 ) {<br>
fieldName=fieldName.substring(0, fieldName.indexOf(&quot;Int&quot;));<br>
sApp=&quot;&quot;+result.getInt(fieldName);<br>
} else if (fieldName.indexOf(&quot;Float&quot;)!=-1 ) {<br>
fieldName=fieldName.substring(0, fieldName.indexOf(&quot;Float&quot;));<br>
sApp=&quot;&quot;+result.getFloat(fieldName);<br>
} else if (fieldName.indexOf(&quot;Double&quot;)!=-1 ) {<br>
fieldName=fieldName.substring(0, fieldName.indexOf(&quot;Double&quot;));<br>
sApp=&quot;&quot;+result.getDouble(fieldName);<br>
} else if (fieldName.indexOf(&quot;=&quot;)!=-1 ){ // 
这是认为查询的是字符串并且内有 '='<br>
fieldName=fieldName.substring(0, fieldName.indexOf(&quot;=&quot;)).trim();<br>
sApp=gener.base(result.getString(fieldName));<br>
} else {<br>
sApp=gener.base(result.getString(fieldName));<br>
}<br>
sApp=&quot; &quot;+sApp;<br>
sApp=sApp.trim();<br>
if (sApp==null || sApp.equals(&quot;&quot;) ) {sApp=&quot; &quot;; }<br>
ht.put(fieldName.trim(), sApp); // 把取出的字串加到ht里<br>
fields=fields.trim();<br>
}<br>
con.close();<br>
System.out.println(&quot;\n\n******* sql execue Succend *************\n&quot;);<br>
return ht;<br>
} catch (Exception ye) {<br>
System.out.print(&quot;\n 在执行sql时出现异常:\n&quot;+ye.toString()) ;<br>
System.out.println(&quot;\n\n******* sql execue Error *************\n&quot;);<br>
try {<br>
con.close();<br>
} catch (Exception ffye) {}<br>
}<br>
return ht ;<br>
}<br>
/*<br>
说明:返回的是查询后的结果 Vector<br>
*/<br>
public static Vector selectAll(String sqlStr ) {<br>
sqlStr=sqlStr.trim();<br>
System.out.print(&quot;\n********* selectAll(String sqlStr) execue state ************\n 
will execure sql=&quot;+sqlStr);<br>
Vector ht=new Vector();<br>
java.sql.Connection con=null; // Create a conn<br>
java.sql.Statement stat;<br>
java.sql.ResultSet result;<br>
String url, user, password, sDriver;<br>
12 下一页
💿 文件大小 11 K
👤 上传用户 RSY527
📂 所属分类 Java编程
🏷️ 相关标签

#java #源程序
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -