package com.test.oracle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ConfJdbc {
/**
* 连接数据库
*/
public static Connection connect() {
try {
//注册JDBC驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException ex) {
System.out.println("数据库驱动没找到...");
}
//创建数据库连接
String url = "jdbc:oracle:thin:@3.242.165.133:1521:pat";
String username = "patlocal";
String password = "patlocal";
Connection con = null;
try {
con = DriverManager.getConnection(url, username, password);
System.out.println(con+" DB连接成功...");
} catch (SQLException ex) {
System.out.println("Db连接失败...");
}
return con;
}
/**
* 建表
*/
public static void create() {
Connection con = connect();
Statement statement = null;
try {
statement = con.createStatement();
System.out.println("--Creating Tables--");
statement.executeUpdate("CREATE TABLE Person(name VARCHAR2(100) PRIMARY KEY,age INTEGER,live_in VARCHAR2(100) )");
statement.close();
con.close();
System.out.println("建表成功...");
} catch (SQLException ex) {
System.out.println("建表失败...");
}
}
/**
* 插入记录
*/
public static void insert() {
Connection con = connect();
Statement statement = null;
try {
statement = con.createStatement();
System.out.println("--Inserting Data--");
statement.executeUpdate("INSERT INTO Person (name, age, live_in) VALUES('Robert Bellamy',24,'England')");
statement.executeUpdate("INSERT INTO Person (name, age, live_in) VALUES ('Grayham Downer',null,'Africa')");
statement.executeUpdate("INSERT INTO Person (name, age, live_in) VALUES ('Timothy French',24,'Africa')");
statement.executeUpdate("INSERT INTO Person (name, age, live_in) VALUES ('Butch Fad',53,'USA')");
statement.executeUpdate("INSERT INTO Person (name, age, live_in) VALUES ('Judith Brown',34,'Africa')");
statement.close();
con.close();
System.out.println("插入成功...");
} catch (SQLException ex) {
System.out.println("插入失败...");
}
}
/**
* 查询数据
*/
public static void select() {
Connection con = connect();
Statement statement = null;
try {
statement = con.createStatement();
ResultSet result;
System.out.println("--SQL queries--");
result = statement.executeQuery("SELECT AVG(age) FROM Person");
if (result.next()) {
System.out.println("AV.age: " + result.getDouble(1));
}
System.out.println();
result = statement.executeQuery("SELECT name FROM Person WHERE live_in = 'Africa'");
while (result.next()) {
System.out.println("Person's name:" + result.getString(1));
}
statement.close();
con.close();
} catch (SQLException ex) {
System.out.println("查询失败...");
}
}
/**
* 删除数据
*/
public static void delete() {
Connection con = connect();
Statement statement = null;
try {
statement = con.createStatement();
statement.executeUpdate("DELETE FROM Person WHERE name='Timothy French'");
statement.close();
con.close();
System.out.println("删除成功...");
} catch (SQLException ex) {
System.out.println("删除失败...");
}
System.out.println("-- Now data --");
select();
}
/**
* 删除表
*/
public static void dropTable() {
Connection con = connect();
Statement statement = null;
try {
statement = con.createStatement();
//删除表
statement.execute("DROP TABLE Person");
statement.close();
con.close();
System.out.println("表已删除...");
} catch (SQLException ex) {
System.out.println("删表失败...");
}
}
public static void main(String[] arg) {
connect();
// create();
// insert();
// select();
// delete();
// dropTable();
}
}
|
package test;
import java.util.Calendar;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
public class JavaExe {
@SuppressWarnings("unchecked")
public static void main(String[] args) {
Date inGroupTime = new Date();
java.util.Calendar cal = Calendar.getInstance();
cal.setTime(inGroupTime);
int day_of_month = cal.get(Calendar.DAY_OF_MONTH);
System.out.println(day_of_month);
System.out.println(day_of_month%2!=0);
Map<Integer,String> map = new HashMap<Integer,String>();
map.put(1, "1");
map.put(2,"1");
map.put(1, "1");
for (Iterator iter = map.keySet().iterator(); iter.hasNext();) {
Object key = iter.next();
Object val = map.get(key);
System.out.println(key+"--"+val);
}
Runtime rn = Runtime.getRuntime();
@SuppressWarnings("unused")
Process p = null;
try
{
String str = "\"C:\\Program Files\\360\\360safe\\360rpt.exe\"" ;
p = rn.exec(str);
}
catch (Exception e)
{
System.out.println("Error to run the exe");
}
}
}
|