- 博客(34)
- 收藏
- 关注
RSS订阅转载 JDBC_Transaction_Processing
1. Commit Class UtiDb Class BusPro package JavaJDBC.Chap09.sec01;import JavaJDBC.util.UtiDb;import java.sql.Connection;imp...
2016-05-27 10:06:00
105
转载 JDBC_DatabaseMetaData_ResultSetMetaData
1. DatabaseMetaData Class UtiDb Class DatMetDat package JavaJDBC.Chap08.sec01;import JavaJDBC.util.UtiDb;import java.sql.Connect...
2016-05-27 09:42:00
106
转载 JDBC_CallabelStatement
Class UtiDb Class Book Class CallebalSta package JavaJDBC.Chap07.sec02;import JavaJDBC.util.UtiDb;import java.sql.CallableS...
2016-05-27 09:30:00
141
转载 JDBC_CLOB_BLOB
1. CLOB -- Insert Class UtiDb Class Book package JavaJDBC.model; import java.io.File; /** * Created by linux_ccmj on 16...
2016-05-27 09:11:00
119
转载 JDBC_ExecuteUpdate
1. ExecuteQuery ResultSet --> Column Index Class UtiDb import java.sql.DriverManager; import java.sql.SQLException; import java.sql....
2016-05-27 08:44:00
162
转载 JDBC_PreparedStatement
1. Insert Class UtiDb package JavaJDBC.util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;i...
2016-05-27 08:23:00
87
转载 JDBC_Statement
1. ExecuteUpdate Insert 1 i. Class UtiDb package JavaJDBC.util;import java.sql.Connection;import java.sql.DriverManager;import java.sq...
2016-05-26 19:21:00
94
转载 JDBC_Driver_Connection
1. Driver loading package JavaJDBC.Chap02.Sec03; /** * Created by linux_ccmj on 16-5-10. */ public class Demo1 { // JDBC driver nam...
2016-05-26 18:54:00
87
转载 JDBC_Library_Management_System
Use MVC (Model View Control) frame to design a library management system. The project structure: The database situation: 1. L...
2016-05-25 22:10:00
115
转载 Ubuntu14.04_Wifi_Hotspot
1. Create wifi hotspot 1). Network --> edit connection 2). Add --> Wifi 3). Connection name 4). Wi-Fi.SSID, Wi-Fi.Mod...
2016-05-20 13:13:00
112
转载 Java MVC设计模式
MVC(Model View Control) 模型－视图－控制器 一、MVC与模板概念的理解 MVC本来是存在于Desktop程序中的，M是指数据模型，V是指用户界面，C则是控制器。使用MVC的目的是将M和V的实现代码分离，从而使同一个程序可以使...
2016-05-18 15:52:00
110
转载 WEB服务器、应用程序服务器、HTTP服务器区别
WEB服务器、应用程序服务器、HTTP服务器有何区别？IIS、Apache、Tomcat、Weblogic、WebSphere都各属于哪种服务器，这些问题困惑了很久，今天终于梳理清楚了： Web服务器的基本功能就是提供Web信息浏览服务。它只需支持HTTP协议...
2016-05-14 09:56:00
175
转载 MySQL_Backup_Restore
1. Mysqldump mysqldump-uroot-pdb_book>db_book.sql.backups use export action to get backup Export table ...
2016-05-09 22:45:00
85
转载 MySQL_Procedure_Function_Modify
1. Show showprocedurestatuslike'tesPro10'; showcreateprocedurelike'tesPro10'; 2. Alter alterproceduretesPro10comment...
2016-05-09 22:21:00
70
转载 MySQL_Procedure_Function_Cursor
1. Declare delimiter||crateprocedureusePro()begindeclarea,bvarchar(20);insertintoTesFun2values(null,a,b);end||delimiter; ...
2016-05-09 22:13:00
119
转载 MySQL_Procedure_Function
1. Create delimiter||createprocedurepro_book(inbTint,outcount_nomint)readssqldatabeginselectcount(*)fromt_bookwherebookType...
2016-05-09 21:08:00
85
转载 MySQL_Function
1. Time selectcurdate(),curtime(),month(birthday)fromt_t; selectcurdate(),curtime(),month(birthday)monthfromt_t; 2. C...
2016-05-09 16:13:00
180
转载 MySQL_Trigger
1. Create i. Trigger with single action createtriggertriafterinsertont_book2foreachrowupdatet_bookTypesetbookNumber=bookNumb...
2016-05-08 23:15:00
101
转载 MySQL_View_Change
1. Create or replace createorreplaceviewv1(bookName,price)asselectbookName,pricefromt_book2; 2. Alter alterviewv1ass...
2016-05-08 16:47:00
89
转载 MySQL_Table_View
1. View of single table Createviewv1asselect*fromt_book2;select*fromv1; createviewv2asselectbookName,pricefromt_book2;...
2016-05-08 16:42:00
184
转载 MySQL_Table_Index_Action
1. Create i. index Createtablet_user1( idint, userNamevarchar(20), passwordvarchar(20), index(userName)); ii. Uniqu...
2016-05-08 12:36:00
82
转载 MySQL_Idexe
Selectcount(*)fromt_book; select*fromt_bookwherebookName='测试图书书名35'; Before making indexe: After making indexe: ...
2016-05-05 22:07:00
59
转载 MySQL_Table_Insert_Update_Delete
1. Insert into i. Insert all Insertintot_bookvalue(null,'王者归来','95','李四','2');Insertintot_book(id,bookName,price,author,book...
2016-05-05 16:44:00
63
转载 MySQL_Table_Union_Query_Alias
1. Union selectidfromt_book;selectidfromt_bookType;selectidfromt_bookunionselectidfromt_bookType; 2. Union all select...
2016-05-05 16:27:00
74
转载 MySQL_Table_Sub_Query
1. In select*fromt_booktbwheretb.bookTypeIdin(selectidfromt_bookTypetbt);select*fromt_booktbwheretb.bookTypeIdnotin(sele...
2016-05-05 09:36:00
124
转载 MySQL_Table_Join_Query
1. Internal connection i. No connection select*fromt_book,t_bookType; ii. Where = selectbookName,author,bookTypeNamefrom...
2016-05-04 22:04:00
70
转载 MySQL_Aggregate_Functions
1. Count selectcount(*)fromt_grade;selectcount(*)astotalfromt_grade;selectcount(*)fromt_gradegroupbystuName;selectstuName,c...
2016-05-04 21:27:00
199
转载 MySQL_Table_Select
1. Select field selectid,stuName,sexfromt_student;select*fromt_student; 2. Select + where select*fromt_studentwhereid=...
2016-05-04 16:20:00
70
转载 MySQL_Character_Setting
1. Show character setting SHOWVARIABLESLIKE'character%'; 2. Setting character SETcharacter_set_database=utf8; PS: ...
2016-05-04 15:50:00
472
转载 MySQL_Table_Create_Describe_Alter_Drop
1. Create table i. Normal CREATETABLEt_bookType(idintprimarykeyauto_increment,bookTypeNamevarchar(20),bookTyptDesc...
2016-05-04 11:10:00
85
转载 MySQL_Database_Show_Create_Drop
1. Show database Showdatabases; 2. Create database createdatabasedbName; 3. Drop database dropdatabasedbName; ...
2016-05-04 10:34:00
83
转载 Ubuntu14.04_MySQL_phpMyAdmin_Install_setting
1.MySQL i.MySQL install sudoapt-getinstallmysql-serversudoapt-getinstallmysql-client Be careful: a. Input the...
2016-05-03 09:08:00
65
转载 JAVA_UDP_ChatUDP
Code importjavax.swing.*;importjava.awt.*;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.awt.event....
2016-05-02 16:08:00
81
转载 JAVA_TCP_HTTP_Get_Data_Baidu
Code importjava.io.BufferedReader;importjava.io.InputStream;importjava.io.InputStreamReader;importjava.net.*;importjava.util.Iterato...
2016-05-01 20:49:00
76
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人