oracleµ÷ÓÃjava³ÌÐòÁ¬sqlserver2005
1¡¢ÔÚoracleµÄsys-sysdbaϵǽ
дһ¸öjava source³ÌÐòÁ´½Ósqlserver2005£º
create or replace and compile java source named test as
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class excutesql1
{
public static String entry(String str1,String str2) {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
// ¼ÓÔØjdbcÇý¶¯
String a = "0";
String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=wb"; // Á´½ÓÊý¾Ý¿â·þÎñºÍÇý¶¯sample
String userName = "sa"; // ̞
String userPwd = "giap"; // ÃÜÂë
Connection dbConn;
try {
a = "1";
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
String sql = "insert into ry_jbxx (RYBH,XM) values ('" + str1
+ "','" + str2 + "')";
PreparedStatement pstmt = dbConn.prepareStatement(sql);
pstmt.addBatch();
pstmt.executeBatch();
a = "2";
} catch (Exception e) {
e.printStackTrace();
a = "error";
&n
Ïà¹ØÎĵµ£º
Ï̳߳ØͨË×µÄÃèÊö¾ÍÊÇÔ¤ÏÈ´´½¨Èô¸É¿ÕÏÐỊ̈߳¬µÈµ½ÐèÒªÓöàÏß³ÌÈ¥´¦ÀíÊÂÎñµÄʱºòÈ¥»½ÐÑijЩ¿ÕÏÐÏß³ÌÖ´Ðд¦ÀíÈÎÎñ£¬ÕâÑù¾ÍÊ¡È¥ÁËƵ·±´´½¨Ï̵߳Äʱ¼ä£¬ÒòΪƵ ·±´´½¨Ïß³ÌÊÇÒªºÄ·Ñ´óÁ¿µÄCPU×ÊÔ´µÄ¡£Èç¹ûÒ»¸öÓ¦ÓóÌÐòÐèҪƵ·±µØ´¦Àí´óÁ¿²¢·¢ÊÂÎñ£¬²»¶ÏµÄ´´½¨Ïú»ÙÏß³ÌÍùÍù»á´ó´óµØ½µµÍϵͳµÄЧÂÊ£ ......
package com.project.ajaxs;
import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
import java.util.Calendar;
import java.uti ......
ת×Ô:http://lavasoft.blog.51cto.com/62575/27069
Java¶àÏ̱߳à³Ì×ܽá
Ò»¡¢ÈÏʶ¶àÈÎÎñ¡¢¶à½ø³Ì¡¢µ¥Ï̡߳¢¶àÏß³Ì
ÒªÈÏʶ¶àÏ߳̾ÍÒª´Ó²Ù×÷ϵͳµÄÔÀí˵Æð¡£
ÒÔÇ°¹ÅÀϵÄDOS²Ù×÷ϵͳ£¨V 6.22£©Êǵ¥ÈÎÎñµÄ£¬»¹Ã»ÓÐÏ̵߳ĸÅÄϵͳÔÚÿ´ÎÖ»ÄÜ×öÒ»¼þÊÂÇé¡£±ÈÈçÄãÔÚcopy¶«Î÷µÄʱºò²»ÄÜrenameÎļþÃû¡£ÎªÁËÌá¸ß ......
import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.net.MalformedURLException;
import java.net.URL;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JButton;
import javax.swing.JFrame;
import j ......
1.JavaѧϰÍøÕ¾:
JavaÖÐÎÄÊÀ½çÂÛ̳ http://www.chinajavaworld.com/index.jspa
JavaÊÀ¼ÍÍø http://www.java2000.net/
Java ÖÐÎÄÕ¾ http://www.java-cn.com/
JavaѧϰÊÒ ......