JAVAÊý¾Ý¿âÁ¬½Ó
String uid=jTextField.getText();
String upass=jTextField.getText();
try {
Class.forName("oracle.jdbc.driver.OracleDriver");//Òªµ¼ÈëÍⲿ°ü
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@localhost:1522:stuf1dbsid");//×îºóÒ»¸öÊÇoracleµÄsidºÅ
stuf1dbsid sidºÅ scott/tigerµÇ½ sqlΪsqlÃüÁî´® logondbΪ±í ±íÓÐuserid upass
// sql¾ä×Ó Îª select * from logindb where userid='uid' and upass='upass' ""²»ÏÔʾ ''²ÅÏÔʾ ''ÊÇsqlÓï¾äÖпò±äÁ¿µÄ
String sql="select * from logindb where userid='" + uid + "'and upass='" + upass+ "'";
// ¶¨Òåresult
PreparedStatement psmt= conn.prepareStatement(sql);
ResultSet res = psmt.executeQuery();
if(res.next())
{
TestDia t= new TestDia(null);
t.setVisible(true);
}else
{
System.out.println("login error");
}
} catch (ClassNotFoundException e1) {
e1.printStackTrace();
}
catch (SQLException e1) {
e1.printStackTrace();
}
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.ge
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
Ï̳߳ØÖ÷ÒªÊÇÓÃÀ´ ´¦Àí¶à¸öÇëÇóʱ£¬¼õÉÙ×ÊÔ´ÏûºÄ£¬Ìá¸ßÓ¦ÓÃÐÔÄÜ¡£
ÏÂÃæµÄ´úÂëÊÇÀ´×ÔÓÚ ËïÎÀÇÙ£º<<JavaÍøÂç±à³Ì¾«½â>> ÖÐÏ̳߳ØÊµÏÖÔ´Âë, ´úÂë½á¹¹¼òµ¥ÇåÎú£¬¶ÔÓÚÀí½âÏ̳߳أ¬wait(),notify()·½·¨¶¼ÓÐÓÐºÜ ......
Ò»¡¢ ¼ò½é
Berkeley DB Java Edition (JE)ÊÇÒ»¸öÍêÈ«ÓÃJAVAдµÄ£¬ËüÊʺÏÓÚ¹ÜÀíº£Á¿µÄ£¬¼òµ¥µÄÊý¾Ý¡£
Äܹ»¸ßЧÂʵĴ¦Àí1µ½1°ÙÍòÌõ¼Ç¼£¬ÖÆÔ¼JEÊý¾Ý¿âµÄÍùÍùÊÇÓ²¼þϵͳ,¶ø²»ÊÇJE±¾Éí¡£
¶ ......
Berkely DB¶ÔÓڸ߲¢·¢¡¢ÒªÇóËÙ¶È¿ìµÄÓ¦ÓÃÀ´ËµÊǸö²»´íµÄÑ¡Ôñ£¬mysql¾ÍÊÇÓÃBDBʵÏÖµÄ(mysqlµÄºǫ́) £¬mysql¿ì£¬BDB±Èmysql»¹Òª¿ìN±¶¡£BDBÊÇÒ»ÖÖǶÈëʽµÄ¡¢·Ç¹ØÏµÊý¾Ý¿â£¬ËüÓëÆäËûµÄ¹ØÏµÊý¾Ý¿âRMDBS²»Í¬,ËüûÓÐÌṩSQL,¶øÊÇÌṩÁË×Ô¼ºµÄ·ÃÎʽӿڡ£×÷ΪһÖÖǶÈëʽµÄÊý¾Ý¿â£¬ËüÊǽø³ÌÄÚģʽµÄ£¬Ò²¾ÍÊÇ˵ËüºÍÓ¦ÓóÌÐòÔÚͬһÄÚ´æ¿ ......
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.util.Arrays;
public class NumberChange
{
private String strNum;
private String strNumChFormat;
private String strNumT ......