博文

SQL数据库上机语言集合(2006-10-16 15:12:00)

摘要:游标: use teaching
go
declare student_cursor1 cursor
for select *
    from student go
declare student_cursor2 cursor for select suo,sname
 from student
 where dept='324'
 order by sno
for read only
go 打开游标等操作: use teaching
go
declare student_cursor4 cursor for select ok,ko
 from sword
 where do='1'
 order by ok
for read only
go open student_cursor4
use teaching
go
declare @ko varchar(7),@ok varchar(20)
fetch next from student_cursor4
into @ok,@ko while @@fetch_status=0
begin
print @ok+@ko
fetch next from student_cursor401
into @ko,@ok
end
close student_cursor4
deallocate student_cursor4 go        存储过程: CREATE PROCEDURE student_info  @ok varchar(20)
AS select ok,ko,do
from sword where ok=@ok
GO
......

阅读全文(2918) | 评论:0

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:17
WTK
人肉小炒(418138484) 09:58:06
这个不会
_BAT_姜维(14923349) 09:59:57
你用的是什么?
人肉小炒(418138484) 09:58:36
JB
_BAT_姜维(14923349) 10:00:22
他可以直接生成JAR?
人肉小炒(418138484) 09:59:24

_BAT_姜维(14923349) 10:01:09

_BAT_姜维(14923349) 10:01:35
wtk也有个打包功能
生成了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:24
JAR里面要求有什么内容?
好象有个什么清单之类的,是必要的吗    您刚才发送的消息:"JAR里面要求有什么内容?
好象有个什么清单之类的,是必要的吗 "没有发送成功(服务器超时). 人肉小炒(418138484) ......

阅读全文(4587) | 评论:0

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};
//////......

阅读全文(4722) | 评论:0

服务器 客户端 聊天室(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 {
//----------------------------------------------------------****************定义变量
//JFrame
JFrame charFrame;
JTextArea charText;
JTextField charField2;
JButton charButton2;
ScrollPane sPanel;
//JPanel
JPanel jPanel1,jPanel2;
//端口号and net
public 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);
 s......

阅读全文(4221) | 评论:0

数据库课程设计(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 study
go
use study
go
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.bo......

阅读全文(433) | 评论:0

数据库总外观(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{
 
//---------------------------------------------------------变量定义
//swing
JLabel conLabel,addLabel,modLabel,droLabel,aboLabel;
JButton conButton,addButton,modButton,droButton;
JTextField conField;
JFrame mainFrame;
//string
static 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));
//------------------------------------------------------外观值
a......

阅读全文(400) | 评论:0

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{
//----------------------------------------------------------****************定义变量
//JFrame
JFrame charFrame;
JTextArea charText;
JTextField charField1,charField2,charField3,charField4;
JButton charButton1,charButton2,charButton3;
ScrollPane sPanel;
JLabel charLabel;
//JPanel
JPanel jPanel1,jPanel2;
//Socket变量
Socket server,socket;
//文件,io
BufferedReader in;
PrintWriter out;
BufferedReader wt;
//Thread
Thread charThread=new Thread(this);
//_________________________________________________________________________________ public  charroom(){
 gUi();
 } //------------------------------------------------------------***************方法
//客服端图形
void gUi(){
//new
 charFrame=new JFrame("聊天室客户端");
 jPanel1=new JPanel();
 jPa......

阅读全文(429) | 评论:0

服务器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 {
//----------------------------------------------------------****************定义变量
//JFrame
JFrame charFrame;
JTextArea charText;
JTextField charField2;
JButton charButton2;
ScrollPane sPanel;
//JPanel
JPanel jPanel1,jPanel2;
//端口号and net
public 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);
 sPane......

阅读全文(405) | 评论:0

服务器端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 {
//----------------------------------------------------------****************定义变量
//JFrame
JFrame charFrame;
JTextArea charText;
JTextField charField2;
JButton charButton2;
ScrollPane sPanel;
//JPanel
JPanel jPanel1,jPanel2;
//端口号and net
public 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();
......

阅读全文(556) | 评论:0

客服端 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{
//----------------------------------------------------------****************定义变量
//JFrame
JFrame charFrame;
JTextArea charText;
JTextField charField1,charField2,charField3,charField4;
JButton charButton1,charButton2;
ScrollPane sPanel;
JLabel charLabel;
//JPanel
JPanel jPanel1,jPanel2;
//Socket变量
Socket server,socket;
//文件,io
BufferedReader in;
PrintWriter out;
BufferedReader wt;
//Thread
Thread charThread=new Thread(this);; //_________________________________________________________________________________ public  charroom(){
 gUi();
 } //------------------------------------------------------------***************方法
//客服端图形
void gUi(){
//new
 charFrame=new JFrame("聊天室客户端");
 jPanel1=new JPanel();
 jPanel2=new JPanel......

阅读全文(508) | 评论:0