ITPub博客

create database mydbgouse mydbgodrop table stuinfodrop table stumarksif exists(select * from sysobjects where name ='bank')drop table bankgocreate table bank( cardid varchar(20) not null primary key, customname varchar(10) not null , currentmoney money not null check(currentmoney>=1) )if exists (select * from sysobjects where name='transinfo')drop table transinfogocreate table transinfo( cardid varchar(20) not null foreign key references bank(cardid), chargetype varchar(4) not null , tmoney

=============================数据库建立=============================create database mydbon primary(name='mydb',filename='D:projectmydb_mdf.mdf',size=10mb,maxsize=200mb,filegrowth=10%)log on(name='mydb1',filename='D:projectmydb_log.ldf',size=10mb,maxsize=200mb,filegrowth=10%)use mydbgocreate table student(stuid int not null primary key identity(1,1),stuname varchar(10) not null unique,stuage smalldatetime not null check(stuage>'1980-1-1'and stuage<'1988-1-1')stuaddress varchar(20) default '

M V C principleJava Swing JTable Usefull=======================Object Class User=======================/** * <p>Title: </p> * * <p>Description: </p> * * <p>Copyright: Copyright (c) 2007</p> * * <p>Company: </p> * * @author not attributable * @version 1.0 */public class User { private int userID; private String userName; private String userSex; private int userAge; public User() { } public void setUserID(int userID) { thi

DataBase Connection Java==================================import java.sql.*;/** * <p>Title: </p> * * <p>Description: </p> * * <p>Copyright: Copyright (c) 2007</p> * * <p>Company: </p> * * @author not attributable * @version 1.0 */public class DB { public DB() { } public static Connection getConnection() { String Resource = "sun.jdbc.odbc.JdbcOdbcDriver"; try { Class.forName(Resource); } catch (Clas

Today's topic is about HTML time display ,created a javascript==================================<html><title>noname</title><head></head><script language="javascript" type="text/javascript"> function showTime(){ var today=new Date(); var year=today.getYear(); var month=today.getMonth()+1; var date=now.getDate();//是now还是today? var hours=today.getHours(); var mins=today.getMinutes(); var secs=today.getSeconds(); var ampm=&qu

Today i had already done last year exam on computer .============================here is the DBoperator============================import java.sql.*;import java.io.FileReader;import java.io.File;import java.io.BufferedReader;import java.io.*;/** * <p>Title: </p> * * <p>Description: </p> * * <p>Copyright: Copyright (c) 2007</p> * * <p>Company: </p> * * @author not attributable * @version 1.0 */public class DataOperator { StuFrm frm; public Dat

HTML========================marquee标记(图片滚动方法)========================<html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>无标题文档</title></head><body><table><tr><td width="900"><marquee scrollamount="10" onMouseOver="this.stop();"onMouseOut="this.start();" direction="left" height="212" width="283"

Java Swing ODBCT-Sql=======================Today'goal is achieve Login UserName is vaildate adn connecting withDateBase (sql ) by ODBC=======================UserLoginFrm Source =======================import java.awt.BorderLayout;import javax.swing.JFrame;import javax.swing.JLabel;import java.awt.Rectangle;import javax.swing.JTextField;import javax.swing.JPasswordField;import javax.swing.JButton;import java.awt.Font;import java.awt.Color;import java.awt.event.ActionEvent;import java.awt.event.Act

固定资产管理系统：１，用户登陆验证模块２，用户管理模块３，公司员工管理模块４，固定资产管理５，固定资产类别管理６，查询模块７，附件以及帮助模块[@more@]

很感谢您的想法和对程序员的充分解释，我觉得程序员到了３０左右的时候关键是看你的追求，对软件的追求是否坚持决定了今后的发展，就是那句话，赚口饭钱是没有问题，更高的追求，，，，，，还是取决于个人，有些人容易满足，有些人则不然，我很敬重象您这样的老师，很感谢您～～｀软件让我自己找回了人生的方向，再苦再累，痛并快乐着，和着汗水和泪水一同咽到自己的肚子里吧～我很欣赏自己在２３岁的时候发现了人生的目标，因为一切都不晚～从大学毕业时我不认为自己选择对了专业，可是现在我觉得是自己的无知和无能，每个专业都是有它的

My first blog ,and also the first blog used for technology developing my level of english and most important is skills of software which being relayed on living things ,hoping more and more people who had the same goal as me that is challenging ourselves ,and holding the software business all my life due to the belief which i always expected do ~in the past four months i have already learned C ,language for programming ,and SQL ,select query language made by microsoft ,and one kinds of java ----