test.java

来自「使用短信猫发送短信的程序源代码」· Java 代码 · 共 43 行

import java.io.*;
import java.sql.*;

public class Test {

	/**
	 * @param args
	 */
	public static void main(String[] args) {

        try
        {   
            System.out.println("开始初始化"); 
            DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
            //Class.forName("oracle.jdbc.OracleDriver").newInstance();
            System.out.println("初始化成功");       
            Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.110.1:1521:orcl", "dlyx","dlyx");
            System.out.println("连接成功");
            CallableStatement cs = conn.prepareCall( "begin dx_savenewmsg(?,?,?); end;" ) ; 
            cs.setString(1, "13817743472");
            cs.setString(2, "测试收到短信"); 
            cs.registerOutParameter(3, Types.INTEGER);            
            cs.executeUpdate();
            
            if (cs.getInt(3)==0) 
               {System.out.println("执行成功"); } 
            else System.out.println("执行失败");

            cs.close();
            
            Statement statement = conn.createStatement();
            statement.executeUpdate("UPDATE DX_DXSFJL SET zt=5 where  MSGid=4");
            conn.close();
        }
        catch(Exception sqlexception)
        {
            System.out.println("执行失败");
        }

	}

}