javaÁ¬½Ó±¾µØÊý¾Ý¿â£¬Á¬½Ó²»ÉÏ¡£¡¢¡¢¡¢¡¢
public class DatabaseOperation {
Connection conn= null;
/**
*
* È¡µÃµ±Ç°Êý¾Ý¿âµÄÁ¬½Ó
*
* @param connHostName Ö÷»úÃû³Æ»òIP Address
* @param connPort Á¬½ÓÊý¾Ý¿â¶Ë¿Ú
* @param dbDBAUserName Á¬½ÓÊý¾Ý¿âDBAÓû§Ãû
* @param dbDBAPassword Á¬½ÓÊý¾Ý¿âDBAÓû§ÃÜÂë
* @return
*/
public Connection connectDatabase(String connHostName,String connPort,String dbDBAUserName,String dbDBAPassword) {
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
String url = "jdbc:sqlserver://" + connHostName + ":" + connPort + ";DatabaseName=master";
conn = DriverManager.getConnection(url, dbDBAUserName, dbDBAPassword);
setConn(conn);
}catch (Exception ex){
ex.printStackTrace();
setConn(null);
}
return getConn();
}
main·½·¨
public static void main(String[] args) {
DatabaseOperation db = new DatabaseOperation();
System.out.println("============"+ db.connectDatabase("localhost", "1433", "sa", "123456"));;
}
¶Ë¿ÚÊÇ1433
Çý¶¯µÄ°üûÓдí£
Ïà¹ØÎÊ´ð£º
ÓÃRandomAccessFileдÈëTXTÎļþ²é¿´Ê±ÊÇÂÒÂ룬ÇëÎÊÓÐʲô·½·¨¿ÉÒÔд³É¿É¶ÁµÄÎļþ£¬²»ÊÇÓÃÆäËûµÄÎļþ²Ù×÷£¬¾ÍÊÇÖ»ÓÃRandomAccessFileµÄ·½·¨ÊÇ·ñ¿ÉÒÔʵÏÖ£¿
Java code:
import java.io.*;
public class RandomAcce ......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
¹¤×÷ÐèÒª Çó´ó¼Ò°ïæд¸ö³ÌÐò
ÎÒÊÇѧC++µÄ ²»¶®JAVA
±àдһ¸öJavaÓ¦ÓóÌÐò£¬¶ÔÓÚ¸ø¶¨µÄÒ»¸ö×Ö·û´®µÄ¼¯ºÏ£¬¸ñʽÈ磺
{aaa bbb ccc}£¬ {bbb ddd}£¬{eee fff}£¬{ggg}£¬{ddd hhh}
ÒªÇ󽫯äÖн»¼¯²»Îª¿ÕµÄ ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......