I am still a newbie in the IT world and have not been working for a long time. However, with my eagerness to learn and my never-ending pace of learning, I have gained a lot in programming~~
I always thought that JavaScript must call server-side code (C# or JAVA) through AJAX if it wants to interact with the database, but recently I discovered that JavaScript can interact with the database directly... The following is a simple call from the database A small example of loading data into the interface (if you have any good suggestions about JS operation data, I hope you can leave them, we can learn from each other and make progress together)~~
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <TITLE> New Document </TITLE> <META NAME="Generator" CONTENT="EditPlus"> <META NAME="Author" CONTENT=""> <META NAME="Keywords" CONTENT=""> <META NAME="Description" CONTENT=""> <script type="text/javascript"> function getData() { //定义SQL语句 var sql = "select obj_id,obj_caption from mw_sys.mwt_om_obj where rownum<5000"; //新建数据库连接对象和数据集存取对象 var ConnDB = new ActiveXObject("ADODB.Connection"); ConnDB.open("Provider=MSDAORA.1;Password=app;User ID=mw_app;Data Source=pms;Persist Security Info=True"); var rs = new ActiveXObject("ADODB.Recordset"); rs.ActiveConnection = ConnDB; rs.Open(sql); //遍历 var s; var rownum=0; var shtml="<table cellpadding=0; cellspacing=0; style='border:solid 1px gray;'><thead><td style='border:solid 1px gray; text-align:center;'>行号</td><td style='border:solid 1px gray; text-align:center;'>作业文本ID号</td><td style='border:solid 1px gray;'>专业编号</td><tbody>"; while(!rs.EOF) { shtml+="<tr><td style='border:solid 1px gray; text-align:center;'>"; shtml+=rownum+1; shtml+="</td>"; for(i = 0;i<rs.Fields.Count;++i) { shtml+="<td style='border:solid 1px gray; background-color:yellow;'>"; shtml+=rs.Fields(i).value==null?" ":rs.Fields(i).value; shtml+="</td>"; } shtml+="</tr>"; rownum++; if(rownum==1000) break; rs.MoveNext(); } shtml+="</tbody></table>"; rs.close(); ConnDB.close(); document.getElementById("data").innerHTML=shtml; } </script> </HEAD> <BODY> <input type="button" value="Table" onclick="getData()"/> <div id="data"> </div> </BODY> </HTML>