package org;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import com.hexiong.jdbf.DBFWriter;
import com.hexiong.jdbf.JDBField;
public class stupara {
/***************************************************************************
*
* @param args
* @throws Exception
*/
public static void main(String[] args) throws Exception {
Object[] options = { "确定", "取消" };
int response = JOptionPane.showOptionDialog(null, "是否确认下载学生数据!", "提示框",
JOptionPane.YES_OPTION, JOptionPane.QUESTION_MESSAGE, null,
options, options[0]);
if (response == 0) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
System.out.println("数据库驱动类没找到");
}
try {
// 建立连接
String serverName = "192.168.1.2";
String portNumber = "1521";
String sid = "orcl";
String url = "jdbc:oracle:thin:@" + serverName + ":"
+ portNumber + ":" + sid;
String username = "ejob_admin";
String password = "ejob_admin";
Connection connection = DriverManager.getConnection(url,
username, password);
String sql = " select stucode,stuname from yw_studentinfo order by schoolcode ,stucode ";
PreparedStatement pstmt = connection.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
JDBField arrfiled[] = new JDBField[3];
arrfiled[0] = new JDBField("ID", 'C', 50, 0);
arrfiled[1] = new JDBField("STUCODE", 'C', 50, 0);
arrfiled[2] = new JDBField("STUNAME", 'C', 50, 0);
DBFWriter dw = new DBFWriter("c:/stupara.dbf", arrfiled);
int i = 0;
while (rs != null && rs.next()) {
String obj[] = new String[3];
obj[0] = String.valueOf(i);
obj[1] = rs.getString(1);
obj[2] = rs.getString(2);
dw.addRecord(obj);
i++;
}
dw.close();
JOptionPane.showMessageDialog(null, "成功下载学生数据!", "提示框",
JOptionPane.INFORMATION_MESSAGE);
} catch (SQLException e) {
System.out.println("执行SQL语句异常!");
e.printStackTrace();
}
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import com.hexiong.jdbf.DBFWriter;
import com.hexiong.jdbf.JDBField;
public class stupara {
/***************************************************************************
*
* @param args
* @throws Exception
*/
public static void main(String[] args) throws Exception {
Object[] options = { "确定", "取消" };
int response = JOptionPane.showOptionDialog(null, "是否确认下载学生数据!", "提示框",
JOptionPane.YES_OPTION, JOptionPane.QUESTION_MESSAGE, null,
options, options[0]);
if (response == 0) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
System.out.println("数据库驱动类没找到");
}
try {
// 建立连接
String serverName = "192.168.1.2";
String portNumber = "1521";
String sid = "orcl";
String url = "jdbc:oracle:thin:@" + serverName + ":"
+ portNumber + ":" + sid;
String username = "ejob_admin";
String password = "ejob_admin";
Connection connection = DriverManager.getConnection(url,
username, password);
String sql = " select stucode,stuname from yw_studentinfo order by schoolcode ,stucode ";
PreparedStatement pstmt = connection.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
JDBField arrfiled[] = new JDBField[3];
arrfiled[0] = new JDBField("ID", 'C', 50, 0);
arrfiled[1] = new JDBField("STUCODE", 'C', 50, 0);
arrfiled[2] = new JDBField("STUNAME", 'C', 50, 0);
DBFWriter dw = new DBFWriter("c:/stupara.dbf", arrfiled);
int i = 0;
while (rs != null && rs.next()) {
String obj[] = new String[3];
obj[0] = String.valueOf(i);
obj[1] = rs.getString(1);
obj[2] = rs.getString(2);
dw.addRecord(obj);
i++;
}
dw.close();
JOptionPane.showMessageDialog(null, "成功下载学生数据!", "提示框",
JOptionPane.INFORMATION_MESSAGE);
} catch (SQLException e) {
System.out.println("执行SQL语句异常!");
e.printStackTrace();
}
}
}
}