35平方铝芯电缆载流量:Jsp程序实现对数据库的增删改功能代码或教程

dbconig.properties
可以实现多个数据库连接的
#Oracle Driver
driver=oracle.jdbc.OracleDriver
url=jdbc:oracle:thin:@127.0.0.1:1521:XT
user=scott
password=tiger
#MS SQLServer Driver
#driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
#url=jdbc:microsoft:sqlserver://127.0.0.1:1433
#user=pubuser
#password=pubuser
#JDBC-ODBC brige
#driver=sun.jdbc.odbc.JdbcOdbcDriver
#url=jdbc:odbc:pubsdb
#user=pubuser
#password=pubuser
**DBConfig.java
package JDBC;
import java.util.ResourceBundle;

public class DBconfig {
/*
* 从配制文件了获得的数据
*/
final static String RESOURCE = "javaprojects.JDBC.dbconfig";
final static ResourceBundle resourceBundle = ResourceBundle.getBundle(RESOURCE);

public static String getString(String key){
return resourceBundle.getString(key);
}

}
DBConnection.java
package JDBC ;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBconnection {
public static Connection getConnection(){
Connection conn = null;

try {
/*
* 从配制文件里调用数据
*/
final String driver = DBconfig.getString("driver");
final String url = DBconfig.getString("url");
final String user = DBconfig.getString("user");
final String password = DBconfig.getString("password");
/*
* 1.加载驱动程序
*/
Class.forName(driver);
/*
* 2. 获取数据库连接
*/
conn = DriverManager.getConnection(url,user,password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}

}

QueryDemo.java
package JDBC;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSetMetaData;

public class QueryDemo {

/**
* @param args
*/
public static void main(String[] args) {

Connection conn = DBconnection.getConnection();

try {
Statement stmt = conn.createStatement();
final String query = "select * from authors";
ResultSet rs = stmt.executeQuery(query);

ResultSetMetaData rsmd = rs.getMetaData();
int colCount = rsmd.getColumnCount();
String[] colNames = new String[colCount];

for(int i = 0; i < colCount; i++){
colNames[i] = rsmd.getColumnName(i+1);
}
int[] colTypes = new int[colCount];
for(int i = 0; i < colCount; i++){
colTypes[i] = rsmd.getColumnType(i+1);
}
System.out.println("*****************************************************");
for(int i = 0; i < colCount; i++){
System.out.print(colNames[i] +"\t");
}
System.out.println("\n*****************************************************");

while(rs.next()){
for(int i = 0; i < colCount; i++){
System.out.print(rs.getString(i+1) + "\t");
}
System.out.println();
}

//stmt.close();
rs.close();
} catch (SQLException e) {
e.printStackTrace();
} finally{
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}

System.out.println("End.");
}

}

EMPDemo.java
package JDBC;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Date;

public class EMPDemo {

/**
* @param args
*/
public static void main(String[] args) {
Connection conn = DBconnection.getConnection();

if(conn != null){
//final String isql = "insert into emp(empno,ename,sal,hiredate,deptno) values(9988, '王麻子', 1200, to_date('2004-12-21', 'yyyy-mm-dd'),10)";

final String usql = "update emp set sal = 1300 where empno=9988";

//final String dsql = "delete from emp where empno=9988 or empno=8888";

final String query = "select * from emp";

try {
Statement stmt = conn.createStatement();
int retValue = stmt.executeUpdate(usql);
//stmt.execute()
System.out.println("retValue=" + retValue);

ResultSet rs = stmt.executeQuery(query);
while(rs.next()){
int empno = rs.getInt(1);
String ename = rs.getString(2);
double salary = rs.getDouble("sal");
Date hiredate = rs.getDate(5);

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd");
System.out.println("***********************************");
System.out.println("empno = " + empno);
System.out.println("ename = " + ename);
System.out.println("salary = " + salary);
System.out.println("hiredate = " + sdf.format(hiredate));
}

stmt.close();
rs.close();
} catch (SQLException e) {
System.out.println("ErrorCode = " + e.getErrorCode());
System.out.println("Error Message = " + e.getMessage());

//e.printStackTrace();
} finally{
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
System.out.println("End.");
}

}