摘要： create table test(name varchar(20),password int)//添加自增alter table test add id int identity(1,1)//前一个1是自增开始的数字，后一个1是自增的间隔alter table test drop column idselect * from testinsert into test values('we',23)insert into test values('www',233)truncate table testdelete from test where name=&# 阅读全文

摘要： import java.sql.*;public class TestTransaction {public static void main(String[] args) {Connection conn = null;Statement stmt = null;try {Class.forName("oracle.jdbc.driver.OracleDriver");conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:SXT", "scott", 阅读全文

摘要： import java.sql.*;public class TestPrepStmt {public static void main(String[] args) {if(args.length != 3) {System.out.println("Parameter Error! Please Input Again!");System.exit(-1);}int deptno = 0;try {deptno = Integer.parseInt(args[0]);} catch (NumberFormatException e) {System.out.printl 阅读全文

摘要： import java.sql.*;public class TestMysqlConnection {/** * @param args */public static void main(String[] args) {Connection conn = null;Statement stmt = null;ResultSet rs = null;try {Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection("jdbc:mysql://localhost/mydat 阅读全文

摘要： import java.sql.*;public class TestJDBC {public static void main(String[] args) {ResultSet rs = null;Statement stmt = null;Connection conn = null;try {Class.forName("oracle.jdbc.driver.OracleDriver");//new oracle.jdbc.driver.OracleDriver();conn = DriverManager.getConnection("jdbc:orac 阅读全文

摘要： import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class TestDML {public static void main(String[] args) {Statement stmt = null;Connection conn = null;try {Class.forName("oracle.jdbc.driver.OracleDrive 阅读全文

摘要： B树就是二叉树 http://wenku.baidu.com/view/57302986ec3a87c24028c444.html 阅读全文