ͨ¹ýjava²éѯÊý¾Ý¿â±í½á¹¹
public static void getConnAndTableStruct() {
Connection connection = null;
PreparedStatement pstmt = null;
ResultSetMetaData rsmd = null;
try {
// mysqlÁ¬½Ó
//Class.forName("org.gjt.mm.mysql.Driver");
//connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
// oracleÁ¬½Ó
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@192.168.12.12:1521:db";
connection=DriverManager.getConnection(url,"manager","manager");
pstmt = (PreparedStatement) connection.prepareStatement("select * from A_STAT");
pstmt.execute(); // ÕâµãÌØ±ðҪעÒâ:Èç¹ûÊÇOracle¶ø¶ÔÓÚmysql¿ÉÒÔ²»ÓüÓ.
rsmd = (ResultSetMetaData) pstmt.getMetaData();
//className = "User";
//tableName = "user";
for (int i = 1; i < rsmd.getColumnCount() + 1; i++) {
//rsmd.getColumnName(i);
//rsmd.getColumnClassName(i).substring(rsmd.getColumnClassName(i).lastIndexOf(".") + 1);
System.out.println(rsmd.getColumnClassName(i));
System.out.println(rsmd.getColumnName(i));
System.out.println(rsmd.getColumnTypeName(i));
System.out.println(rsmd.getPrecision(i));
System.out.println(rsmd.getScale(i));
System.out.println(rsmd.isNullable(i));//0 ²»ÄÜΪ¿Õ 1¿ÉÒÔΪ¿Õ
System.out.println("=============================");
System.out.println("=============================");
System.out.println("=============================");
System.out.println("
Ïà¹ØÎĵµ£º
ǰÌ᣺JDKÔÚ»·¾³±äÁ¿ÀïÓÐÅäÖà 1.Ê×ÏȽ¨¸ö¹¤³ÌTest£¨¼ÙÈç·ÅÓÚD:\java£©½«srcĿ¼ÏµÄÎļþ¿½±´µ½classesĿ¼Ï 2.ÔËÐÐÀïÊäÈëcmd->»Ø³µ 3.ÊäÈëD:->»Ø³µ 4.ÊäÈëcd java»Ø³µ(cdδ´ò¿ªÎļþ¼Ð) 5.ÊäÈëcd test->»Ø³µ 6.ÊäÈëcd classes->»Ø³µ 7.ÊäÈëdir->»Ø³µ£¨dirΪÏÔʾ¸ÃĿ¼ÏµÄËùÓÐÎļþ£© 8.¶Ôÿ¸ö.javaÎ ......
class Tank{
int level;
}
public class Assignment {
public static void main(String[] args) {
Tank t1 = new Tank();
Tank t2 = new Tank();
t1.level= 9;
t2.level= 47;
System.out.println("1:t1.l ......
JavahÉú³ÉJNIÍ·Îļþ
¼ÙÉ蹤³ÌĿ¼ÏÂÓÐbinÎļþ¼Ð£¬bin´æ·Å±àÒëºÃµÄclassÎļþ;
ÔÚbinĿ¼Ï£¬
......\koalaTest\bin>javah -classpath . -jni com.jni.vikitest
È»ºóÔÚ.....\koalaTest\bin ¼´¿ÉÕÒµ½Ò»¸öcom_jni_Calculator.hÍ·Îļþ£¬Éú³É³É¹¦£¡ ......
ClassLoaderÒ»¸ö¾³£³öÏÖÓÖÈúܶàÈËÍû¶øÈ´²½µÄ´Ê£¬±¾ÎĽ«ÊÔͼÒÔ×îdzÏÔÒ×¶®µÄ·½Ê½À´½²½â ClassLoader£¬Ï£ÍûÄܶԲ»Á˽â¸Ã»úÖÆµÄÅóÓÑÆðµ½Ò»µãµã×÷Óá£
ÒªÉîÈëÁ˽âClassLoader£¬Ê×ÏȾÍÒªÖªµÀClassLoaderÊÇÓÃÀ´¸ÉʲôµÄ£¬¹ËÃû˼Ò壬Ëü¾ÍÊÇÓÃÀ´¼ÓÔØClassÎļþµ½JVM£¬ÒÔ¹©³ÌÐòʹÓõġ£ÎÒÃÇÖªµÀ£¬java³ÌÐò¿ÉÒÔ¶¯Ì¬¼ÓÔØÀඨÒå£ ......
Ò»¡¢ ¶¨Òå
·ÅÔÚÒ»¸öÀàµÄÄÚ²¿µÄÀàÎÒÃǾͽÐÄÚ²¿Àà¡£
¶þ¡¢ ×÷ÓÃ
1.ÄÚ²¿Àà¿ÉÒԺܺõÄʵÏÖÒþ²Ø
Ò»°ãµÄ·ÇÄÚ²¿À࣬ÊDz»ÔÊÐíÓÐ private ÓëprotectedȨÏ޵쬵«ÄÚ²¿Àà¿ÉÒÔ
2£®ÄÚ²¿ÀàÓµÓÐÍâΧÀàµÄËùÓÐÔªËØµÄ·ÃÎÊȨÏÞ
3.¿ÉÊÇʵÏÖ¶àÖØ¼Ì³Ð
4.¿ÉÒÔ±ÜÃâÐ޸ĽӿڶøÊµÏÖͬһ¸öÀàÖÐÁ½ÖÖͬÃû·½·¨µÄµ÷Óá£
Èý¡¢ ......