博文
SQL数据库上机语言集合(2006-10-16 15:12:00)
摘要：游标：
use teaching godeclare student_cursor1 cursorfor select * from student
godeclare student_cursor2 cursor
for select suo,sname from student where dept='324' order by snofor read onlygo
打开游标等操作：
use teachinggodeclare student_cursor4 cursor
for select ok,ko from sword where do='1' order by okfor read onlygo
open student_cursor4use teachinggodeclare @ko varchar(7),@ok varchar(20)fetch next from student_cursor4into @ok,@ko
while @@fetch_status=0begin print @ok+@kofetch next from student_cursor401into @ko,@okendclose student_cursor4deallocate student_cursor4
go
存储过程:
CREATE PROCEDURE student_info @ok varchar(20)AS select ok,ko,dofrom sword
where ok=@okGO......
J2ME 打包JAR文件的一些菜鸟问题(2006-10-08 10:14:00)
摘要：_BAT_姜维(14923349) 09:58:21太好了今天人都在 _BAT_姜维(14923349) 09:58:25 人肉小炒(418138484) 09:57:08嗯,都开工了 _BAT_姜维(14923349) 09:58:42怎么打成JAR包？ 人肉小炒(418138484) 09:57:38你用的什么? _BAT_姜维(14923349) 09:59:17WTK 人肉小炒(418138484) 09:58:06这个不会 _BAT_姜维(14923349) 09:59:57你用的是什么？ 人肉小炒(418138484) 09:58:36JB _BAT_姜维(14923349) 10:00:22他可以直接生成JAR？ 人肉小炒(418138484) 09:59:24嗯 _BAT_姜维(14923349) 10:01:09唉 _BAT_姜维(14923349) 10:01:35wtk也有个打包功能生成了JAD不知道有什么用的 人肉小炒(418138484) 10:01:32没有JAR? _BAT_姜维(14923349) 10:03:13好象没有我记得有JAD 人肉小炒(418138484) 10:02:23.....jar 跟jad应该是同时存在的 _BAT_姜维(14923349) 10:04:10那上传到手机上是哪个文件？ 人肉小炒(418138484) 10:03:11有些手机只要jar有些两个都要 _BAT_姜维(14923349) 10:04:59哦 _BAT_姜维(14923349) 10:05:24JAR里面要求有什么内容？好象有个什么清单之类的，是必要的吗
您刚才发送的消息："JAR里面要求有什么内容？好象有个什么清单之类的，是必要的吗 "没有发送成功(服务器超时).
人肉小炒(418138484) 10:04:33里面有几项是必须的记不太清楚了 饭桶(110302809) 10:04:54厉害 饭桶(110302809) 10:05:03 人肉小炒(418138484) 10:05:12 _BAT_姜维(14923349) 10:06:46不包括进去不行吗？手机能在这情况下运行吗 人肉小炒(418138484) 10:08:01有些手机是必学......
J2ME 动画和背景制作程序(2006-09-12 08:22:00)
摘要：
import javax.microedition.midlet.MIDlet;import javax.microedition.lcdui.*;import javax.microedition.lcdui.game.*;//import java.unit.*;import java.io.*;
//简单的动画canvas by sword2008@程序之巢
public class test2 extends MIDlet{ private Display display;
public test2(){ }
public void startApp(){ new test(Display.getDisplay(this)).start();}
public void pauseApp(){ }
public void destroyApp(boolean unkowmn){ }
class test extends GameCanvas implements Runnable{////////////////////////////////////// private Display display; private long frameDelay; private boolean sleeping;// private Random rand; private Sprite ken; private int XSpeed,YSpeed; private TiledLayer backgroundLayer;//////////////////////////////////////int layerMap[]={1,2,3,4, 5,6,7,8, 9,10,11,12, 13,14,15,16};////////////////////////////////////// public test(Display d){ super(true); display=d;&nbs......
服务器 客户端 聊天室(2006-06-23 18:13:00)
摘要：//
import java.awt.*;import java.awt.event.*;import java.io.*;import java.net.*;import javax.swing.*;public class charroomserver {//----------------------------------------------------------****************定义变量//JFrameJFrame charFrame;JTextArea charText;JTextField charField2;JButton charButton2;ScrollPane sPanel;//JPanelJPanel jPanel1,jPanel2;//端口号and netpublic final static int DEFAULT_PORT=6666;//默认端口号ServerSocket serverSock;Socket clientSock;//index记录当前对象int index=0;//线程，对象ChatAcceptThread chatAcceptThread[]=new ChatAcceptThread[50];//对象数组
//_________________________________________________________________________________
//------------------------------------------------------------***************方法
//服务端图形 void gUi(){//new charFrame=new JFrame("聊天室服务端"); jPanel2=new JPanel(); charButton2=new JButton("退出"); charText=new JTextArea(20,20); sPanel=new ScrollPane(); charField2=new JTextField(20); Container chartain=charFrame.getContentPane()......
数据库课程设计(2006-06-23 16:18:00)
摘要：/*数据库课程设计 *JAVA程序处理前端连接等操作 *使用: *1,打开数据库管理器,打开查询编辑器,在查询编辑器输入附加SQL语言,创建将要使用的目标数据库 *2,进行JDBC-ODBC连接 *过程:打开管理工具,选择数据源ODBC,在系统DSN添加:名称:studyDSN,连接到(local),选择网络ID选项,默认数据库为study,连接! *3,使用JCreator之类的工具编译程序. *4,用户名:admin 密码:123456 *@2006.6.23 */
/*附加SQL语言
create database studygouse studygo create table student(sno char(5) not null UNIQUE, sname char(10), ssex char(2), sage int, sdept char(20) PRIMARY KEY(sno)) */import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.sql.*;import javax.swing.border.*;import java.util.*;
public class Allmain{ //------------------------------------------------......
数据库总外观(2006-06-20 11:06:00)
摘要：import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.sql.*;import javax.swing.border.*;import java.util.*;
public class Allmain{ //---------------------------------------------------------变量定义//swingJLabel conLabel,addLabel,modLabel,droLabel,aboLabel;JButton conButton,addButton,modButton,droButton;JTextField conField;JFrame mainFrame;//stringstatic final String JDBC="sun.jdbc.odbc.JdbcOdbcDriver";static final String DATEBASE="jdbc:odbc:studyDSN";//数据库API变量public Connection connection;public Statement statement;String sqlString;
//----------------------------------------------------------------------
Allmain(){ mainFrame=new JFrame("数据库课程设计"); JPanel mainPanel=new JPanel(); mainPanel.setBackground(new Color(255,192,192)); mainPanel.setLayout(new GridLayout(5,2,5,5));//------------------------------------------------------外观值aboLabel=new JLabel("");
conLabel=new JLabel("数据库名称");addLabel=new JLabel("添加数据");modLabel=new JLabel("修......
charroom客户端2(2006-06-14 09:49:00)
摘要：import java.net.*; import java.io.*; import javax.swing.*;import java.awt.*;import java.awt.event.*;
public class charroom implements Runnable{ //----------------------------------------------------------****************定义变量//JFrameJFrame charFrame;JTextArea charText;JTextField charField1,charField2,charField3,charField4;JButton charButton1,charButton2,charButton3;ScrollPane sPanel;JLabel charLabel;//JPanelJPanel jPanel1,jPanel2;//Socket变量Socket server,socket;//文件,ioBufferedReader in;PrintWriter out;BufferedReader wt;//ThreadThread charThread=new Thread(this);
//_________________________________________________________________________________
public charroom(){ gUi(); }
//------------------------------------------------------------***************方法//客服端图形 void gUi(){//new charFrame=new JFrame("聊天室客户端"); jPanel1=new JPanel(); jPanel2=new JPanel(); charLabel=new JLabel("你对"); charButton1=new JButton("连接"); charButton2=new JButton("发送");&......
服务器2有群发功能(2006-06-13 09:43:00)
摘要：import java.awt.*;import java.awt.event.*;import java.io.*;import java.net.*;import javax.swing.*;public class charroomserver {//----------------------------------------------------------****************定义变量//JFrameJFrame charFrame;JTextArea charText;JTextField charField2;JButton charButton2;ScrollPane sPanel;//JPanelJPanel jPanel1,jPanel2;//端口号and netpublic final static int DEFAULT_PORT=6666;//默认端口号ServerSocket serverSock;Socket clientSock;//index记录当前对象int index=0;//线程，对象ChatAcceptThread chatAcceptThread[]=new ChatAcceptThread[50];//对象数组
//_________________________________________________________________________________
//------------------------------------------------------------***************方法
//服务端图形 void gUi(){//new charFrame=new JFrame("聊天室服务端"); jPanel2=new JPanel(); charButton2=new JButton("退出"); charText=new JTextArea(20,20); sPanel=new ScrollPane(); charField2=new JTextField(20); Container chartain=charFrame.getContentPane();//a......
服务器端charroomserver(2006-06-07 10:30:00)
摘要：import java.awt.*;import java.awt.event.*;import java.io.*;import java.net.*;import javax.swing.*;public class charroomserver {//----------------------------------------------------------****************定义变量//JFrameJFrame charFrame;JTextArea charText;JTextField charField2;JButton charButton2;ScrollPane sPanel;//JPanelJPanel jPanel1,jPanel2;//端口号and netpublic final static int DEFAULT_PORT=6666;//默认端口号ServerSocket serverSock;Socket clientSock;//Thread //Thread chatAcceptThread;//启动接受连接的线程ChatAcceptThread chatAcceptThread;
//_________________________________________________________________________________
//------------------------------------------------------------***************方法
//服务端图形 void gUi(){//new charFrame=new JFrame("聊天室服务端"); jPanel2=new JPanel(); charButton2=new JButton("退出"); charText=new JTextArea(20,20); sPanel=new ScrollPane(); charField2=new JTextField(20); Container chartain=charFrame.getContentPane();//add ......
客服端 charroom(2006-06-07 09:07:00)
摘要：import java.net.*; import java.io.*; import javax.swing.*;import java.awt.*;import java.awt.event.*;
public class charroom implements Runnable{ //----------------------------------------------------------****************定义变量//JFrameJFrame charFrame;JTextArea charText;JTextField charField1,charField2,charField3,charField4;JButton charButton1,charButton2;ScrollPane sPanel;JLabel charLabel;//JPanelJPanel jPanel1,jPanel2;//Socket变量Socket server,socket;//文件,ioBufferedReader in;PrintWriter out;BufferedReader wt;//ThreadThread charThread=new Thread(this);;
//_________________________________________________________________________________
public charroom(){ gUi(); }
//------------------------------------------------------------***************方法//客服端图形 void gUi(){//new charFrame=new JFrame("聊天室客户端"); jPanel1=new JPanel(); jPanel2=new JPanel(); charLabel=new JLabel("你对"); charButton1=new JButton("连接"); charButton2=new JButton("发送"); charTe......