package prj_find;
import java.sql.*;
public class TSql {
void t_find()
{
java.sql.Connection conn = null;
java.sql.Statement sm = null;
java.sql.ResultSet rs = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:hjs","mydb","hjs12345");
sm = conn.createStatement();
rs = sm.executeQuery("select * from tcustomers");
while(rs.next())
{
System.out.println("name:" + rs.getString("tname") + " id: " +
rs.getString("tid") + " desc: " + rs.getString("tdesc"));
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
rs.close();
sm.close();
conn.close();
}
catch(Exception e1)
{
e1.printStackTrace();
}
}
}
void t_insert()
{
java.sql.Connection conn = null;
java.sql.Statement sm = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:hjs","mydb","hjs12345");
sm = conn.createStatement();
String sql = "insert into tcustomers(tid, tname, tdesc) values('"
+ "430408198301220020" + "','" + "李四" + "','" + "test" + "')";
System.out.println(sql);
sm.executeQuery(sql);
sql = "update tcustomers set tname = '王五' where tname = '李四'";
System.out.println(sql);
sm.executeQuery(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
sm.close();
conn.close();
}
catch(Exception e1)
{
e1.printStackTrace();
}
}
}
void t_delete()
{
java.sql.Connection conn = null;
java.sql.Statement sm = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:hjs","mydb","hjs12345");
sm = conn.createStatement();
String sql = "delete from tcustomers where tname = '王五'";
System.out.println(sql);
sm.executeQuery(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
sm.close();
conn.close();
}
catch(Exception e1)
{
e1.printStackTrace();
}
}
}
public static void main(String[] args) {
// TODO Auto-generated method stub
TSql t = new TSql();
t.t_insert();
t.t_find();
t.t_delete();
t.t_find();
}
}
import java.sql.*;
public class TSql {
void t_find()
{
java.sql.Connection conn = null;
java.sql.Statement sm = null;
java.sql.ResultSet rs = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:hjs","mydb","hjs12345");
sm = conn.createStatement();
rs = sm.executeQuery("select * from tcustomers");
while(rs.next())
{
System.out.println("name:" + rs.getString("tname") + " id: " +
rs.getString("tid") + " desc: " + rs.getString("tdesc"));
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
rs.close();
sm.close();
conn.close();
}
catch(Exception e1)
{
e1.printStackTrace();
}
}
}
void t_insert()
{
java.sql.Connection conn = null;
java.sql.Statement sm = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:hjs","mydb","hjs12345");
sm = conn.createStatement();
String sql = "insert into tcustomers(tid, tname, tdesc) values('"
+ "430408198301220020" + "','" + "李四" + "','" + "test" + "')";
System.out.println(sql);
sm.executeQuery(sql);
sql = "update tcustomers set tname = '王五' where tname = '李四'";
System.out.println(sql);
sm.executeQuery(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
sm.close();
conn.close();
}
catch(Exception e1)
{
e1.printStackTrace();
}
}
}
void t_delete()
{
java.sql.Connection conn = null;
java.sql.Statement sm = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:hjs","mydb","hjs12345");
sm = conn.createStatement();
String sql = "delete from tcustomers where tname = '王五'";
System.out.println(sql);
sm.executeQuery(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
sm.close();
conn.close();
}
catch(Exception e1)
{
e1.printStackTrace();
}
}
}
public static void main(String[] args) {
// TODO Auto-generated method stub
TSql t = new TSql();
t.t_insert();
t.t_find();
t.t_delete();
t.t_find();
}
}